How to add "Sale" tag to products using Compare-At Price in Flow App?

[ivanhoecyc3079]

I wish to create a smart collection that automatically includes all items on sale. The problem is that we are using a 3rd party point of sale system which pushes a compare-at price & a price field for every product, meaning Shopify's smart collection filter of "compare-at price field is not empty" does not work for us. 

Therefore I'm trying to figure out how to automate a product tag for sale items and use that to build smart collections instead using Shopify Flow, or a 3rd party app if necessary.

The condition would have to be when the price field is lower than the compare-at price field. Action = add product tag "ON SALE".

Then in reverse, when the price field EQUALS the compare-at price field, or when compare-at field is NULL or 0.00, Action = remove the product tag "ON SALE".

Earlier forums suggest Flow had a "product updated" trigger, but I can't find this anywhere. I need to be able to do this for products currently in my catalog. 

Thanks so much,

Jacqui

[paul_n · Accepted solution]

You can simulate "product updated" by using Scheduled time trigger and "Get product data" to get recently updated products (or variants). Then you would add that tag for each product that matches your condition. 

This template does something similar but uses metafields. 

https://shopify.com/admin/apps/flow/editor/templates/01905f6c-7315-716b-bbd3-6e085afc7048

[ivanhoecyc3079]

Fantastic, thanks for your response Paul! I've set that workflow up and it seems to be doing the job well enough. 

[jchristo]

I have used this flow exactly as it is but changed the last metafield action to add tag but it doesn't seem to work?  Any insight?

[jchristo]

Nevermind, I think I worked out my issue.  The products hadn't been recently updated, they were previously updated.  Great workaround, thank you!