Create Collection based on Price ending in $.90 for coupon to apply to

[stansshoes]

We are new to Shopify would like to create a coupon code for any of our clearance items that end with a price of $.90.  The price could be $89.90 or $29.90 for example.  I've tried to create a Collection but I'm unable to use that as a wildcard in the Compare-At-Price field.  I've also been playing with the Flow app and was hoping to have a Clearance Collection automatically created based on a tag that Flow would put on by looking at the Compare-at-Price ending in $.90.  I've hit a dead end there as well.  

Does anyone have any experience using Flow that could help figure this out?

Thank you,

Andy

[EcomGraduates]

To set up the coupon for items ending in $.90, you can manually tag those products (e.g., "clearance-90") and then create a dynamic collection based on that tag. Flow can't automatically target price endings like $.90, but this manual tagging approach will let you create a collection and apply the coupon.

Alternatively, apps like "Auto Tags" could automate this tagging process. Once your collection is ready, you can easily apply the discount to it.