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 later.
This ensures that any mistakes or unwanted changes are reversible. In other words, if you want to "undo," you can simply upload your backup CSV.
In this article:
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 with the listing details to update.
You can use either an SKU or Item ID for the Item Identifier:
How to make a CSV for editing eBay variations
When updating variations, include a column that contains the parent listing's SKU. The table below shows an example format of a parent and its variations:
CustomSpecific Thread Color
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.
If uploading a CSV from eBay or Report Center,
the CSV may look like this, with the variation SKUs in their own column:
CustomSpecific Thread Color
In this case, the SKU column is also the Parent SKU, and variation_sku will be used for editing variations only. »Step 2 will show how the variation_sku column can be used.
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: Set your Item Identifiers:
Choose whether you are updating eBay listings with SKU or Item ID.
Then, if needed, select the corresponding column in your CSV.
Set variation identifiers
If bulk editing eBay variations,
enable the Update Variations by SKU switch.
Then choose »the column containing the Parent SKUs
If your CSV contains »separate columns for variations and normal SKUs (like a default report from eBay or Report Center), you will need to update variations and parent listings separately:
To edit variations, set the SKU Column to the variation SKU column in your CSV.
Use the same settings as above for variation settings and Parent SKU.
To edit parent listings, use Excel or Sheets to filter out all rows with a variation SKU. This removes all the variations.
Save as a new CSV upload the file without variation settings.
Note: If updating variations and using Item IDs, you will still need a »column for the parent SKU and an SKU column for the variation. It may be worth considering if it is more efficient to only bulk-edit listings with SKUs.
Step 3: Map your CSV:
After clicking the Next button,
make sure the columns in your CSV match ours (and correct any fields if needed).
Then, click the Import & Update button to edit your eBay listings your listings via CSV.
Pro Tip: to prevent unwanted edits, select Don't Import for the fields you are not editing, or delete them from your CSV before uploading.