Collection based on % discount

Solved
Highlighted

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! 

Cheers,
Saro
1 Like
Highlighted
Shopify Staff
Shopify Staff
601 30 96

This is an 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: https://screenshot.click/01-06-oo5nk-ukgcs.gif.

 

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

 

01-29-e2k51-ur1gz

 

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 | Social Care @ Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

2 Likes
Highlighted
New Member
5 0 0
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.
0 Likes
Highlighted
New Member
2 0 1

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. 

0 Likes
Highlighted
Shopify Partner
83 3 8

This is an 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 =)

 

 

 

1 Like
Highlighted

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 

Cheers,
Saro
0 Likes
Highlighted
Shopify Partner
83 3 8

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!

0 Likes
Highlighted
Highlighted
Shopify Partner
83 3 8

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!

1 Like
Highlighted

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

 

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

Cheers,
Saro
0 Likes