Error entering StoreCategory value in Seller Hub Reports New Listing Template. My formula fails.
I'm using the header, StoreCategory
When typing the value manually, or copy and paste it from eBay seller hub>store>store categories>category number, it works.
But when I use the formula,
=IF(E5="", "", XLOOKUP(E5,DataValidationLists!$A$2,DataValidationLists!$B$2, "", FALSE))
Which returns the same number I manually entered. It fails.
My data validation list looks something like:
A1: Store Category Name, B1: Store Category ID
A2: 2025 Q3, B2: 41898594010
To sum it up, when I enter 41898594010 manually, it works. But when I enter the formula to retrieve that number it fails (even though the formula gives the correct number).
Other info: The template used is the .xlsx version of the 10 category new listing template. Using Excel 365. The specific error is: Error - Input data for tag <Item.Storefront.StoreCategoryID> is invalid or missing. Please check API documentation.|Item.Storefront.StoreCategoryID| Code 37
fredspremiumcloset
OP1 year agoSolved.
I needed to add,
to the end of my XLOOKUP formula.
It forces Excel to convert the numeric result of the lookup into a text string. This is the most common solution for this type of API error when Excel formulas are involved (source: Gemini).