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

[caferkara]

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

[Store_Manager]

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...

[caferkara]

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 :/

[Store_Manager]

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

[caferkara]

For import I use this page

http://prntscr.com/dfkocd

For export I use this page

http://prntscr.com/dfkozi

[Store_Manager]

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).

[caferkara]

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?

[Store_Manager]

Hello.

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

[caferkara]

Hi,

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

[Store_Manager]

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.