In this article:
Variation SKU vs Parent SKU
Variation CSVs require two types of SKUs.
Parent SKUs (main listing)
and Variation SKUs
Import Variations CSV Format
Organize the SKUs in your spreadsheet so that each variation row includes the Parent SKU.
SKU | Parent SKU |
MAIN_LISTING |
|
variation_1 | MAIN_LISTING |
variation_2 | MAIN_LISTING |
Parent Row (Main Listing)
Only include data that does not change with the variation.
SKU | ParentSKU | Title | Description | Category |
MAIN_LISTING |
| Rope Hammock | Relax in Trees | 20719 |
variation_1 | MAIN_LISTING |
|
|
|
Variation Row
Variation rows can only include
Price, Quantities, UPC/EAN
Item Specifics that make that variation unique
SKU | ParentSKU | UPC | Price | Color |
MAIN_LISTING |
|
|
|
|
variation_1 | MAIN_LISTING | 000025 | 19.99 | Charcoal |
variation_2 | MAIN_LISTING | 000026 | 24.99 | White |
Example:
SKU | Parent SKU | Title | Description | Price | Color |
MAIN_LISTING |
| Rope Hammock | Relax in Trees |
|
|
variation_1 | MAIN_LISTING |
|
| 19.99 | Charcoal |
variation_2 | MAIN_LISTING |
|
| 24.99 | White |
Edit eBay Variations with a CSV
There are two ways to update variations with a 3Dsellers eBay CSV.
Option 1 - Update Values
Edit price and inventory (no Parent SKU needed, only the Variation SKU)
Update Values is the easiest variation CSV editor. However, only one listing detail can be edited per upload.
SKU | Warehouse Quantity |
variation_1 | 29 |
variation_2 | 41 |
Option 2 - Update Listings
Edit almost any eBay listing detail in one upload. However, parent listings and variations must be edited with separate uploads. Read the full walk-through
The CSV requires an SKU and Parent SKU column, just like the Import Variations format.
SKU | Parent SKU | Price | Warehouse |
variation_1 | MAIN_LISTING | 19.99 | 59 |
variation_2 | MAIN_LISTING | 24.99 | 26 |
If you exported an eBay CSV with variations, Variation SKUs are "variation_sku", and the Parent SKUs are "SKU"
SKU | Brand | category_id | CustomSpecific Thread Color | variation_sku |
55A_ | Puma | 57990 | Orange | 55A_ORNG |
55A_ | Puma | 57990 | Purple | 55A_PRPL |
When you upload the CSV, enable Update Variations by SKU. If the correct column is not detected, you can select it:
