Problem

Magento attribute dispplayed in red color in Attribute Mapping table (see screenshot above) means that given attribute is not possible to export, because that attribute is not present in Product Flat Catalog. Or, alternatively, Flat Catalog as whole is not enabled.

Solution

In order to export any "red product attribute", follow these steps:

1. Double check that Flat Product Catalog and Flat Category Catalog is enabled in System → Configuration → Catalog → Frontend.
2. Navigate to the attribute's detail in Catalog → Attributes → Manage attributes. Then, set the option Use in product listing to Yes and save attribute details.
3. Finally, reindex Product Flat Index in System → Index management and refresh cache. Sometimes you have to do this step twice.

Troubleshooting

• Following attributes are missing in Product Flat catalog
• Following attributes are missing in Category Flat catalog

Related articles