Extract your eBay Variations in bulk with this free online scanning tool.
Automate the tedious job of renaming variation groups. Fix your listings in minutes.
This tool will download your simple-variation or multi-variation listings in a spreadsheet format
that is ready to upload to eBay with your variation revisions.
The tool can additionally capture the variation photos and provide a download and archiving option.
Overview
This tool will scan items found publicly on eBay without accessing your account,
and can not search completely out-of-stock items, since those items are not publicly viewable;
although listings that are not completely out of stock will still return the data for any variations with zero inventory.
A report will be generated in eBay's File Exchange format that will include variation details.
The tool will retrieve and scan up to 10,000 items (variations contribute to that total)
and, out of those 10K items, will return only those items that have variations.
Use the search criteria to reduce the search range if you have more than 10,000 items,
thus creating subgroupings based on category, price, or date order.
You may wish to terminate markdown sales prior to revising affected listings so that the tool
can capture your original pricing instead of your markdown pricing.
File Exchange Data Instructions
Sellers may subscribe to eBay's File Exchange on these sites. The Euro sites have certain requirements,
which might include: business seller account, 90 days on the site, over 50 sales per month.
US |
CA |
AU [
UK |
DE |
FR |
IT |
AT |
ES ]
Open eBay's File Exchange Center for your site: US |
CA |
AU |
UK |
DE |
FR |
IT |
AT |
ES
Download your Active Listing report through File Exchange (as illustrated below) and save the CSV file to your computer.
Open that CSV file using Notepad or a text editor, choose *FILE EXCH CSV from the country list on this tool,
and paste that code into the box that appears. Click the "Use CSV List" button to start the scan.
Please note that the File Exchange list is sorted within your browser.
Too large a file along with too many open pages and applications may cause the browser to appear to freeze.
Report -
A report can be generated with the originally downloaded variation data for archiving and self-editing,
or a report can find and replace the name of an attribute group as part of a "renaming" revision file.
Report options include:
Delimiter (spreadsheet file format):
Tab-delimited (handy for pasting from the screen into an open spreadsheet that can be saved as a CSV file).
Comma-delimited (best for saving to a file that will be later opened by a spreadsheet tool or that will be directly uploaded to eBay).
Semicolon-delimited (Euro version of a Comma-delimited file).
Report type:
Report Only — a spreadsheet of your current data with no renaming. Other replacement and sorting selections will apply.
Rename Variations — fill in the old variation name and the new variation name, and the report
will include only those listings that have the old variation name. The tool will also generate
the rows to delete and the rows to add, as required for a Seller Hub upload.
Rehost Photos — Same as Rename Variations, but additionally replaces the image domain and path
with a placeholder string that can be edited in a spreadsheet, and supplies the same image name
that will be assigned to the zip images in the zip window.
Use this feature if archiving photos for rehosting to apply to the same listing.
Find/Replace Variation Name:
There are two slots: "find" what is in the first slot and "replace with" what is in the second slot.
This will only affect the variation name in the Rename report and in the Rehost report.
No other fields are searched.
Only those listings that match the variation name will be returned in the rename report.
If you leave those slots empty, you'll get the full revision structure with duplicated rows
so that you can manually rename in your own spreadsheet if you prefer.
Find/Replace Condition Number:
eBay has limited the condition numbers in some categories, like sports cards.
Up to four numbers can be changed in one pass to
"find" what is in the first slot and "replace with" what is in the second slot.
This will only affect the condition number. Nothing else.
These changes are applied in all three reports (Report only, Rename, and Rehost).
Leave empty if no changes are required. Leave unused rows empty.
Will not affect the number of items returned in the report.
Add extra columns:
In some cases, sellers can not revise listings due to mandates like Item Specifics.
The tool will allow the addition of four extra columns for configuring missing data
to get past the block imposed by the mandate.
Identify the required header format and data prior to adding new columns.
Warning: If adding an item specific column, ALL item specifics will be wiped out
except what is in the new columns.
Use these columnns for Item Specifics only if locked out,
as you will need to replace your item specifics afterwards.
(Use the Item Specifics Scanner to create an archive first.)
If placeholder data is used to satisfy mandates,
be sure to make corrections to the data as soon as practical after the revision.
Picture URLs:
eBay's bulk revision process does not currently allow a mix of self-hosted and eBay-hosted photos,
so we need to divide the job based on the image hosting type to avoid conflicts.
Currently, eBay's API is returning original self-hosted URLs, even when the images have successfully transloaded to eBay-hosting (EPS)
and display EPS photos in the listing. We are trying to find a way to deal with this. Until then, if your scan shows a mix of photos,
it is best to divide the issues with this filter and decide how to separately address each group.
All Listings — Don't check the photos.
eBay only — Display those listings with only eBay-hosted (EPS) photos.
Self-hosted only — Display those listings with only self-hosted photos.
Mixed only — Display only those listings with a mix of eBay-hosted and
self-hosted photos (which are likely to cause a problem).
Sort:
The order of options in the variation drop list can be rearranged by changing the order of their appearance in the master record.
Only the master or parent record affects the sort order.
The variation rows do not affect the order and will not be rearranged.
Alphabetic sort — The option list will be sorted alphabetically,
beginning with the first character.
Numeric sort — The option list will be sorted numerically using numbers that
appear within the first 8 characters of the option name.
It does this by capturing the first 8 characters and tossing out anything that is not a number,
and then sorting by the numbers that remain, using natural numbers (3 appears before 11).
This only affects the sort order. The name itself remains unchanged.
Start after — A character or common group of characters can be chosen
as a starting point for the sort.
If the box is left empty, the sort will begin with the first character.
If characters are entered, they will set a marker for starting the sort.
The option name will be sorted after the first occurrence of that marker.
A simple regex can be used in this field,
/../, if surrounded with slashes.
The sort is case insensitive.
On a side note, the variation photos are assigned by the name that is attached to the photo,
not by the row on which they appear in the report, so don't be alarmed if photos are
NOT on the same rows as the variation options to which they are assigned.
Photo assignments are valid on any row, in any order.
Download or Copy:
The report option will produce spreadsheet reports that can be downloaded
or can be pasted into an open spreadsheet or into a text file.
Select the tab format if pasting directly into an open spreadsheet,
or use the comma form (or semicolon format for euro) when downloading as a csv file
that can be opened later in a spreadsheet tool or that can be uploaded to Seller Hub.
Variation Image List:
The tool additionally creates a separate spreadsheet with the URLs of eBay photos
used in the master record and original variations.
This list can be used to created a downloadable zip file of photos for the selected listings.
IMPORTANT - Before saving CSV data within your spreadsheet tool, or after making any changes and resaving, be sure that the number columns display as numbers and not as exponential notation.
[Screenshot]
If you see something like 1.63E+11 in a spreadsheet column, right-click the column header, choose "Format cells", and change the format to "Number" with zero decimal places.
Pay particular attention to columns that contain the Item ID and long numbers like UPC/EAN.
You will have to make these changes every time you open the CSV. To preserve your number changes, instead of fixing every time, save the file as XLS. You can export a CSV from that file later.
If you don't convert the exponential numbers to whole numbers prior to saving, your long numbers will be converted to useless numbers with a lot if trailing zeros, like this: 162260000000.
Or they may appear in your file as 1.63E+11 and your file will be rejected by eBay.
Zipping Variation Photos -
Some users may wish to archive their current master and variation photos prior to updating variations through eBay's bulk uploader.
After a report has been run, the lower zip window will include the data necessary for zipping the image files.
Zipping requires several steps.
First, you will prepare a copy of the report on our server by clicking the button to "Prepare Zip File".
When the file is ready, a new button will appear so that you may "Send to Zip tool".
The Zip tool will be launched in a new window, your prepared file will be loaded, and you can process your image file on that tool.
Those zip files can be archived on your computer.
Uploading to eBay -
The reports are generated in eBay's File Exchange format for uploading directly through eBay's Seller Hub as a revision template
[Screenshot].
eBay has size limits to be aware of:
New users are limited to 5000 rows of data per day (when totaling all spreadsheet files).
Experienced users can request an increase.
A single spreadsheet can not exceed 150,000 rows.
A single upload file size can not exceed 14.9MB.
Because the variation spreadsheet produced by this tool doesn't contain many columns, the file size will not likely be an issue;
however, the daily limit may be easily reached, particularly if there are multiple attempts to upload files.
If you see something like 
eBay has size limits to be aware of: