When importing Magento product via csv file, you may see this error: Magento Skipping import row, required field “sku” is not defined, sometimes fields can be also be store, type, attribute set or something else…
In this Magento tutorial for beginner, we will learn how to fix this error.
Cause of the error
CSV file not in UTF8 format
Most common cause, check this first: CSV File is not in UTF8 formatted. To solve this do as below:
Open your csv file in file editor program like Microsoft excel, click on save as. In Save As Type, select CSV for your file. In tool dropdown, choose Web options
In web option window, select Unicode UTF8 in Encoding > Save this document as:
Now, go to your Magento backend and try to import again.
Only 1 product in 1 Line
Check if your each product is put in 1 line of csv file, if there are more than 1 product the import will be failed.
Headers Identical to Database Names
Header names must match field name in database. For example, you have “product title” column instead of “product name”, which is required by Magento, you will have to rename it or the import process will be failed
Missing required fields
There is a list of required fields by Magento, if your csv file misses these fields the import will not succeed.
- type_id or _type –
- _attribute_set
- tax_class_id
- weight
- sku
- name
- price
- description
- short_description
Still see the error after trying all the solutions above? drop me a line here and I will try to figure it out for you.
Good luck!
4 Comments
Hi, thanks for your detailed information above. I have tried all of above and I am still getting below error Skipping import row, required field “website” is not defined. I have the website column name as _website and the description as base. Can you please advise how to fix this?
Hii daniel Still it is showing the error.can u please help me to solve this.
Did you try to format your CSV file as UTF8?
Same here man…. tried the UTF8 followed your rules exactly.
In my case Im importing new products… everything is has said here and still same isseu