Solved

Collection based on % discount

TheSaroSnake
Shopify Partner
55 1 7

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
Accepted Solutions (2)

Ava
Shopify Staff
1161 78 197

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.

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

View solution in original post

kpvw
Shopify Partner
96 3 18

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 😃

 

 

 

View solution in original post

Replies 11 (11)

Ava
Shopify Staff
1161 78 197

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.

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

tdc
Tourist
5 0 1
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.

uswfrank
Visitor
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. 

kpvw
Shopify Partner
96 3 18

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 😃

 

 

 

TheSaroSnake
Shopify Partner
55 1 7

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
kpvw
Shopify Partner
96 3 18

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
Shopify Partner
55 1 7
kpvw
Shopify Partner
96 3 18

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
Shopify Partner
55 1 7

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

 

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

Cheers,
Saro
_realityengine
Shopify Partner
19 0 5

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

_realityengine_0-1707101689285.png

 

// realityengine.design

pushpinder
Shopify Staff (Retired)
1 0 0

Looking for a solution to this as well! 

To learn more visit the Shopify Help Center or the Community Blog.