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

Shopify Discussion

Topic summary

Goal: Apply a coupon to clearance products priced ending in $.90 (e.g., 89.90, 29.90).

Attempted approaches: The merchant tried building a collection using a wildcard on the Compare-at-Price field and using Shopify Flow (automation) to auto-tag products based on prices ending in .90. Both approaches hit limitations.

Suggested solution: Manually tag qualifying products (e.g., “clearance-90”) and build a dynamic collection based on that tag. Then apply the discount to that collection.

Automation option: Use a third-party auto-tagging app (e.g., “Auto Tags”) to detect prices ending in .90 and apply the tag automatically, since Flow reportedly can’t directly target price endings.

Status: No native wildcard/Flow method confirmed. Workaround is manual tagging or app-based auto-tagging, after which the coupon can be applied to the resulting collection. Unresolved pending implementation/confirmation by the merchant.

Summarized with AI on December 13. AI used: gpt-5.
1

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

2

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.