Uploading sale prices from a CSV file
Updated
Use a CSV file when you already have the new prices in a spreadsheet, or when every product needs a different price. In step 2, New prices, choose CSV file.
Step by step
- Click Download CSV template under the upload box. You get a file with your active products and today’s prices already filled in.
- Open it in Excel, Numbers or Google Sheets and put in the new prices. Add or remove lines as you like.
- Save it as CSV (UTF-8) and drop it into the upload box.
- Check the preview, then continue with the dates and extras as usual.
The columns
Only two columns are needed: Variant Price, and either Variant ID or Variant SKU to say which variant each price is for. Keep the header names exactly as written here.
| Column | Needed? | What it is |
|---|---|---|
| Variant ID | ID or SKU | Which variant to change. Write it as ID43444761231449, like the template does, or just the number. |
| Variant SKU | ID or SKU | Works instead of the ID: the app finds the variant with that SKU. If a line has both, the ID decides, unless that ID isn’t in your store (from another store, or broken by a spreadsheet): then the SKU is used. |
| Variant Price | Yes | The price during the sale. |
| Variant Compare At Price | No | The crossed-out price during the sale. An empty cell means none for that variant. Leave the whole column out and every variant keeps the compare at price it has now. |
| Variant Name | No | Only there so you can tell the lines apart. The app doesn’t read it. |
Shopify’s own product export (Products, Export) uses the same column names, so you can put your new prices into it and upload it as it is.
The smallest file that works:
Variant ID,Variant Price
ID44012345678901,19.99
ID44012345678955,12.50
Finding a variant’s ID
Open the product in Shopify, click the variant, and look at the address bar. The number after /variants/ is the ID.
Lines that don’t work
After you upload the file, the app checks every line against your store:
- A line whose ID or SKU isn’t in your store, or whose SKU is shared by several variants, is left out. The promo goes ahead without it, and the list shows which lines they were. For a shared SKU, use the Variant ID instead.
- A line with a price that isn’t an amount (like
19,99or an empty cell), or the same variant twice with different prices, needs fixing before the promo can be saved.
Spreadsheet tips
- Prices use a dot for decimals (19.99) and no currency sign.
- Spreadsheets sometimes change long numbers and codes: an ID can turn into
4.34448E+13, and a SKU like00123into123. Keep theIDin front of each Variant ID, and format the SKU column as text. - Column order doesn’t matter and extra columns are ignored.
- Gift cards are left out. In currencies without cents, prices must be whole numbers.