Stamp Community Family of Web Sites
Thousands of stamps, consistently graded, competitively priced and hundreds of in-depth blog posts to read
Stamp Community Forum
Save Password
Forgot your Password?

Welcome Guest! Need help? Got a question? Inherit some stamps?
Our stamp forum is completely free! Register Now!

Ebay File Exchange For Bulk Uploads

To participate in the forum you must log in or register.
Author Previous TopicReplies: 4 / Views: 412Next Topic  
Pillar Of The Community
United States
568 Posts
Posted 10/27/2021   10:37 am  Show Profile Bookmark this topic Add jconey to your friends list Get a Link to this Message
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, Subtitle, GalleryType, ShippingType, PromotionalShippingDiscount, ShippingDiscountProfileID, DomesticRateTable, ShippingCostPaidByOption, AdditionalDetails, C:Denomination, C:Color, 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?
Send note to Staff
Edited by jconey - 10/27/2021 10:43 am

Learn More...
United States
10449 Posts
Posted 10/27/2021   11:12 am  Show Profile Check 51studebaker's eBay Listings Bookmark this reply Add 51studebaker to your friends list  Get a Link to this Reply
You can email the excel file and I will troubleshoot it.
Send note to Staff  Go to Top of Page
Forum Dad
Learn More...
1775 Posts
Posted 10/27/2021   11:52 am  Show Profile Bookmark this reply Add bobby131313 to your friends list  Get a Link to this Reply
There's a lot going on in the backend at eBay. They are ditching some legacy APIs at the end of the year. Finding, Shopping, and Trading APIs are going away and they are telling everyone to migrate to the Browse API asap, which has a ton less functionality. And you must use OAuth now which I have no idea how to do. Ugh.
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
568 Posts
Posted 10/28/2021   09:31 am  Show Profile Bookmark this reply Add jconey to your friends list  Get a Link to this Reply
Thanks for the offer Don.

I've combed through the .xml and version compatibility issues and given eBay all that I found. I'm tired of debugging their files so I'll let them deal with it from here. Now that I can down load the .csv files, (which are considerably different from the .xlsx files) I will continue with .csv until it stops working.
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
568 Posts
Posted 10/28/2021   09:40 am  Show Profile Bookmark this reply Add jconey to your friends list  Get a Link to this Reply
Funny thing... eBay's whizkid even tried to tell me that the ducks subcategory didn't exist so I sent them a screen shot and a link

What's wrong with these people?

Send note to Staff  Go to Top of Page
  Previous TopicReplies: 4 / Views: 412Next Topic  
To participate in the forum you must log in or register.

Go to Top of Page
Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Stamp Community assumes no liability for errors. Copyright 2005 - 2022 Stamp Community Family - All rights reserved worldwide. Use of any images or content on this website without prior written permission of Stamp Community or the original lender is strictly prohibited.
Privacy Policy / Terms of Use    Advertise Here
Stamp Community Forum © 2007 - 2022 Stamp Community Forums
It took 0.23 seconds to lick this stamp. Powered By: Snitz Forums 2000 Version 3.4.05