All things Shopify and commerce
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!
Solved! Go to the solution
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
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
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 😃
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
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
Any update on this feature of entering a percentage in the admin?
Hi Ava,
any update on this feature? as it would be instrumental during my Black Friday Sales
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.
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 😃
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
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!
Not yet, i get the error on this page
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!
@kpvw's app does exactly this, so marked it as a recommended solution.
https://apps.shopify.com/advanced-custom-collections/
How can we install this app for testing into a dev store?
Looking for a solution to this as well!
To learn more visit the Shopify Help Center or the Community Blog.
As 2024 wraps up, the dropshipping landscape is already shifting towards 2025's trends....
By JasonH Nov 27, 2024Hey Community! It’s time to share some appreciation and celebrate what we have accomplis...
By JasonH Nov 14, 2024In today’s interview, we sat down with @BSS-Commerce to discuss practical strategies f...
By JasonH Nov 13, 2024