Yes, it is possible to update your listing variations directly from a CSV file. You can add new variations and delete existing ones in the same import. This guide walks you through both.
CSV Format Overview
Here is a quick overview of how your CSV rows should look. Every row must have the same number of columns, and the DeleteVariation column should always be included once you start using it.
SKU | Parent SKU | Price | C:Color | DeleteVariation |
ITM001 | (empty) | (empty) | (empty) | (empty) |
variation-sku-1 | ITM001 | 189 | Blue | (empty) |
variation-sku-4 | ITM001 | 434 | Grey | true |
variation-sku-5 | ITM001 | 199 | Yellow | (empty) |
Red row = variation to be deleted. Green row = new variation being added. White/grey rows = no changes.
How to Delete a Variation
To remove a variation from your listing, you need to add a DeleteVariation column to your CSV file and mark the row you want to remove.
Steps:
Open your CSV file.
Add a new column at the end called DeleteVariation.
On the row of the variation you want to delete, set the value to true.
Leave the DeleteVariation cell blank on all other rows.
Example: If your listing has Blue, Red, and Grey variations and you want to remove Grey, find the row with the Grey variation SKU and set DeleteVariation to true. Blue and Red rows stay unchanged.
How to Add a New Variation
To add a new variation, simply add a new row to the CSV with all the required information for that variation.
Each new variation row must include:
SKU (a unique identifier for this variation)
Parent SKU (the SKU of the main listing this variation belongs to)
Price
Warehouse Quantity
Variation specifics (e.g. Color, Size) and any variation images
Example: To add a Yellow variation to an existing listing, add a new row with a new SKU (e.g. variation-sku-5), the Parent SKU of the listing, the price, quantity, Color set to Yellow, and a product image URL.
Doing Both in the Same Import
You can add and delete variations in the same CSV file. Just make sure:
The parent listing row (e.g. ITM001) is always included.
Rows you want to keep are included as-is with no value in DeleteVariation.
Rows you want to delete have DeleteVariation set to true.
New rows are added at the bottom with all required fields filled in.
Tip: A template file is attached to this article. It shows a real example with a deletion (highlighted in red) and a new variation being added (highlighted in green). Use it as a reference when building your own import file.