.Csv import in Magento Unable to find required columns: sku
We have been programming the application for the next two weeks to make a valid csv file to import into Magento.
But we have a problem with the import in general as we are getting an error that Magento cannot find the columns we need: sku. I've been browsing a lot of forums.
I saw it might be visibility, but we have it in our csv. I will give you an example of what our csv looks like:
sku,name,ean,manufacturer,price,msrp,tax_class_id,qty,_category,is_in_stock,status,description,_type,visibility,_attribute_set,color,geluidssysteem,platform_consoles,protection,connection,kabel_lengte,lader,nintendo_platform,model,megapixels,geschikt_foto_video_tas,schermdiagonaal,size,keyboard_layout,geheugen,draagstijl_headset,materiaal,type_camera,type_toetsen,left_right_handed,vermogen,toetesenbord_verlicht,sensorkeuze,stroom_voorziening,connection_mouse, MRM-01855,AA FUSION AUDIO 3.5mm to 3.5mm Jack kabel 1 meter wit,5060166512163,Advanced Accessories,3.18,,2,6,Nintendo/Nintendo bundels,1,1,Boomsjors,simple,4,PC kabels,Green,,,,Universal,1.8 Meter,,,,,,,,,,,,,,,120w,,,,,
We also had a problem where the description contains a comma and then will mess up our csv.
If you need more information, let me know!
source to share
Please make sure you are using utf-8 encoded file format for your CSV file. This error occurs mainly with incorrect formatting of the file content. To do this correctly, open your CSV file in an editor and go to "Save As" → Select the file type as " MSDOS CSV (.csv) " and save.
Hope this helps ...
source to share