Magento Indexer – Adding Custom Attribute to Flat Table

flat-catalogindexingmagento-1product-attribute

Magento Not adding custom Attribute to flat table…..
I have a market place extension…which have some attribute but some attributes not adding to flat table…due to my extension not working….

attribute setting is…

$catalogEavSetup->addAttribute(Mage_Catalog_Model_Product::ENTITY, 'approval', array(
    'group' => 'General',
    'sort_order' => 21,
    'type' => 'int',
    'backend' => '',
    'frontend' => '',
    'label' => 'Approval',
    'note' => '',
    'input' => 'select',
    'class' => '',
    'source' => 'vendorsproduct/source_approval',
    'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
    'visible' => true,
    'required' => false,
    'user_defined' => false,
    'default' => '1',
    'visible_on_front' => false,
    'unique' => false,
    'is_configurable' => false,
    'used_for_promo_rules' => false,
    'used_in_product_listing'  => true,
));

whole setting is correct..but due to mysql limit 65536…some attributes is not adding to flat tables…
I need to know that how to add these attribute in flat tables…

Best Answer

You need to enable visible_on_front to push into the Catalog Flat tables. Category flat tables are affected by used_in_product_listing.

As for the limit in MySQL I believe that is a separate question and should be migrated out as a separate Q&A.