Free CSV template
Shopify price update CSV template
Four columns are enough to change prices across your catalog: which product, which variant, the price and the compare-at price. Everything you leave out stays as it is.
Download the CSV template
Free, no sign-up. Opens in Excel, Numbers and Google Sheets.
The columns
| Column | Needed | What to put |
|---|---|---|
| Handle | Yes | The product's handle, the last part of its URL, such as classic-tee. Repeat it on every variant row. |
| Variant SKU | Yes, or Variant ID | Picks the variant. Use a Variant ID column instead if your SKUs aren't unique. |
| Variant Price | Optional | The new price, with a decimal point: 19.00. Decimal commas and currency symbols are converted for you. |
| Variant Compare At Price | Optional | The original price, to show a sale. Must be higher than the price; leave empty to keep the current one. |
What's in the file
Handle,Variant SKU,Variant Price,Variant Compare At Price classic-tee,TEE-S,15.00,19.00 classic-tee,TEE-M,15.00,19.00 linen-shirt,LS-S,42.00,
How to import it
- Replace the example rows with your products' handles, SKUs and new prices.
- In Bulkvane, open Import, add the file and choose Update only.
- Click Check file: every price, old beside new.
- Apply. To end a sale, open the job and click Undo this import. The old prices come back.
Tips
- For a percentage change, use =ROUND(C2*1.1, 2) in a spare column and paste the results back over Variant Price as values.
- Shopify only shows a sale when the compare-at price is higher than the price. Bulkvane warns you when it isn't.
- Updating products you already have? Export them from Bulkvane instead of starting from the template. The export already holds each product's handle, ID and current values.
Step by step: How to bulk edit prices in Shopify. Every column is in the column reference.
Questions
Do I need the product ID?
No. Handle finds the product and Variant SKU the variant. If you have the ID and Variant ID columns from an export, keep them. They're the most reliable match.
Will empty cells clear a price?
No. With Update only, an empty cell leaves the value as it is.
Preview every change.Undo any import for 30 days.
Install free