automated collection for items on sale (price drop)

Solved
Highlighted
New Member
2 0 0

Hi,

Is there an automated collection for items on sale (price dropped)? 

Do I need to do some programming for this?

0 Likes
Highlighted
Shopify Partner
1445 195 525

This is an accepted solution.

If you have Shopify Plus you can use the Launchpad App to schedule sales on specific collections. If you're working on any other plan though, the way I would typically set up a sale would be to create a collection called "Sale" that imports products automatically that have a "sale" tag added. Then I'd export my products to a CSV that I want included in the sale, add ", sale" to the tags column, copy my variant prices over to to the variant compare at price column, then do a calculation in the price field to give you the percentage off. Say you wanted to give 20% off, I'd make the variant price column:

 

= CompPrice * .8

 

then copy that formula down the column and format the number. 

 

When I wanted to start the sale I'd upload that CSV and overwrite the products, then when that sale was over I'd reupload the original csv and overwrite the products again.

If my solution helped you, please like and accept as solution!
If you'd like to make any edits to your store, please send me a personal message and we can discuss what you'd like to accomplish :D
Highlighted
New Member
2 0 0

Great thanks, I'll try that out:-)

0 Likes
Highlighted
New Member
11 0 0

If you don't have Shopify plus, (or you do.. ) you can use the this app to create an automated Sale collection based on a simple condition such as discount % or even more advanced such as "discount > average discount" and more.
Give it a try and see if it gives a solution

Regards

0 Likes