ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.
"CustomLabel" is the column in File Exchange to populate with your SKU.
http://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeCenter&guest=1
Start with a File Exchange download of your active items, using the "Revise Price and Quantity" download request.
That will produce a File Exchange Formatted spreadsheet of your items, which will include the CustomLabel column.
Make sure that the ItemID column shows all 12 integers, and not scientific notation and not numbers with a lot of trailing zeros (set your spreadsheet column to numbers with zero decimal places).
You can eliminate rows (listings) and columns you don't plan to modify, but you must include the "Action" and "ItemID" columns, along with the "Relationship" and "RelationshipDetails" columns to correctly address the variations.
Add your SKUs to the "CustomLabel" column, save as CSV, and upload the CSV file back to File Exchange.
After you upload your file, you'll get an acceptance email, but that does not mean that your revisions were successful. You'll need to download the results file to see if there were any issues with any of the records in your file.
Thank you so much for this clear cut explanation! Literally spent the entire day reading through the file exchange manual ready to rip my hair out in frustration
Was hoping you might be able to further clarify a few things for me?
Should I add Custom Label numbers to the variations as well, and do the variations have to be listed in the rows directly below the listings they are variations for?
I ask because my listings all have the Custom Label numbers in the titles and I'm hoping to be able to just sort them by title in Excel, copy and paste the title column into an external spreadsheet, filter out everything but the numbers, then copy paste the column of numbers I'm left with back into the Custom Label column on my original spreadsheet.
ORIGINAL
The potential problem I see with this is that at that point all the variations are left at the bottom of the spreadsheet, sans custom labels and item numbers leaving me with no way at that point to sort them back into the original position below their respective listings.
Sorted by title: top half
Sorted by title: bottom half
Maybe I'm just going to have to bite the bullet and copy and past each custom label for all 2000 ads 1 at a time? Or perhaps there is a better way to do this than the method I'm attempting?
Beyond grateful for the knowledge you've already provided.
Thanks, Marc!
Variation rows must immediately follow the master record, so sorting on titles will devastate your variation file unless you have yet another column that duplicates the ItemID, in both the master record and within the variation rows, for sorting back again. You can make up your own columns of data, and, as long as they do not use reserved heading names, File Exchange will ignore those columns.
If you have no need to modify the variations, then you can omit all the variations and the columns associated with them (Relationship and RelationshipDetails).
In that method, if you are only adding the SKU to the master record, the file you upload back through File Exchange needs only three columns (Action, ItemID, CustomLabel) and no variation rows.
If you need a unique custom label (sku) for each variation, you'll need to separately add them to the spreadsheet.
