loading my CSV catalog does not work
loading my CSV catalog does not work
hello I downloaded a template to add products from CSV file,
so I filled this CSV file with the same information from the tutorials I watch on YouTube
then I saved it as CSV
then I loaded it into My eBay but at this point I get an error message from eBay:
“Not all data could be loaded.
We created a report showing what succeeded and what failed. Check the results.â€
in the error report there is:
Status
ErrorCode
ErrorMessage
Failure
BAF.Error.5
Unable to find Task Action Id for task add
Could you explain to me the different reasons why there could be an error message at this stage?
THANKS
25 comments
zirko1
OP2 years agohello on this file there are two products
https://docs.google.com/spreadsheets/d/1lQ56pAuKj8N_wP-PLX_2BijdBi3j6YPpjWrZhDaURZY/edit?usp=drivesdk
each of my products imports correctly when I load it into the reports
But when there is only one product on the CSV
but when both products are present on the CSV then nothing matters
and there is an error message
2,Add,Failure,21916664|21916638,"Error - The characteristics of the version entered do not correspond to the characteristics of the versions of the object.||Error - The name of the characteristic of the version """"Model"" "" used for photos does not exist in the version specification set.|""""Model""""|",21919456|21917236,"Warning - The seller has activated the Terms of Sale Manager. Use term numbers rather than old fields for shipping, payments or returns to avoid having new terms automatically created on the seller's account.||Warning - Funds from your sales are not available and they appear to be blocked for a certain period of time Find out more:https://www.ebay.fr/help/selling/getting-paid/getting-paid-items-youve-sold/. pending-payments?id=4816|Funds from your sales may not be available and may appear to be blocked for a period of time.|Funds from your sales may not be available and they appear to be stuck for a while. Learn more: https://www.ebay.fr/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=4816|PayPalHold|https://www.ebay. fr/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=4816||",,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,
Thanks
shipscript
·2 years ago@zirko1
BAF.Error.5 > Unable to find Task Action Id for task add
This is a fatal error that usually indicates the file format is corrupt. The "Action" heading is the first one in the file and it could not be found.
It was frequently a problem using an older version of Excel with UTF-8 that would add hidden characters to the front of the file. The file format had to be changed to ISO-8859-1 to eliminate the hidden characters.
This error could also appear if you have a linebreak in the middle of one of your cells, like the description. Check all of your data to make sure there are no linebreaks in any of the cells.
Are you selling on the FR site? If so, did you download the FR version of the CSV template? It is actually more convenient to download the XSLX version of the spreadsheet for the category you wish to list. That version has prefillable data in droplists. The droplists are within each cell, and you must fill the data left to right, since some requirements may change after certain selections are made.
zirko1
OP2 years agomy messages are erazed
shipscript
·2 years ago@zirko1
I looked at your CSV file posted on Google sheets. There are stray DOM characters in front of the first info row. What tool did you use to generate the code? It would appear that an older version of Excel was used and it added the DOM code as part of UTF-8. eBay can not read that code. The invisible code is actually displayed in Google sheets as 
You can delete that top line and then save the file from Google as a CSV. Without editing, upload that CSV to eBay. It should get past the file error and return smaller data errors due to the missing columns.
Can you point to a listing that is similar to what you want? Then I can find the correct category template.
zirko1
OP2 years agoI just added the file with an image as ebay asked me
except there are still three error messages
Failure,71|21919303|21919303 https://developer.ebay.com/devzone/xml/docs/reference/ebay/errors/errormessages.htm
71 Serious Error Short error: Location missing. Long error: Your item's location was not filled in. The location field helps buyers determine the shipping cost(s) for the item, and should always be included.
Yes but there is no indication
21919303 and 21919303 Serious Error Short error: replaceable_value Long error: replaceable_value
There is also no indication
zirko1
OP2 years agoI don't know what to say to myself, I can't post my answer to this subject (my answer is automatically deleted)
so I wrote you in PM
zirko1
OP2 years agoeBay tells me different things every time but doesn't explain how to make the changes
hello I download templates from eBay to make catalogs of my products on CSV files
when I'm finished I look for these files in eBay and each time eBay gives me error messages which are different each time, different error report numbers each time
but the problem is that eBay doesn't give me any instructions on how to make the change correctly
THANKS
shipscript
·2 years ago@zirko1
When there are a lot of errors, they will not all be found. Each time you fix one error and resubmit your file, the next error will be found.
The error regarding item "Location" is because the field may be expecting a city and postal code. I have changed that column to "PostalCode" and only your postal code will be required.
I don't know any French, so it took some time for Google to translate ( https://translate.google.fr/ ) the things I needed in order to download a template from the ebay.fr site.
It seems you are selling earrings, so I discovered by using a "sell similar" what the path and category number would be for earrings, within costume jewelry.
> Bijoux, montres > Bijoux fantaisie > Boucles d'oreilles
With that information, I downloaded both the CSV template and the XLSX template from the french seller hub to see what might need to be entered for earrings.
https://www.ebay.fr/sh/reports/uploads
The CSV file used semicolon delimeters, while the XLSX uses comma-delimeters.
I used the XLSX file because it has helpers to populate cells. I then exported the CSV file, which ended up with an extra thousand empty rows (we occasionally see this complaint). I had to manually remove those rows. I don't know how to advise what spreadsheet setting would prevent that, but I believe there is one.
The exported file is UTF-8, but it is the newer version and should not have any hidden characters at the beginning.
I also added all of the extra package columns that are required for calculated shipping. If you use flat rate shipping, you won't need those columns until you print a shipping label on eBay.
Here is the file:
https://shipscript.com/test/zirco1/FR_earring-category-utf8.csv
zirko1
OP2 years agocould we talk on Facebook for example,
could you correct my file for the video game, it's a test, however eBay has generated error reports for me and I don't yet know how to correct the shipping, could you do it
zirko1
OP2 years agoThe error regarding item "Location" is because the field may be expecting a city and postal code. I have changed that column to "PostalCode" and only your postal code will be required.
me, have you changed? do you mean that you made a correction on the CSV that I gave you?
The CSV file used semicolon delimeters, while the XLSX uses comma-delimeters.
I don't understand, in the tutorials I watched I understood that the CSV format must be saved separated by commas and not by ;
I used the XLSX file because it has helpers to populate cells. I then exported the CSV file, which ended up with an extra thousand empty rows (we occasionally see this complaint). I had to manually remove those rows. I don't know how to advise what spreadsheet setting would prevent that, but I believe there is one.
me, I don't really understand what you mean, have you looked and corrected and tried to load my catalog with my test product, I mean the first video game test product I'm trying to create, I'm trying to load it into ebay myself but every time but gives me an error report which is all the time different that's why I wrote to you because you are probably more used to it than me and it will be resolved quickly, the problem is that eBay support tells me things all the time different ones which don't work, this is also the reason why I asked you if it doesn't seem possible to chat on Facebook
The exported file is UTF-8, but it is the newer version and should not have any hidden characters at the beginning.
I don't understand what you mean, what are hidden characters?could you make me an example file with a test product for a video game for example and could you make me a second test product for an earring
I also added all of the extra package columns that are required for calculated shipping. If you use flat rate shipping, you won't need those columns until you print a shipping label on eBay.
me, I have difficulty understanding, do you know if I could find documentation to understand, I did not find the solution on the PDFs on ebay but available
shipscript
·2 years ago@zirko1
Ship: The error regarding item "Location" is because the field may be expecting a city and postal code. I have changed that column to "PostalCode" and only your postal code will be required.
Zirko1: have you changed? do you mean that you made a correction on the CSV that I gave you?
Ship: I did not use your spreadsheet. I downloaded a template from eBay and created a new spreadsheet for earrings and added new columns to the spreadsheet. That new spreadsheet is here:
https://shipscript.com/test/zirco1/FR_earring-category-utf8.csv
Ship: The CSV file used semicolon delimiters, while the XLSX uses comma-delimiters.
Zirko1: don't understand, in the tutorials I watched I understood that the CSV format must be saved separated by commas and not by ;
Ship: eBay will accept three different delimiters (semicolon, comma, tab). You can use whichever one works for you.
Ship: I used the XLSX file because it has helpers to populate cells. I then exported the CSV file, which ended up with an extra thousand empty rows (we occasionally see this complaint). I had to manually remove those rows. I don't know how to advise what spreadsheet setting would prevent that, but I believe there is one.
Zirko1: I don't really understand what you mean, have you looked and corrected and tried to load my catalog with my test product, I mean the first video game test product I'm trying to create,
Ship: I did not use your video game test because there was not enough information to make a listing. I used your earrings because you had more information in that inventory list. Once you get one spreadsheet working, it will be easy to fix the other spreadsheet. Much of the data is the same.
I uploaded the earrings spreadsheet to ebay.fr here:
https://www.ebay.fr/sh/reports/uploads
It had no errors, but did have warnings. Warnings usually still allow the item to post as a listing. The warnings were:
Warning - La valeur du code produit eBay Ne s'applique pas n'est pas valide. Il a été supprimé de l'annonce.|Ne s'applique pas||Warning - Le champ relatif aux Conditions de retour Refund a été ignoré.|Refund|
Since I don't know the eBay rules and customs in France, I probably added data that was not needed.
I also changed the Action from "Add" to "VerifyAdd". This means the spreadsheet will be tested, but a listing won't be created. When you are happy with your spreadsheet performance, you can change that back to "Add" to actually post real listings.
Zirko1: I'm trying to load it into ebay myself but every time but gives me an error report which is all the time different
Ship: eBay will test the spreadsheet from left-to-right. Each time it finds an error, it stops and reports. When you fix that error and upload again, it finds the next error. It is tedious when first learning. One by one you will fix all the errors and will then understand what is expected for future uploads.
Zirko1: ...that's why I wrote to you because you are probably more used to it than me and it will be resolved quickly, the problem is that eBay support tells me things all the time different ones which don't work, this is also the reason why I asked you if it doesn't seem possible to chat on Facebook
Ship: Sorry, I don't do Facebook or private tutoring. I help as I can here on the forums where others can also learn. I hope this is helping.
Ship: The exported file is UTF-8, but it is the newer version and should not have any hidden characters at the beginning.
Zirko1: I don't understand what you mean, what are hidden characters?could you make me an example file with a test product for a video game for example and could you make me a second test product for an earring
Ship: I gave an example in an earlier post. The 3 hidden characters that denote an older UTF-8 file are  and they were actually displayed in the top left cell of your Google sheets. It would appear as if a template was created elsewhere (using older UTF8) and was pasted into Google where the hidden characters were exposed.
Ship: I also added all of the extra package columns that are required for calculated shipping. If you use flat rate shipping, you won't need those columns until you print a shipping label on eBay.
Zirko1: I have difficulty understanding, do you know if I could find documentation to understand, I did not find the solution on the PDFs on ebay but available
Ship: The package columns state the weight and dimensions of your package. If you charge a single shipping rate for your item, that is called flat rate shipping. FlatRate shipping is the default. Otherwise, you must have a "Shipping Type" column when using "calculated" shipping.
When you print your shipping label, if you don't have package specs in your listing, you may need to add the weight and dimensions of the package for the label cost.
With calculated shipping, carrier cost is based on distance. The cost to ship nearby is less than the cost of shipping farther away. In the US, our distances are quite vast, so the near and far rates different quite a bit. By adding the package weight and dimensions to the listing, eBay is able to quote actual shipping to the customer based on the customer's location.
International shipping is also an option. But if you have "eBay International Shipping" or "eBay Global Shipping", you would ship only to the local eBay export hub and would not need to list any international shipping options.