Need help with an upload file
Hi, I am trying to list over 10,000 items so I need to get an import file working. We use Shopify for our website, so I have exported 1 item in an Ebay formatted file out of Shopify, and when I upload it to Ebay, I am getting an error code #37 "Error - Input data for tag <Item.ShippingDetails> is invalid or missing" . My research tells me there is either data missing, or shipping data inconsistent with other shipping data cells. Can anyone tell me what is wrong with this file? I pasted in a screenshot of the shipping related columns only. Thanks in advance for any assistance!
*we offer free shipping using USPS Priority Mail as primary and UPS as secondary.
3 comments
kensgiftshop
·3 years agoDoes your listing limit allow you to list 10,000 items?
Since you haven't sold anything in over a year, your limits will be pretty low.
shipscript
·3 years ago@thelpandtoys
Below is an example of what is in the <Item.ShippingDetails> container (the API labels below correlate to the FileExchange labels used by your spreadsheet, although nomenclature is slightly different):
<ShippingDetails>
<ShippingServiceOptions>
<!--Send in the complete information for the ShippingServiceOptions container -->
<ShippingServicePriority>1</ShippingServicePriority>
<ShippingService>USPSFirstClass</ShippingService>
<ShippingServiceCost>9.9</ShippingServiceCost>
<ShippingServiceAdditionalCost>6.95</ShippingServiceAdditionalCost>
</ShippingServiceOptions>
<!-- If you have multiple ShippingServiceOptions, specify all of them. -->
</ShippingDetails>
These are eBay's help page and PDF that explain using the Seller Hub Reports version of retired FileExchange:
https://pages.ebay.com/sh/reports/help/create-listings-bulk/
https://ir.ebaystatic.com/cr/v/c1/rsc/feeds/v1/guide-inventory-onboarding.pdf
ShippingService-1:Priority and ShippingService-2:Priority are missing from your spreadsheet. They are required when more than one shipping service is offered, and indicate the order the services will appear in the listing. Give them values of 1 and 2 in your preferred order.
The two shipping services chosen in your spreadsheet are Other and US_StandardDelivery. The Other designation means economy service. The US_StandardDelivery value is not on the service chart, although it may have meaning that is not documented.
The developer page should have current values, but it looks like it is missing US_eBayStandardEnvelope, so it is not entirely updated.
https://developer.ebay.com/devzone/xml/docs/reference/ebay/types/ShippingServiceCodeType.html
Below is an older (2015) chart of shipping fields available to File Exchange (now Seller Hub Uploads), and this one is better organized by country. Missing from the chart was US_eBayStandardEnvelope, for trading cards and coins, which I manually added to the bottom.
thelpandtoys
OP3 years agoThank you! That worked and I was able to upload an item!