We had the same problem - some products were importing, others didn\’t (all on the same spreadsheet). I tried editing in notepad, checking columns, everything and still had the same issue.
Eventually we realised that the products that weren\’t importing contained fractions (like ¼) so I replaced these with .25, .5, or .75. Uploaded the csv and it worked!
I have also the \"Skipping import row, required field \"sku\" is not defined.\” problem.
I solved the problem by entering a unique SKU value in the SKU column (XML/CSV). The funny part is that I set the attribute \"SKU\" to \"not required\”, but needs it anyway while importing the products. Hope it helped you.
I found how to use Excel to export CSV in UTF-8… Thanks google
In the screenshots attached you’ll see that at Save us… box, there is a “Tools” button that will drive you to setting up the UTF-8 encoding format (for me it’s so important as in Spanish we have characters like á é ó ú...)
I also encountered the same problem. What i did was opened the CSV file in notepad++ ,and in notepad++ we have an option for converting the file to utf-8 without bom .Do it and then save (format>>convert to utf-8 without bom). After that there was no such messages as skipping import row.
I did have the same problem, gave me serious headache but i found a solution that works for me, the only way i can get it to work is to use open office instead of MS excell for it, no matter what i try with excell, i cannot get it to work.
Open it in open office, then save it as a text .csv and it worked for me surprisingly, i do not know why but excell does something with it that it is unreadable.
I use excell 2007 version and magento 22.214.171.124 , so that does not work.
Download open office and try it out.
I also use dutch translation, I hope this works for you !!!! Because it is hell if you break your head over it for a week and can’t upload a thing.
Doe anybody knows How I can upload new products, as this still gives me problems.
If it does not have an excisting SKU, i cant upload new products from a csv???
Worked for me!!! Did not realize how useful Open Office was. I will use office 2007, but copy it over to open office before submitting to correct the Character set (should be Unicode UTF-8 or ASCII). Thanks so much!
This worked for me. Sorry to say I had to read most of the postings about this issue before I came across your answer. I wish the Magento team would allow forum visitors to rank answers based on how helpful they are so people can tell right away when something is the right solution (or at least the most likely to work) based on user comments.
I’d looked for the UTF-8 encoding, but actually use Access 2003 because Excel is kind of a poor database tool, but an excellent spreadsheet and exporting UTF-8 is one of Access’s normal options during CSV export (Click Advanced… button on export dialog box.)
Since a lot of my work is comparing data exported from various programs, having it in databases is a natural. But most people aren’t going to go buy Access when they have Excel just sitting there begging to be used. Excel 2003 is slightly different, on the Save As… dialog box, the Tools button is at the top. Select Web Options, and then the Encoding Tab on the secondary dialog box. Change to UTF-8.
Saves you having yet another office productivity suite (loading Open Office) just to save files with UTF-8 encoding
What you’re showing is an ever expanding list of uploaded import files that grows with each import, unless you go to /var/import and delete the import files. I put in a cron job that deletes files in /var/import to eliminate anything older than a day, you can just navigate to /var/import after doing an import and simply empty the folder.