Create Sale Collection

Shopify Discussion
,
1

Is there another way to create a sale collection besides just having “compare-at-price” greater than 0?

We dropship several brands and from what I can tell the “compare-at-price” only populates the first time we sync a new product and does not change if the supplier changes the field later. Plus some suppliers enter a “compare-at-price” for all products and some only for sale items. Ideally we would be able to create a collection that automatically adds products when “price” is less than “compare-at-price”, but since that’s not an option, does anyone have another idea?

2

Hi @Newbie10
You can tag products “on-sale” and create collection based on that
Thanks!

3

Thanks!

I should clarify that we have multiple partners who put products on sale on their end and we don’t always know. So they may chance the “price” field and that does update on our end, but the “compare-at-price” remains whatever it was when we first synced the product. So I’d like to populate a “compare-at-price” for all products on my end, then as suppliers change the “price” on their end for various sales, capture the products where “sale” price is less than “compare-at-price”. Is there a way to auto-populate a tag (and then also have it removed) based on such parameters?

4

I don’t know about this but tags can be alternate way if you can’t control the compare price, you can try shopify flow of product update if that can help you somehow

5

In Shopify automated collections, you can only compare variables like product price/compare at price to values known ahead of time.

You can’t create an automated collection with 2 variable numbers.

Instead, you could:

  1. Create an automated collection containing products with a specific tag
  2. Use Shopify Flow to create an automation (or build a custom app with a webhook) that runs when a product is updated, and adds/removes the tag based on whether the compare at price is greater than the sale price.

Best,

Tobe

6

I’m having the same issue. There is no way to create a collection where compare at price is greater than price. It seems pretty basic and a huge miss for them not to have this option. Has anyone figured out how to workaround this?

7

Hi @Newbie10

Use an automatic collection with a tag

Create a private automation (via an app, Flow, or a script) that checks each product’s current price vs. compare-at price.

If price < compare_at_price, add a tag like on-sale.

Then build a collection that automatically includes all products tagged on-sale.

Apps like Shopify Flow (free if you’re on Shopify, Advanced, or Plus) can do this. Otherwise, you’d need a small custom app/script that updates tags.

Create a smart collection with a manual condition

If your suppliers are inconsistent, one workaround is to standardize at the product import step:

When syncing products, use your integration tool (like DSers, Syncee, Spocket, etc.) to set rules for how compare-at-price is populated.

Example: only set compare_at_price when the item is actually discounted.

That way, Shopify’s built-in “Compare at price > Price” condition will start working properly.

Note: If you’d like my help with these impliment, feel free to contact me at devcodersp@gmail.com.