Image Attribute in Product Flat Catalog – Magento 1.8

flat-catalogimagemagento-1.8

I have a Magento 1.8 CE and I figured out that when using "Product Flat Catalog", the attribute "image" is not collected.
How can i add that attribute to "Product Flat Catalog"
It is not possible to set "Use for Listing" from Manage Attributes.

Any other way to do that?

Best Answer

the solution that I found is most clean and uses Magento's XML-style abstractions to add the image column to the catalog_product_flat_1 table: try this code:- In config.xml:

<config>
    <frontend>
        <product>
            <collection>
                <attributes>
                    <image />
               </attributes>
            </collection>
        </product>
    </frontend>
</config>

Then reindex your flat catalog tables (Admin > Index Management > Select All + Reindex) and clear all Magento caches.

Related Topic