I have a product sheet with some 200 odd products. When I am trying to import these product I get an error saying "Skipping import row, required field SKU not defined", even though all the SKUs are present. It happens with most of the products but some products do get imported. Don't understand the difference. My SKUs are four digit numbers only in general excel formate. can someone pls tell me what i am doing wrong?
This happened to me recently and I found that it was because the quote + comma requirement for the csv was incorrect. If you make sure that everything in the spreadsheet is properly quoted (blank fields don't matter i think) and double check that everything is comma seperated.
Tip: just take the first line and keep adding one line at a time until an import produces the error and you should see straight away which line causes the first error. 90% chance this line won't be quoted properly.
I'd recommend NEVER using Excel for Magento imports. Whenever you export an excel file to .CSV it always adds hidden characters and you'll always get import errors like "Duplicate Columns" and such. I always use Google Docs Spreadsheet. Just hit export>CSV and you'll see that you get a lot smoother and error-less imports!