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
| Column | Needed | What to put |
|---|---|---|
| Handle | Yes | The existing product's handle. Repeat it on every row of that product. |
| Option1 Name | On the first row | The product's first option, such as Size, named as it is on the product. |
| Option1 Value | Yes | The new value, such as XL. |
| Option2 Name / Option2 Value | If the product has two options | Add Option2 (and Option3) columns the same way, such as Color and Navy. |
| Variant SKU | Recommended | The new variant's SKU. |
| Variant Price | Recommended | The 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
How to import it
- Replace the example with your products' handles and the new option values.
- In Bulkvane, open Import, add the file and choose Create and update.
- Click Check file: each new variant is listed before it's created.
- 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