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 variants CSV template: add sizes and colours

Each row adds one variant to a product that already exists. The Handle says which product; the option values say which new size or colour.
Download the CSV template

Free, no sign-up. Opens in Excel, Numbers and Google Sheets.

The columns

ColumnNeededWhat to put
HandleYesThe existing product's handle. Repeat it on every row of that product.
Option1 NameOn the first rowThe product's first option, such as Size, named as it is on the product.
Option1 ValueYesThe new value, such as XL.
Option2 Name / Option2 ValueIf the product has two optionsAdd Option2 (and Option3) columns the same way, such as Color and Navy.
Variant SKURecommendedThe new variant's SKU.
Variant PriceRecommendedThe new variant's price.

What's in the file

Handle,Option1 Name,Option1 Value,Variant SKU,Variant Price
classic-tee,Size,XL,TEE-XL,21.00
classic-tee,,XXL,TEE-XXL,21.00
Example rows. Replace them with your own before you import.

How to import it

  1. Replace the example with your products' handles and the new option values.
  2. In Bulkvane, open Import, add the file and choose Create and update.
  3. Click Check file: each new variant is listed before it's created.
  4. Apply. Undo this import removes the variants it added.

Tips

  • Use the option names exactly as they are on the product. If a row has an option value but its product has no option name, the row is stopped with a message.
  • Removing a row from a file never deletes a variant. Delete single variants in Shopify admin.

Step by step: How to bulk edit Shopify variants. Every column is in the column reference.

Questions

Can this template create new products?

Only if the handle doesn't exist yet and the row has a Title. To add variants only, use the handles of existing products.

Can I add stock for the new variants?

Yes. Add “Inventory: <location>” columns with the quantities.

Preview every change.Undo any import for 30 days.

Install free