Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Keep getting product code error??? Rate Topic   - - - - -

 

Posted 23 December 2009 - 01:44 AM #1

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:

 
  • brandonvd
  • is Super Awesome
  • Members
  • Join Date: 19-Dec 06
  • 2633 posts

Posted 23 December 2009 - 01:53 AM #2

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

 
  • chrisgreen
  • Junior Member
  • Members
  • Join Date: 26-Jan 10
  • 4 posts

Posted 26 January 2010 - 02:07 PM #3

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!

 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3967 posts

Posted 26 January 2010 - 02:59 PM #4

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

 
  • chrisgreen
  • Junior Member
  • Members
  • Join Date: 26-Jan 10
  • 4 posts

Posted 26 January 2010 - 03:13 PM #5

Here is the error message text...

<Your import file MUST have the following fields: Product code>

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

[ATTACH]1617[/ATTACH]

Attached Files



 
  • Pat Grady
  • Junior Member
  • Members
  • Join Date: 14-Jan 10
  • 5 posts

Posted 26 January 2010 - 04:17 PM #6

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.

 
  • chrisgreen
  • Junior Member
  • Members
  • Join Date: 26-Jan 10
  • 4 posts

Posted 26 January 2010 - 04:29 PM #7

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 <Product code> 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 <Product Code>. I edited the filed name in my text editor to be <Product code>, and it imported just fine.

All set. Thank you!

 
  • MarkusBudz
  • Member
  • Trial users
  • Join Date: 08-Aug 18
  • 36 posts

Posted 28 March 2019 - 12:11 PM #8

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.

 

 



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21804 posts

Posted 28 March 2019 - 01:14 PM #9

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.


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12051 posts

Posted 28 March 2019 - 07:52 PM #10

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.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • Thuong Ho
  • Newbie
  • Trial users
  • Join Date: 10-Jan 20
  • 2 posts

Posted 10 January 2020 - 03:32 AM #11

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?



 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4917 posts

Posted 10 January 2020 - 12:36 PM #12

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

 

"Product code"


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21804 posts

Posted 10 January 2020 - 01:43 PM #13

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12051 posts

Posted 13 January 2020 - 07:15 PM #14

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


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • allgaguzzi
  • Member
  • Trial users
  • Join Date: 31-Aug 11
  • 46 posts

Posted 15 January 2020 - 04:01 PM #15

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



 
  • Thuong Ho
  • Newbie
  • Trial users
  • Join Date: 10-Jan 20
  • 2 posts

Posted 17 January 2020 - 04:21 AM #16

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.



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12051 posts

Posted 30 January 2020 - 10:18 PM #17

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.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • allgaguzzi
  • Member
  • Trial users
  • Join Date: 31-Aug 11
  • 46 posts

Posted 03 February 2020 - 02:33 PM #18

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



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12051 posts

Posted 03 February 2020 - 07:53 PM #19

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


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • FDGWEB
  • Junior Member
  • Authorized Reseller
  • Join Date: 20-Aug 10
  • 155 posts

Posted 14 April 2021 - 12:02 AM #20

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.


FDG Web, Inc - Seattle Web Design : Custom CS-Cart Programming & Design | Toll-Free: 877.239.3083

Download Proposal Templates & Web Design Contract Samples