I was getting this error message when doing an import of simple products in to a Magento store. I already had some products in the store so I had run the “export all products” profile to get a starting spreadsheet to add to.
Unfortunately, when I came to reimport the spreadsheet, it did the first few lines successfully and then failed. It failed on the first line of my newly added products complaining about undefined SKU. After double checking that column did in fact have content in it, I realised my error.
Save as UTF-8
I had been editing the spreadsheet in Neo/Open Office and when I had saved as a Text csv file, it had not saved in UTF-8 format. This was breaking the import process.
So make sure when bulk importing Magento products that you’re saving in the right format. To change this in Open Office:
When you are on the save screen, tick the “Edit filter settings” box and then once you click save you will be given the option of choosing the encoding format.
Best of luck with the rest of the product import!
Related posts:
You rock !!!
Thanks a lot.. you solved my problem.. thanks again!
You are a life saver.
Thanks Tom, this solved my problem,
You saved me a whole lot of time. thanks
Thanks so much… your awesome.
Was getting this weird error after a save. Seems to have worked.
pouvez-vous m’aider sur cette erreur quand j’importe de liste de produit en majento
“Can not find required columns: sku”
S’il vous plaît aidez-moi!!!!!!!!
You rocks dear…..
You are my hero!
You are saving me for going mad!
Soo simple – but you have to know it!!
thank you
Didnt work for me so far, still getting the “Skipping import row, required field “sku” is not defined.” error…
Você é o melhor, obrigado!
You is the best! tanks!
After much trial and error and then having the feeling I’d never work it out, I stumbled across this page. You saved the day – and I thank you for that!
you saved me from going mad.
Thank you for sharing your learning.
Thx man, was looking for a solution for about an hour before I came across this post.