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

  1. Click Download CSV template under the upload box. You get a file with your active products and today’s prices already filled in.
  2. Open it in Excel, Numbers or Google Sheets and put in the new prices. Add or remove lines as you like.
  3. Save it as CSV (UTF-8) and drop it into the upload box.
  4. 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,99 or 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 like 00123 into 123. Keep the ID in 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.