In this post we are discussing product/customer import in magento. After log research and use I am sharing my experience with you. Many of time we are import a large number of customers and products into magento and getting notice and/or error. Mostly you face these issue when CSV containing special characters .
Most of time we are faced character encoding issue in csv. Because Csv product information contains special characters and/or Multibyte .The CSV files were generated on the same machine in the same manner, I then opened the files in Notepad++ to make the encoding conversion before uploading to Magento.
For my particular scenario, my data was stored in a MySQL database that I was accessing using Microsoft Access. I created a couple of queries to generate my data sets which I then exported to Excel (.xlsx) via the ‘External Data’ tab.
Now Excel has a nasty habit of only using double quotes to surround CSV field names and values when it sees fit which can cause problems when importing into Magento but this is where OpenOffice Calc comes to the rescue.
So I open the .xlsx files in OO-Calc and then save back a CSV version of my files.
Now I have my plain text versions of the data, I open them in Notepad++, convert the character encoding by using the menus ‘Encoding / Convert to UTF8′ or ‘Encoding / Convert to ANSI’ and save the files.
Now as I explained earlier, when I tried to import my product CSV into Magento, I had to use UTF8 and for customers I had to use ANSI character encoding.
The error message that gets thrown by Magento isn’t very helpful. For the product import the error message was “Missing field: SKU’ and for the customer import it was “Missing field: Website”.
If you got error again then you can change the import patterns from CSV to XML. Check the below image of data flow profile :