Import and Edit eBay Variations with a CSV file

In this article, we review:

Variation and Parent SKUs
Import CSV Format
- → Parent Row data
- → Variation Row data
- Example
Update variations with CSV
- → Update Values
- → Update Listings

Variation SKU vs Parent SKU

Import and Update Listings CSV features require two types of SKUs.

Parent SKUs (main listing)

and Variation SKUs

Import Variations CSV Format

Organize the SKUs in your spreadsheet as shown below:

SKU	Parent SKU
MAIN_LISTING
variation_1	MAIN_LISTING
variation_2	MAIN_LISTING

How does it work?

The first column is the SKU of the row (parent or variation)
The second column uses the Parent SKU to assign the variation to the parent.

Parent Row Info

Only include details that do not change with the variation (i.e., Location, Currency, Title, Description, etc.)

Title	Description	Category
Rope Hammock	Hangs Between Trees	20719

Variation Row

Variation rows should only include

Price, Quantities, UPC/EAN
and the Item Specifics that make that variation unique

UPC	Price	Color
000025	19.99	Grey
000026	24.99	Blue

Example

SKU	Parent SKU	Title	Description	Price	Color
MAIN_LISTING_INFO		Rope Hammock	Hangs Between Trees
variation_1	MAIN_LISTING_INFO			19.99	Grey
variation_2	MAIN_LISTING_INFO			24.99	Blue

Download a sample import CSV

Need Custom Item Specifics for variations? Learn how

Edit eBay Variations with a CSV

Currently, there are two ways to update variations with a CSV in 3Dsellers.

1. Update Values

Use only Variation SKUs to edit prices and inventories (no Parent SKU needed)

Update Values is the simplest variation CSV editor. However, only one data field can be edited per upload.

Example Update Values CSV:

SKU	Warehouse Quantity
variation_1	29
variation_2	41

2. Update Listings:

This feature can edit almost every eBay field using the Variation SKU and the Parent SKU. Read the full walkthrough

Parent listing data and variation data must be edited separately.

If you exported an eBay Listings CSV with variation data, it is ready to edit and re-upload. Variation SKUs will have their own column, where the Parent SKUs are the "SKU" column.

SKU	Brand	category_id	CustomSpecific Thread Color	variation_sku
55A_	Puma	57990	Orange	55A_ORNG
55A_	Puma	57990	Purple	55A_PRPL

When choosing an Item Identifier, enable the Update Variations by SKU switch and use these mapping settings:

Update Items By: Item ID or SKU (use Parent SKU or Item ID field in your CSV)
SKU Column: choose the CSV field with Variation SKUs.
Parent SKU Column: choose the CSV field containing Parent SKUs.

Example: *re-upload exported eBay Listings CSV

Example: upload Import CSV format