Keep getting product code error???

I just got my website up and running and now im trying to get some products uploaded. I keep getting:



“Your import file must included the following fields : Product Code”



I have product code as one of the cells in quotations. Its a csv file. Why isnt it working? The part numbers include both letters and numbers. That shouldn’t matter right? Im stumped…:cry:

I don’t know how you have it, but the right capitalization seems to make a difference whether or not the csv is allowed. For me, the product code field needs to be:



Product code



If I have it any other way it won’t work.



Also it seems I have had the best luck with a comma separated csv.



One thing you could do to make sure you have it right is to add one product manually and then export your product as a csv. Then you’ll now the exact layout and you can even copy/paste the layout if you need to.



Brandon

I am stuck on this same issue. After dozens of attempts to import data I am failing with this same error each time. I have created an Excel file with a few products in it. I have the first field listed as Product code. I have no idea what to try to make this work. I do not have a lot of experience using Excel, so I am probably missing something obvious, but I have no hope of finding at this point. Please help!

Need more info such as description of error and/or a sample of your csv file.

Here is the error message text…







I have attached the .csv file to this message. Thank you!



[ATTACH]1617[/ATTACH]

chrisgreen_csv.zip

your csv file doesn’t enclose each field value in quotation marks - adding them will help.



your url’s for images have spaces in them, might choke things (i say might, cuz it often does but i haven’t tested CS-Cart on this issue).



your first field value, the product code, looks to be “182 Cardinal” - i wonder if that space is knocking it’s lights out.

I got it! The last post got me thinking about viewing the CSV file in a plain text editor, and that provided the answer. Here is what apparently was going on…



I created an Excel doc initially, and I first entered the title of the Product Code field with both words capitalized. Early on I cottoned to the notice that the field should be entered as with only the first word capitalized. I changed the field name in Excel, but for some reason Excel was still saving the CSV file with the field name as the original . I edited the filed name in my text editor to be , and it imported just fine.



All set. Thank you!

Hey guys,

Ive to update this topice, because i cant find any solution to solve this Error: "Your imported file MUST contain the following fields: Product code, Vendor".

I have created a product manually and use the csv file as a template.

But If I try to import the csv with new products, I always get this error.

Any ideas?

Greets.

Hey guys,

Ive to update this topice, because i cant find any solution to solve this Error: "Your imported file MUST contain the following fields: Product code, Vendor".

I have created a product manually and use the csv file as a template.

But If I try to import the csv with new products, I always get this error.

Any ideas?

Greets.

Please provide us with the .csv file with several new products.

Sure you don't have any typos in the header row. I.e. "Vender" instead of "Vendor"? Just stating the obvious. Also note that you must be able to lookup the vendor by that exact name (spaces and puncuation included) for it to correctly associate a product/vendor in the system. If 'vendor' can't be found then my guess is the entry is skipped. Cs-cart provides very little diagnostic or error output on import/export. Usually it's pretty silent on things like not being able to find a Vendor or Store by the name in the column.

I got the same error "ErrorYour import file MUST have the following fields: Product code", I downloaded the trial version of cs-cart, created the product. I then exported the product data, I opened the .csv file and edited the product name, and finally I imported the data again, the same error. Can anyone explain to me the reason for measurement?

is the csv file formatted correctly in the header for product code

"Product code"

I got the same error "ErrorYour import file MUST have the following fields: Product code", I downloaded the trial version of cs-cart, created the product. I then exported the product data, I opened the .csv file and edited the product name, and finally I imported the data again, the same error. Can anyone explain to me the reason for measurement?

Try to import file without editing. Possibly your editor adds some invisible symbols to the file

Also be sure the delimiter used in the file matches what's expected on the import

This might sound silly, but it worked for me:
- Export one new created product from your new store that you want to import to.

- Open the csv from the old site and make sure that all the column names are in the same order like in the new one.
- Copy the data from your old csv to your new one and import it back.
this worked for me. Good luck

Try to import file without editing. Possibly your editor adds some invisible symbols to the file

I Try to import file without editing, but did not work.

I tried exporting the file on the new site and re-importing the file, but it displayed the same error.

If you have 'Product code' (case sensitive) in the header line (first line) of your file and the column separator matches what you've specified (personally recommend 'comma') then you have something greatly amiss.

Suggest you post the first couple of lines of your file so we can take a look.

Also, are you using the new product import or the older (deprecated) one. If using the new one, you might try using the old one to see if it works there.

I had that to. Make sure that the order of the columns match exactly between the exported file and the new cs-cart that you importing into.

For me it was easiest to export the csv from the new shop, check the columns against the old one, and then paste all the columns from the old one into new one, and import it back...
Good Luck

Order of columns should not matter. However, case-sensitivity is important. I.e. first word capitalized and following words all lower case.

We get this all the time now. Import/export process for CS-Cart is pretty flawed. Fields will match character for character and format for format and still produce this error. We're getting tired of having to manually do these imports in the database as a workaround.