Morning all,
Over the past couple of weeks I have been developing and Excel interface to make using this method of listing easier.
I'm a bit of an Excel guru and also VBA coding so I've made extensive use of formulas and VBA code to collate the data and save into CSV format ready for the upload.
I've done lots of reading of the ebay File Exchange Advanced Instructions in an effort to understand all the rules as they relate to what I'm try to do. And built up a template for what we need.
I've been using the VerifyAdd function to check that the files are working then making corrections as needed. Got a normal single product to work nicely.
Took a bit longer to get a product with variations working as this one is. Yesterday I got the message SUCCESS!. woohoo looked like I had it working. Then this morning I thought I would do a live listing upload using the ADD function. But first just did one more VerifyADD.
Guess what it failed! Grrr! Nothing had changed since yesterday.
The warning message is:
"21919403|21919401"
"Warning - The item specific Brand is missing. Add Brand to this listing, enter a valid value, and then try again.|The item specific Brand is missing.|The item specific Brand is missing. Add Brand to this listing, enter a valid value, and then try again.|Brand||Warning - UPC is missing a value. Enter a value and try again.|Enter a value in UPC and try again.|UPC is missing a value. Enter a value and try again.|UPC|"
Now its only a warning, not a full blown error so I suspect if I try to do the live upload it will work.
But yesterday I had no errors or warnings at all.
I've attached a screenshot (below) of a section of my CSV file that I believe it is complaining about and looks like it complies with the ebay guide to me. Basically, if you have variations then all the item specifics are detailed on the variation records and not on the product level so the product level fileds should be empty as they are. All my custom fields (C:<FieldName>) for the required Item Specifics have unique records for each variation. Some are BLANK as they do not apply to this particular item, but that should be OK. Although the MPN and UPC codes are always "Does not Apply" for our stuff.
I've been tearing my hair out trying to figure this one out, but don't have that much I can afford to lose. LOL!
I'm hoping we have a guru in here that might better understand what I'm doing wrong here. I assume it's me, but it did work cleanly yesterday tho. So I'm at a loss now to fix this up.
