Add the "Only x Left" in product list page

Question

I have a custom theme template for my magento 1.9.1 and would like to add the "only X left" in my product list page. It is already in my product view page however I want it to show on every single product in the grid list page. How do I add to it?

Answer 1

Rather than instantiating the model for each product rather do this.

Create a magento module, and add these bits to it.

In the module config.xml

<frontend>
    <events>
        <catalog_product_collection_load_after>
            <class>your_module/observer</class>
            <method>addStockItemData</method>
        </catalog_product_collection_load_after>
    </events>
</frontend>

In the module observer

<?php 
// observer
public function addStockItemData($observer)
{
    $collection = $observer->getCollection();
    Mage::getSingleton('cataloginventory/stock')->addItemsToProducts($collection);
}

That will do the trick

Answer 2

You'd need to modify the theme's template/catalog/product/list.phtml file so that it included the required bits. That would be something like this under the grid mode and/or list mode depending on your site.

<?php $qty = Mage::getModel('cataloginventory/stock_item')->loadByProduct($_product)->getQty(); ?>
<?php if ($qty): ?>
    Only <?php echo $qty; ?> left
<?php else: ?>
    Out of Stock
<?php endif; ?>

However that would only work for simple products and would probably say all configurable, grouped, or bundled ones are out of stock so you'd want to modify it a bit more to work with that if you use configurable, grouped, or bundled products.

Answer 3

I've fixed the problem by editing /app/code/core/Mage/Catalog/Model/Product/Type/Configurable.php file and added one line that seems to be missing in 1.9.1.0 (->addAttributeToSelect('*'))

$usedProducts = array();
$collection = $this->getUsedProductCollection($product)
->addAttributeToSelect('*')
->addFilterByRequiredOptions();