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
  • 2632 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
  • 3801 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
  • 32 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
  • 19388 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    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11308 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.