Back up your listings:
Before editing your eBay items with a CSV, we strongly recommend backing up your listings by navigating to Insights → Report Center → Custom Report
Use Listings - from eBay as the Report Type
Include all available fields in the report.
Save the settings as a template for faster backups.
This ensures that any mistakes or unwanted changes are reversible. You can "undo" changes by uploading the backup CSV.
In this article:
→ How to make a CSV for editing eBay variations
Step 1: Upload your CSV
Step 3: Map your CSV
What eBay listing details can I edit with a CSV file?
You can edit any field included in the Import CSV feature, with the current exception of images.
To see a list of fields fast, visit the last step of the Import feature,
or see this list of fields and definitions.
Pro Tip: the CustomSpecfic field also works for updating items.
How to create a CSV for bulk editing:
For quick bulk eBay editing, all you'll need is:
a column to identify the listing (Item Identifier)
along the data you want to update.
You can use either an SKU or Item ID for the Item Identifier:
SKU | WholesalePrice | Category |
3GF_65H7 | 57990 | |
55A_Large | 5.16 | |
55A_Small | 4.28 |
How to make a CSV for editing eBay variations
Updating variations requires two kinds of SKUs. One for the parent, and one for the variations. The table below shows an example CSV of a parent and its variations. It would edit the listing's Title, and update the variation quantities.
SKU | Parent SKU | Title | Quantity |
55A_ | Puma T-Shirt | ||
55A_ORNG | 55A_ | 24 | |
55A_PRPL | 55A_ | 61 |
What is a parent listing?
A parent listing is the main listing that contains the variations.
The Parent SKU tells the system which listing the variation is in.
Upload a CSV from eBay or Report Center:
Your CSV may look like the table below, with the variation SKUs in their own column:
SKU | Brand | quantity | variation_sku |
55A_ | Puma | 24 | 55A_ORNG |
55A_ | Puma | 61 | 55A_PRPL |
In this case, the SKU column is the Parent SKU, and variation_sku will be used for editing only variations.
Read a full overview of importing and editing variations with SKUs.
»Step 2 shows how the variation_sku column is mapped.
Step 1: Upload your eBay CSV
Pro tip: review these CSV formatting tips to ensure a seamless upload.
In the eBay Listings Manager, navigate to the CSV Import feature and click the Update Listings button.
In the pop-up, click the Choose a CSV button and upload your CSV file.
Step 2: Chose Item Identifiers
Choose whether you are updating eBay listings with SKU or Item ID.
Then, if needed, select the corresponding column in your CSV.
Variation Identifiers
If editing variations, enable the "Update Variations by SKU" switch and use the following settings:
Update Items By: SKU
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
Learn more about updating variations and the SKU mapping format.
Step 3: Mapping the CSV
Ensure the columns in your CSV match ours
Then, click the Import & Update button to edit your eBay listings your listings via CSV.
Pro Tip: prevent unwanted edits and select Don't Import for the fields you are not editing, or delete them from your CSV before uploading.
Pro Tip: Use Don't Import and a Fallback to directly bulk edit the fields.