I need to set up a workflow where, reading from an Excel warehouse file, I have a series of homogeneous products categorized by CATEGORY, PRODUCT, and SIZE. Some products are assigned to customers while others are free and therefore assignable. I need a rule that will alert me when, under the same conditions of:
there is fresher merchandise already assigned that can be replaced with older merchandise.
I am able to prepare the part of cleaning the Excel file, but I am unable to create the rule.
attached an example of warehouse data
Thank you very much for your support.