Magento – Production Import “Required attribute ‘media_gallery’ has an empty value in rows:” Error

Picture

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.

PictureHowever 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” isPicture 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!

Published by Covos

Since 2009 I have been working intensively with Magento. I started with the creation and operation of B2C stores. This was extended through my work in the logistics sector. This resulted first specialized B2E systems. Today I work day-a day with exciting B2C, B2B- and B2E projects and reports in this blog about challenges and give insider tips.

Leave a Reply

Your email address will not be published. Required fields are marked *