ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.
The prior post with the instructions contains a link to the tool
If you try it on a small listing as a test, please let me know your results.
I certainly must apologize. It looks like I spelled the link wrong. This is the correct link to the tool:
https://www.isdntek.com/ebaytools/VariationScanner.htm
There will be another update tomorrow.
It sounds like the header row may have been lost.
Here are instructions for the tool:
- Enter your Username
- Enter your site
- Click the Get Items button.
When the scan completes, set the report options as follows:
- Delimiter: Comma
- Type: Rename Variations
- Filter: eBay URLs
- Replace: [old name here]
- With: [new name here]
- Sort: No Sort
(those settings will find the items that have the old name you selected)
- Click the "Build Report" button.
- Click the "Download Report" button to download the file.
- Save the downloaded file to your desktop where you can find it.
(If your browser makes you open the file instead of saving it, and you have to save the file that way, the ItemID column will probably display exponential numbers. Right-click "format cells" on that column and change to Numbers with zero decimal places before saving the file. See image below. You don't have to make that change if you are just looking and not saving.) - Go to eBay's Seller Hub upload page and upload the saved file.
You can manually edit out the listing rows you don't want revised; but using the find/replace should pull in only the listings that match the find/replace. If you want to update only some of the listings that matched, then delete the item rows you don't want, either using your spreadsheet tool or by editing the report directly before downloading the report.
If there are only a few listings you want to change, use the search box at the top of the tool to pull in only a select few listings. The item number would be entered like this:
123456789012
and multiple item numbers would be searched like this (the limit is around twenty):
(123456789012, 234567890123, 4567879012345)
Then when you click "Find items", only those specified items will be pulled into the tool.
While learning, I would recommend picking just one listing using the search option. When that loads, take advantage of find/replace in the report. Then you won't have to manually edit your spreadsheet. Download that file and upload to Seller Hub.
When uploading the file to Seller Hub, a small status box will overlay the bottom left corner. That status will report success or failure, but it only refers to the acceptability of your file. If the upload was successful, your listing may be revised, or not. (You can check the listing itself. But it is best to check the status report.)
Your upload job will appear as a new entry on the Seller Hub page where you are uploading, and, over to the right, you'll see the Status and Action. Use the Action to "Download response file". This is a spreadsheet file that will contain any messages associated with the revision. Warnings and errors will be reported there, and may include other issues with the listing that must also be addressed.
The only valid condition code for sports cards seems to be 3000, so you will need to edit your file to change your condition numbers (or maybe I need to put that option into the tool and make it even more complex, LOL). I see that you are using 2750 and 0. The 2750 must be changed to 3000. I don't know if 0 can remain or must also be changed.
The Store warning is not related to your file. That is a warning that your listing was originally created as a store listing. eBay will automatically make the change from Store Fixed Price to Basic Fixed Price, so that message is advisory only and won't affect your revision.
Make the condition change in the same revision file that is changing the variations. Recall that you can edit the listing online and make all changes at the same time. An uploader revision works the same way to avoid the chicken/egg problem.
Don't despair, You are so close! All you have to do is change the 2750 to 3000. You can change that right there on the tool before you download the file from the tool.
Then upload again in Seller Hub.
