Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

invalid column when importing csv

‎12-02-2015 02:45 AM
‎12-02-2015 02:45 AM

invalid column when importing csv

Trying to import and I keep getting an error about invalid "" columns I looked through the entire sheet to see maybe if there's a character somewhere..

 

No idea..

 

Help please

Labels:
0 Kudos
1 REPLY 1
‎12-03-2015 02:24 AM
‎12-03-2015 02:24 AM

Re: invalid column when importing csv

Hello.

 

Open the file in a text editor and save it as UTF-8 encoding.

 

Also if you are using Import/Export > Import, make sure that you have all the required by Magento fields and column names should be identical as database names (otherwise that might be simply not recognized).

 

Use export to have example of column names or check this tutorial on required columns and header names for CSV import -
https://www.mag-manager.com/useful-articles/tipstricks/required-csv-file-values-for-error-free-magen...

 

Hope this helps.

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.
0 Kudos