Magento 1.9 Flat Catalog Product – getSku Not Working

flat-catalogmagento-1.9sku

If i activate Flat Catalog Product, than Magento do not view sku on Product and category page with this code:

<?php echo $this->htmlEscape($_product->getSku()); ?>

Best Answer

This means that the SKU attribute is not loaded. It should be enough to edit the sku attribute under Catalog - Attributes - Manage Attributes. If you want to use it on the product page, set "Visible on Product View Page on Front-end" to "Yes". If you want to use it on the category page, set "Used in Product Listing" to "Yes".

Related Solutions

Fix Flat Catalog Product Option ‘Yes/No’ Issue in Magento

There is core Magento "feature" which makes non-flat attributes not working in addAttributeToFilter() filtering when you use simple form:

addAttributeToFilter($attribute, $value)

Try to change this to following form:

addAttributeToFilter(array(array('attribute' => $attribute_code, 'eq' => $option["value"])))

Another thing which is not exactly related with your question, is that you could try to optimize your code - eg. change count($collection->getAllIds()) calls to $collection->getSize().

Image Attribute in Product Flat Catalog – Magento 1.8

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.

Best Answer

Related Solutions

Fix Flat Catalog Product Option ‘Yes/No’ Issue in Magento

Image Attribute in Product Flat Catalog – Magento 1.8

Related Topic