Magento 1: Skip import row, required field sku not defined, Skip import row, required field store not defined

This knowledgebase explains how to solve the "Skip import row, required field "sku" not defined" or "Skip import row, required field "store" not defined"error when importing products via a .CSV file into Magento using Magento Import / Export Profiles.

In most cases your .CSV file needs to be saved in UTF-8 format:

1. First, ensure all your fields are properly filled in Excel or Open Office Calc.
2. Create and edit a copy of your original .CSV file (in case it goes pear shaped).
3. Save the file as Comma Separated Values (.CSV) if you haven't already done so.
4. Open the file with a text editor such as NOTEPAD or TEXTEDIT (if using a Mac).
5. Go to File > Save As Your filename should end with .csv. Example: import.csv
6. Under Save as type select All files (*.*)
7. Under Encoding (Plain Text Encoding in TEXTEDIT) select UTF-8
8. Save the file ready for reimporting into Magento

  • 68 Users Found This Useful
Was this answer helpful?

Related Articles

Magento User Guide (Official and Free)

Magento offer a paid ebook User Guide (which costs around USD$20). What a lot of people don't...

Magento 1: Importing customers to Magento using Import/Export Profiles (Magento 1.3*)

This knowledgebase explains how to setup a simple .csv file in order to import your existing...

Error - There was a problem with reindexing process (Catalog URL Rewrites)

Magento has a tendancy to append a number to URL's (such as -1) in order to keep them unique....

Magento 1: Add the Magento contact form to a CMS page as a static block

Magento has a built-in contact form that does the job, but isn't the easiest to edit. You may for...

Error - There was a problem with reindexing process (Product flat data) indexes

If re-indexing the Product flat data index gives an unknown re-indexing error or "Some problem...