cancel
Showing results for 
Search instead for 
Did you mean: 

Skipping import row, required field "sku" is not defined Error

Skipping import row, required field "sku" is not defined Error

Hi,

 

I'm using Magento ver. 1.9.2.4.  I have this error when I import the products. I tried all the solution paths written to the site. What can I do? 

 

CSV Screen:
http://prntscr.com/ded9e5


Import Error Screen:
http://prntscr.com/dedbex

 

 

Thanks

9 REPLIES

Re: Skipping import row, required field "sku" is not defined Error

Hello.

 

Try re-saving your file with encoding UTF-8 without bom.

 

Also sometimes Magento might complain on one field and the problem might be with other required values, so make sure you have entered them. Use this article to check -

https://www.mag-manager.com/useful-articles/tipstricks/required-csv-file-values-for-error-free-magen...

 

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: Skipping import row, required field "sku" is not defined Error

Hi, I already tried encoding UTF-8 without bom. But not working. I checked that article but still not working. I tried all the solutions. How can I do I don't know :/

Re: Skipping import row, required field "sku" is not defined Error

Do you use Dataflow or Import/Export? and what method have you used to export file?

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: Skipping import row, required field "sku" is not defined Error

For import I use this page

http://prntscr.com/dfkocd


For export I use this page

http://prntscr.com/dfkozi

Re: Skipping import row, required field "sku" is not defined Error

Hmm, it is strange. The file structure looks like it was exported via DataFlow and you have attached screenshot for Export page.

 

You can try once again export file, do changes and then import it back, but this time try Import/Export  for upload (System -> Import/Export). If you still experience issues, you can attach sample of your import file (just a few lines here).

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: Skipping import row, required field "sku" is not defined Error

I fixed this csv problem. I'm using google sheets. I can import product now. But I have another problem. I can't see image when import csv.

 

Image 1:
http://prntscr.com/dh5xnb

Image 2:
http://prntscr.com/dh5xsf

 

 

How can I import images?

Re: Skipping import row, required field "sku" is not defined Error

Hello.

Can you please clarify if you are importing new images for products?

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: Skipping import row, required field "sku" is not defined Error

Hi,

 

I still can't import images for products. I tried almost all the solutions. Do you know plugin for import images?

Re: Skipping import row, required field "sku" is not defined Error

Hi again.

 

In your file I see you have image path like i/m/imagename.jpg, so that is why I was asking - do you import existing images for products?

 

Usually when we add new images, we add them to media/import folder via FTP client. After that in the file we put images names with leading slash, like /image.jpg

Like this - https://www.mag-manager.com/useful-articles/tipstricks/the-procedure-of-magento-images-import/

 

There are multiple plug-ins, but to recommend the one it would be better if you explain your requirements to images import.

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.