How to bulk edit prices in Shopify
Shopify has two ways to change many prices at once: its bulk editor, where you type each new price, and a CSV file you export, change in a spreadsheet and import again. Here's how each works and where it catches people out.
In Shopify's bulk editor
In Products, tick the products and click Bulk edit. The grid has a Base price column, and Compare-at price, Unit price and Cost per item are under Columns. A product with variants gets a row for each variant, with its own price.
There is no step that raises prices by a percent or rounds them, though, so each new price is worked out and typed by hand. Save writes every change, and a saved bulk edit has no undo.
With a CSV file and a spreadsheet
Export the products from Products, Export, as the CSV for Excel, Numbers or another spreadsheet program. In the spreadsheet a formula can raise the whole Price column by a percent and round it. Then import the file from Products, Import, with Overwrite products with matching handles ticked. Shopify's own CSV guide names the catches:
- A blank cell in a column you keep overwrites that value with a blank, and a price with no value is 0.00.
- A file without the Option1 name and Option1 value columns makes Shopify create a new default variant and delete the existing ones, so keep both when you cut the file down to the prices.
- Sorting the file in a spreadsheet can separate variants and images from their product, and importing a sorted file can overwrite products with bad data that can't be recovered.
- A file over 15 MB has to be split into smaller ones.
Keep the untouched export. Importing it again puts back every column in it, and the other ways back are in how to undo a bulk edit in Shopify.
For a sale
Shopify shows a reduced price through the compare-at price, with the original price in Compare-at price and the sale price in the price. Neither the bulk editor nor an import waits for a start time, so a sale starts when you save, and ending it means putting every old price back yourself.
How AK: Dynamic Pricing, Bulk Edit edits prices
- It raises or lowers prices by a percent, sets them from cost with a markup or a margin or from another price, and rounds them to an ending such as .99.
- It can skip a price that would end up below its cost, when the cost is known, and a compare-at price that would not be above its price.
- Before anything is written, it shows every price before and after, for every variant.
- A sale is an offer between two dates: it starts and ends at the times you choose, can show the saving with a compare-at price, and puts your own prices back when it ends.
- It edits a market's own prices in its price list as well as the base price.
- Every run gets a receipt, and Undo takes a run back field by field.
The Free plan includes 50 product updates every 30 days, each product a run changes counted once. Sales between two dates and a market's own prices come with a paid plan. The field by field detail is on what undo covers, prices that move by rules are in dynamic pricing on Shopify, and the app is on the Shopify App Store.
Questions
Write to me at support@aislekit.app.