Quickly modify eBay SKUs (custom labels) with 3Dsellers eBay software.
From the left menu, navigate to: Listings → Listings Manager → CSV Import
CSV-Only Template Downloads:
Download all your eBay SKUs
Navigate to
Listingsfrom the left menu.Filter/ Select all listings.
From the Bulk Actions menu, select
Export To CSV.Generate the report and download it.
Use Google Sheets to Edit the SKUs
The following instructions assume that your inventory includes
variations
and duplicate SKUs.
Additionally, we recommend using Google Sheets to complete this task. There is a particular part of a formula below that does not work with Microsoft Excel.
Step 1: Get Unique SKUs and Merge Variation SKUs
Delete all columns except
skuandvariation-sku.
| A | B |
1 | sku | variation-sku |
2 | ITEM001 | VAR01 |
3 | ITEM001 | VAR02 |
4 | ITEM001 | VAR03 |
In cell C1, enter
SKU.Enter the following formula to C2:
=UNIQUE(FLATTEN(A2:B))The formula will fill the column with unique SKUs.
| A | B | C |
1 | sku | variation-sku | SKU |
2 | ITEM001 | VAR01 |
|
3 | ITEM001 | VAR02 |
|
4 | ITEM001 | VAR03 |
|
Step 2: Edit SKUs
Copy column C to a different sheet.
Do not delete any SKUs.
Tips to Edit SKUs in Google Sheets
1) Use Google Sheets Find and Replace.
2) Use filters to target specific SKU formats.
3) In adjacent cells, use formulas such as =CONCATENATE() to add characters to the SKU. Important: Copy the resulting values and "paste as text" into the original SKUs, overriding the original SKUs. Then delete the formulas.
Step 3: Download a CSV to upload to 3Dsellers
When finished editing, paste the column (from the other sheet) into column D.
In D1, change the column header to
NewSKU.
| A | B | C | D |
1 | sku | variation-sku | SKU | NewSKU |
2 | ITEM001 | VAR01 | ITEM001 | ITEM01 |
3 | ITEM001 | VAR02 | VAR01 | VAR1 |
4 | ITEM001 | VAR03 | VAR02 | VAR2 |
5 |
|
| VAR03 | VAR3 |
Now, download the sheet as a CSV.
Navigate to
File→DownloadSelect
Comma Separated Values (.csv)
Upload and Replace SKUs with 3Dsellers
From the left menu, navigate to:
Listings→Listings Manager→CSV ImportUse the
Replace SKUsbutton to upload the CSV file.
Ensure Mapping is set to use the correct columns:
SKU(capital letters) andNewSKU
