How can I create discount-based collections?

[TheSaroSnake]

Hi folks,

I want to create sale collections such as 10%, 25%, 50% off. I was wondering if there is a way to create smart collections based on a condition that looks at the compared price and looks for the % off, but couldn't find this option in collections conditions. 

Is this possible, and if not, are there alternatives to create this?  

Thanks for your help! 

[Ava · Accepted solution]

Hey @TheSaroSnake 

Ava here from Shopify.

I'm afraid that is not possible at the moment, as the compare at price would need to be a figure entered manually rather than setting a percentage off the original price. As a workaround, you could tag a product with the percentage instead? You could do this in bulk with the bulk editor in the admin.

If you added the percentages as tags to the products, you could create an automatic collection based on the tags instead

Would that work for you as a workaround? 

I can also bring this to the attention of our development team as a possible feature of the platform in the future. I can definitely see the benefits of entering a percentage in the admin rather than doing the calculations first and then entering a figure. I'm sure this would be an advantage for lots of different merchants in their daily workflow! While we would not have a specific timeline for how long the request would take to be reviewed and/if it would be implemented, you can definitely keep an eye on our announcements page. We will post any new updates or developments there.

Let me know what you think of that workaround!

Ava

[Ava · Accepted solution]

Hey @TheSaroSnake 

Ava here from Shopify.

I'm afraid that is not possible at the moment, as the compare at price would need to be a figure entered manually rather than setting a percentage off the original price. As a workaround, you could tag a product with the percentage instead? You could do this in bulk with the bulk editor in the admin.

If you added the percentages as tags to the products, you could create an automatic collection based on the tags instead

Would that work for you as a workaround? 

I can also bring this to the attention of our development team as a possible feature of the platform in the future. I can definitely see the benefits of entering a percentage in the admin rather than doing the calculations first and then entering a figure. I'm sure this would be an advantage for lots of different merchants in their daily workflow! While we would not have a specific timeline for how long the request would take to be reviewed and/if it would be implemented, you can definitely keep an eye on our announcements page. We will post any new updates or developments there.

Let me know what you think of that workaround!

Ava

[tdc]

I need this feature too. My products are linked to amazon and I do not control the product prices and I need a collection condition based on percent discount. I hope Shopify will consider adding this functionality soon.

[alessioviola24]

Any update on this feature of entering a percentage in the admin?

[uswfrank]

I been looking into this as well and I think your going to have to do it on the excel file. Maybe search only the items with a compare at price, export it, enter some kind of formula to show what the percentages are, and then add a tag? This way you can make collections based off the tag, ie 20%, 25%, etc... If I come up with anything Ill leave an update. 

[kpvw · Accepted solution]

Just updated our app Advanced Collection to include this feature - https://apps.shopify.com/advanced-custom-collections

You can create a collection that includes / excludes products which has a discount percentage (i.e. price difference between 'price' and 'compared at price', divided by 'compared at price') within a certain range that you choose. Whenever you add or update a product, the app will do a check and syncs that collection automatically.

Hope it helps and do try it out with a 7-day free trial 😃

[TheSaroSnake]

Hi @kpvw 

Thank you for sharing this app. I am looking for something like this on another project too that needs to exclude tags. 

I tried to install it but I get a Server Error (500) 

Can you let me know when this is resolved so I can try again? Thanks 

[kpvw]

Hello @TheSaroSnake,

Sorry for the error, might be due to us updating the server just now. Tested and seems to be working our end.

Maybe you can try again and see if it works? Thanks!

[TheSaroSnake]

Not yet, i get the error on this page

https://sadvcoll.voidworks.co/app/login/finalize/?code=271fbaded3a6fb1cf090c113a030c75f&hmac=097d9b5...

[kpvw]

Hello @TheSaroSnake, I checked our logs and seems like it might be an issue with the availability of the Shopify API with your shop. 

Response(code=423, body="b'{"errors":"This shop is unavailable"}'", headers={'Date': 'Fri, 03 Apr 2020 13:18:05 GMT...

Response(code=423, body="b'{"errors":"This shop is unavailable"}'", headers={'Date': 'Fri, 03 Apr 2020 13:20:44 GMT...

Let me contact Shopify Support to find out why. In the meantime, maybe you can try with the other project / shop you mentioned? Thanks!

[TheSaroSnake]

@kpvw's app does exactly this, so marked it as a recommended solution. 

https://apps.shopify.com/advanced-custom-collections/

[_realityengine]

How can we install this app for testing into a dev store?

[pushpinder]

Looking for a solution to this as well!