In this article, we review:


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

Did this answer your question?