Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

My CSV file is not valid, but did all necessary steps, what is wrong? 
 
desiree_s
Jr. Member
 
Total Posts:  5
Joined:  2010-11-16
 

I am trying to upload data. I have checked all threads and tried many tips but no success yet.

I exported data first (used import/export but also tried profiles). Opened data in Excel (by importing data as XML and check comma separated, otherwise it will not read well).

Edited data, deleted empty rows etc.
Saved file as CSV (all available options; as MS-Dos and with columnseparation) and checked in extra options that it’s saved as Unicode UTF8.

When importing data again, the system says it cannot find sku column, but it is there!

I have tried to run the import / edit data / export steps many and many times, but I cannot manage!

I cannot attach my latest CSV file (magento will not add CSV-files to topic). But still, maybe someone can help me out.

And I’ll try again tomorrow....

Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
San_Pablo_Juan
Jr. Member
 
Total Posts:  10
Joined:  2011-01-11
 

A few things to check:

Look for spaces in the column headings.  Remove them.

Also, case matters.  SKU is not the same as sku.  (Occasionally, Magento will forgive case errors—but uploads just run more quickly if the data is clean.)

I have better luck with CSV than I do XML.  Excel is simply horrible at UTF 8.  I assume that it is not UTF-8, even if it says it is. 

The trick I use is opening the file in the Open Office spreadsheet program, which saves nicely in UTF-8.  If you have columns of numbers, format them as text.  I still edit in Excel because I know it better, but a final clean up with Open Office has reduced errors a lot. 

Other folks use Notepad to open their CSV file and re-save it as UTF-8.  This also works.

If you are creating new products, include every column from your original download sheet.  Not all the columns are mandatory, but if a required field is missing the sheet will not upload correctly.  They do not have to be populated, but the headings must be there.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top