How to fix “Invalid value for ‘status’” when importing products in Magento 1.5.0.1?

Invalid value for ‘status’ in row …

The correct values for the “status” field when importing form CSV files are:

1 for “Enabled”
2 for “Disabled”

This applies at least when importing via “System -> Import / Export -> Import”, maybe not to the Dataflow profiles (which, at least in earlier versions, used i18n’ed values like “Aktiviert” and “Deaktiviert” for German).

You can always check what values are the correct ones by exporting one enabled and one disabled product. Admittedly “1” and “2” instead of “1” and “0” is really counter-intuitive.

Invalid value for ‘generate_meta’ in row …

Invalid value for ‘imported’ in row …

This can happen when the locale you used for writing the file is differentf rom the interface locale setting when importing it. Check the “Interface Locale:” dropdown at the bottom of every page in the Magento backend for that! For example, the correct values for “generate_meta” when importing with German locale are “Ja” and “Nein”, but with English locale probably “Yes” and “No”.

Posted

2012-08-29

[English], Computing

matt

Tags:

Comments

One response to “How to fix “Invalid value for ‘status’” when importing products in Magento 1.5.0.1?”

Maria

2013-08-20

Magento very often says that some data are missing during import. So you have to check if this field mentioned in the error has the values indicated, if not, input them.
In case you have data listed, by Magento does not “see” them, check if each entity is in separate row and the first one needs to be the header. IAlso try to open the file using any spreadsheet program making sure that character set has UTF-8 encoding. Check also this article –
http://blog.mag-manager.com/2013/01/101-magento-import-questions.html

This site uses Akismet to reduce spam. Learn how your comment data is processed.