04-27-2019 12:20 PM - edited 04-27-2019 12:22 PM
@dollybeauty and @shipscript Here's the file we're discussing.
http://s000.tinyupload.com/?file_id=00851142603746333946
Can I delete it from the server it was generated from?
Thank you!
Solved! Go to Best Answer
04-27-2019 01:30 PM
The compatible programs should be able to produce the appropriate files. Does LibreOffice have the option to "Save As" in Windows CSV format? I would think so, since the Mac CSV format uses a different file terminator.
Based on the sample uploaded file you provided us (which also had the wrong file terminator), there was not enough detail in the variation for a submission and the PicURL field was empty on the first line, so would expect a failure. Let's look at your single product upload file. Can you share that file with us?
It seems we are looking for basic file format failures, but there could still be a data error.
04-27-2019 01:44 PM - edited 04-27-2019 01:47 PM
Sorry for the delay. Someone stopped by. Anyway, here are screenshots that show the choices I have for saving. Which one should I use, please?
Also page 31 shows you have to leave the PicURL field empty on the first line.
I have to create a single item csv again.
Crazy question but is western ISO-8859-1 for US English?
04-27-2019 01:54 PM
@shipscript My single item file failed so I'm going to do what you said in the other post: "Can you save the spreadsheet to CSV, change the suffix to TXT, open in a text editor, and then copy/paste the text into the </> code box here? Although harder to read, that will actually give a clearer indication of spaces and formatting."
04-27-2019 02:00 PM
It looks like you have only one CSV save option, so that is the one to use. While you are preparing your file for display here, I'll go ahead and create a simple one line upload for File Exchange, test it on my own listing, and then give that file to you. That will probably take an hour, probably less, to get it end-to-end tested so you can use the same file. At least that way, we can start with known working data and try to track down the system incompatibilities if those are the real issues.
04-27-2019 02:02 PM
OK. Thank you.
Here is the text version of the single item upload:
"*Action","CustomLabel","*Category","StoreCategory","*Title","Subtitle","Relationship","RelationshipDetails","*ConditionID","*C:Brand","C:Type","C:Dog Size","C:Material","C:Features","C:Color","C:Custom Bundle","C:Model","C:Bundle Description","C:MPN","C:Dog Breed","C:Modified Item","C:Modification Description","C:Theme","C:Country/Region of Manufacture","C:California Prop 65 Warning",,"PicURL","GalleryType","*Description","*Format","*Duration","*StartPrice","BuyItNowPrice","*Quantity","PayPalAccepted","PayPalEmailAddress","ImmediatePayRequired","PaymentInstructions","*Location","ShippingType","ShippingService-1:Option","ShippingService-1:Cost","ShippingService-2:Option","ShippingService-2:Cost","*DispatchTimeMax","PromotionalShippingDiscount","ShippingDiscountProfileID","DomesticRateTable","*ReturnsAcceptedOption","ReturnsWithinOption","RefundOption","ShippingCostPaidByOption","AdditionalDetails","UseTaxTable"
"Add",,177796,,"Boy Puppy Dog Pet Cat Happy Birthday Shirt Printed w/ Balloons & Birthday Boy",,,,"New with tags","Many","Shirt","XS","Polycotton",,"Red","No",,,,"All Breeds","No",,,"United States",,,"https://www.alwayspaws.com/images/dog_clothes/dog_tee_shirts/birthday-boy-shirts/Morris-birthday-boy... Birthday to YOUR Beloved Pet! Celebrate YOUR Puppy Dog's Birthday with these Sleeveless Dogs and Cats Birthday Tee Shirts with Festive Balloons.","Fixed price","GTC",11.98,11.98,1,1,,1,,65605,"Flat",,,,,4,,,,"ReturnsAccepted","Days_14","MoneyBackOrReplacement","Buyer pays to return the item",,0
04-27-2019 02:04 PM
04-27-2019 02:07 PM
04-27-2019 02:12 PM
"*Action","CustomLabel","*Category","StoreCategory","*Title","Subtitle","Relationship","RelationshipDetails","*ConditionID","*C:Brand","C:Type","C:Dog Size","C:Material","C:Features","C:Color","C:Custom Bundle","C:Model","C:Bundle Description","C:MPN","C:Dog Breed","C:Modified Item","C:Modification Description","C:Theme","C:Country/Region of Manufacture","C:California Prop 65 Warning",,"PicURL","GalleryType","*Description","*Format","*Duration","*StartPrice","BuyItNowPrice","*Quantity","PayPalAccepted","PayPalEmailAddress","ImmediatePayRequired","PaymentInstructions","*Location","ShippingType","ShippingService-1:Option","ShippingService-1:Cost","ShippingService-2:Option","ShippingService-2:Cost","*DispatchTimeMax","PromotionalShippingDiscount","ShippingDiscountProfileID","DomesticRateTable","*ReturnsAcceptedOption","ReturnsWithinOption","RefundOption","ShippingCostPaidByOption","AdditionalDetails","UseTaxTable" "Add",,177796,,"Boy Puppy Dog Pet Cat Happy Birthday Shirt Printed w/ Balloons & Birthday Boy",,,,"New with tags","Many","Shirt","XS","Polycotton",,"Red","No",,,,"All Breeds","No",,,"United States",,,"https://www.alwayspaws.com/images/dog_clothes/dog_tee_shirts/birthday-boy-shirts/Morris-birthday-boy-tee-shirt.jpg|https://www.alwayspaws.com/images/dog_clothes/how-to-measure-pets-for-shirts-copyright.jpg|","Plus","Happy Birthday to YOUR Beloved Pet! Celebrate YOUR Puppy Dog's Birthday with these Sleeveless Dogs and Cats Birthday Tee Shirts with Festive Balloons.","Fixed price","GTC",11.98,11.98,1,1,,1,,65605,"Flat",,,,,4,,,,"ReturnsAccepted","Days_14","MoneyBackOrReplacement","Buyer pays to return the item",,0
I can't delete the incorrect posts. This is what I have for the single item csv. Thank you for your help. I'm grateful for it.
04-27-2019 02:12 PM - edited 04-27-2019 02:14 PM
You'll need to use the </> toolbar icon to open a code window. Otherwise the text will take on attributes of the forum. Can you try again?
We cross posted. Thanks, we can work with that file. I'll test the quoted header row to see if that is a failure.
04-27-2019 02:13 PM
Yes, I just did. thanks!
04-27-2019 02:16 PM - edited 04-27-2019 02:19 PM
My single item csv was completed and I received the below error. (yes we crossposted before)
2 Add Failure 37 "Error - Input data for tag Condition> is invalid or missing. Please check API documentation."
What is wrong with this?
*ConditionID New with tags
04-27-2019 02:23 PM
04-27-2019 02:26 PM
ConditionID is a number. Try 1000
04-27-2019 02:27 PM
Ok, thanks. Will do that now.
04-27-2019 02:36 PM
I just got:
"Error - Input data for tag Format> is invalid or missing. Please check API documentation."
Welcome to the Seller Tools board! You can chat with other members about seller tools and best practices in using them.
Tools related questions? Learn more about:
Videos: