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 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 values for both fields are equal, it will look like in the first screenshot above. You can also read more about setting sales prices in Shopify's documentation.
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 the same thing using either the in-app editor, or by doing a spreadsheet edit. Doing a spreadsheet edit has the advantage of letting you edit both the Price and the Compare At Price at once.
Using the In-App Editor to Set up the Sale
To set the Compare at Price to the current Price 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: Compare Price
- How: Set as percent of Price field
- Percentage: 100
It should look something like this:
Run that edit and then create a new edit, filtering for the same products. In this edit you'll want to use the following option:
- Field: Price
- How: Change by Percent
- Percentage: 50 (for example, if you want to cut the price in half)
This edit will look like:
Once both edits complete your sale should be launched!
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.
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
Either option will work, you can choose whatever's easiest for you.
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!