Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

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

ColumnNeededWhat to put
HandleYesThe product's handle, the last part of its URL, such as classic-tee. Repeat it on every variant row.
Variant SKUYes, or Variant IDPicks the variant. Use a Variant ID column instead if your SKUs aren't unique.
Variant PriceOptionalThe new price, with a decimal point: 19.00. Decimal commas and currency symbols are converted for you.
Variant Compare At PriceOptionalThe 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,
Example rows. Replace them with your own before you import.

How to import it

  1. Replace the example rows with your products' handles, SKUs and new prices.
  2. In Bulkvane, open Import, add the file and choose Update only.
  3. Click Check file: every price, old beside new.
  4. 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