Running Sales: Editing Prices and Compare at Prices
In addition to showing a product's price, Shopify lets you display a "compare at price" which shows the original, higher price of a product. You can use our Bulk Product Editor app to quickly set and modify these prices. In this article we'll cover how Shopify handles sale prices and how to edit them with our app.
In order to follow along you should have:
- The Bulk Product Editor app installed
- Products on your Shopify store to edit
- A spreadsheet editing program like Excel or Google Sheets (only required for spreadsheet edits)
How Sales Work on Shopify
Products in Shopify have two fields: Price and Compare at Price. When you create a simple product and just set the price field, that price will show up on your product pages:
In some cases you might want to put the product on sale. In order to do this, you put the original price of the product in the Compare at Price field, and put the sale price in the Price field. The output will vary slightly depending on your theme, but you product pages will now show the sale on them:
This view, where the Compare at Price has a line through it, is only activated if the Compare at Price is higher than the Price. If the Compare at Price is not higher than the Price, the product will show as being priced normally.
Shopify's API requires that 3rd party apps such as the Bulk Product Editor set the Compare at Price field to be either be blank or larger than the Price field. If this condition isn't met, the product variant will not be modified. You can also read more about setting sales prices in Shopify's documentation.
When using the Bulk Product Editor to modify the Price and Compare at Price, you have the option to set the Compare at Price to blank if it is not higher than the price.
Creating a Sale
In order to create a sale using the Bulk Product editor you need to do two things:
- Make sure that the Compare at Price is set to the current Price
- Change the Price field to reflect the discount
Both of these are easy to do with our app, and you can accomplish it using either an in-app edit, or by doing a spreadsheet edit. You can edit each of these fields individually, or both at the same time (saving one of your edits).
Using the In-App Editor to Set up the Sale
To set the Compare at Price to the Price, and then decrease the Price with an in-app edit, open up the Bulk Product Editor app and filter for the products you want to edit. One the next page, choose the following options for the edit:
- Field to Edit: Price
- How to Edit: Decrease by percent
- Decrease by this percent: 20 (for example, if you want 20% off)
- Round to nearest: check this is you want the prices to all end with the same decimal value, like .99
- Modifications to the Compare Price: Set the compare price to the current price
It should look something like this:
Click on Run Edit and your the app will start updating the compare at prices in the background.
Using a Spreadsheet to Set up the Sale
In order to use a spreadsheet edit to set up a sale, you need a properly formatted CSV or Excel file with three columns. The first column will be used to identify the products (usually SKU), and the other two columns are for Price and Compare At Price. Once you have the spreadsheet updated correctly for the sale, simply upload the spreadsheet into the app to complete the edit.
You can use the scheduling feature to set sales to start and end at specific times. You can read our article on scheduled edits to learn more.
Ending a Sale
To end a sale, you just need to revert the Price field to what it was before. You have two ways of doing this through the app:
- Use the undo edit function in the app to revert the price
- Create a new edit that sets the Price field to be 100% of the Compare at Price field
In this article we covered how Shopify manages sale prices and how to start and end sales on your Shopify store. If you would like to learn more we recommend reading:
Finally, you have any other questions please send us an email and we'll help you out!