How to create a collection where the compare at price is greater than the price?

Topic summary

A user is trying to create an automated collection in Shopify that displays products currently on sale by filtering items where the ‘compare at price’ exceeds the regular ‘price’.

The challenge is that all products have values in both price fields, so a simple filter for ‘compare at price greater than 0’ won’t work.

Additionally, they’re interested in whether it’s possible to filter products by discount percentage (e.g., items with more than X% off).

Two other users have encountered the same issue and are also seeking solutions. The discussion remains open with no resolution provided yet.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.

Hello everyone,

we are currently working on how to present items that are currently on sale.

For this I want to create an automated collection where the ‘compare at price’ is greater than the ‘price’.

All products have a price entry in both fields. It is not possible to just say ‘where compare at price is greater than 0’

Also nice-to-know: Is it possible to create a collection for products that have a higher discount than X%?

How can this be done?

Kind regards

V4Y

Just wondering if you found a solution here? I’m trying to do the same thing!

1 Like

Here too. Has any solution occurred?