Is it possible to create a dynamic Shopify collection for items with discounts of 50% or higher?

[Prabhu2]

I already tried this. But this only creates a list of sale items. 

https://help.shopify.com/en/manual/products/collections/smart-collections/examples

From your Shopify admin, go to Products > Collections.

Click Add a collection.

Enter a title and description for your sale collection.

In the Collection type section, click Smart.

Select all conditions.

In the first drop-down list, select Compare-at price.

In the second drop-down list, select is not empty.

[gsouf]

Hi @Prabhu2 !

The Shopify native smart collection with “Compare-at price is not empty” creates a list of sale items, but it can’t filter by how big the discount actually is.

With our app  Smart Collections Pro, you get a configurable filter called “Discount is at least X%” that lets you automatically create collections of products discounted by any percentage you choose.

This gives you much finer control over your sale collections without manual tagging or extra Flow steps.

Full disclosure: I’m on the Smart Collections Pro dev team. We have a free trial if you’d like to test it on a few items first without impact on your existing collections.

[tim]

Unfortunately, Smart collections are not that smart.

If your criteria product.price < product.compare_at_price / 2, then you can do that with Flow.

Flow can be like this -- flow and Code step:

Unfortunately, Flow has no trigger for price change, so you can either manually cycle your product to Draft and back to Active after editing price.

Or maybe can create a separate flow to run every 10 minutes and cycle the status of products updated in the last 10 minutes so that first flow runs on them.

(Flow export attached -- had to rename them to  .csv to upload, so rename them back to .flow to import)

These are Proof of Concept and may need further testing.

[Prabhu2 · Accepted solution]

Thank you so much Tim. Ideally, it would have been nice to calculate discount and  filter items on discount percentage. But it included creating metafield and separate flow was required. I did found a template "Track percent off a product using metafield" in the flow app but I could not make it work. 

The process you have suggested works. This is very helpful. Providing the downloadable format was very kind of you.

I manually changed the status of the products  & I now have the list of products that are equal or more than 50% off.

Many Thanks

[tim]

What's wrong with the template? Would be interesting to have a look...

[Prabhu2]

This is the template I found, but I could not make it work. I have uploaded it as csv if you want to look at it.