With the exception of odd pieces here and there, I have been using File Exchange on eBay
for bulk uploads.
It's been a couple months and I was prepping another bulk upload of a couple thousand items.
Recently I went to download a new template for a different subcategory and found that they have changed their templates and presumably API. Columns and column headers are different with a lot of changes.
I tried several subcategories under stamps and a couple others as well. All with the same results. They offered an .xlsx file (no choice) and it offers drop-down lists in individual fields (columns) and conditional formatting which color codes entries as a checksum of sorts. Sounds fine but the files downloaded ALL error and strip out the color coding at least.
I asked if it was as versioning problem I was using Excel 2013. I didn't really get an answer from eBay
other then try converting it to a .xls file. Excel 2013 accepts both so this isn't really an answer but the error went away. This is really a false test as the only way I can convert it is to open the .xlsx which strips the error causing features off. I also got the same errors on a different machine and Excel 2016.
I compared the column headers and find that they don't match up and some names have changed. 47 columns in the new compared the the old 52 columns and some of the missing are fields that I use.
Missing columns included: StoreCategory
, PromotionalShippingDiscount, ShippingDiscountProfileID, DomesticRateTable, ShippingCostPaidByOption, AdditionalDetails, C:Denomination
, C:Year of Issue
, C:Cancellation Type
, C:Modified Item, C:Modification Description, C:California Prop 65 Warning.
New columns include: P:UPC, P:ISBN, P:EAN, P:EPID, C:State
, C:Features, C:Brand, Category name. Most of which are useless for selling stamps.
I was told by eBay
: 'the old files I already have might work for a while
' and 'You'll have to manually change column headers or import them from the old file as needed and that should work until it doesn't
WHAT? Not very helpful eBay
I've been struggling with this for a week with multiple downloads. Today, I tried downloading fresh template from a different subcategory and this time it offered .csv as a file format. Guess what it's the old file and format! I tested an upload and it worked!
So, If you are using file exchange and have troubles with the .xlsx file try the .csv file. It seems to me that eBay
is trying to improve the process but as usual they are using the sellers as guinea pigs rather than proper per-release testing.
The re-emergence of the .csv file might be a temporary fix to address complaints? If so, it might not last as they seem determined to make the new files the standard.
I talked to a couple others that I know and they see the same thing. I have seen them do testing releases on particular servers in the past. They are continuing to tweak the .xlsx files as I see minor changes in the columns downloaded a week ago and today.
Have any of you seen this or had a similar problem or is it just a few of us that may be on a particular server?