When trying the import of products and it is only an export, the product to import new- it came to the mentioned error
Required attribute ‘media_gallery’ has an empty value in rows: 438
Please fix errors and re-upload file or simply press “Import” button to skip rows with errors
Then we looked for the addressed line (in another file there were significantly more lines) and inserted in the column field “media_gallery” a 0 a. A simple ranged from zero here.
During the next import attempt it worked.
If there are any other missing attributes, look in the back are the best to choose which attributes here and the appropriate value in the Enter Table.
For editing. Csv tables suitable way Open Office Calc ganz gut, which you can download and use for free. Here (Thus, not only in terms of the cost) there is the one and the other great compatibility advantage over Microsoft Excel.
However it is important after a. Csv file was opened and changed, that when saving in any case on “Save” is clicked and not only “Save”, because otherwise the program will automatically use a semicolon as a separator and thus Magento can not do anything. Wenn man also “Save” has selected and chosen the appropriate name, that is below the hook at “Edit filter settings” is
and then necessarily “Unicode (UTF-8)” selected as well as field separator and a comma as a separator text quotes. With these settings, the Magento import can then do something.
Used in Magento Version 1.6.2.0. Comments, Suggestions, Ask? Gladly!