Magento – How to display bundled products in category list when simple product is out of stock

catalogconfigurationmagento-1

I'm trying to display the bundled product in the category product list on the frontend even when the simple product it concists of is out of stock. I only want to hide the add to cart button.

I've looked into changing the Mage_Bundle_Model_Product_Type class to return true on the stock check but that is not really a solution.

Is there a way to do this in a clean way either trough settings or by extending as little core code as possible?

Best Answer

You could create some method in one of the helpers

public function isBundleAvailable($_product) {
    $bundle = Mage::getModel('catalog/product')->load($_product->getId());
    $selectionCollection = $bundle->getTypeInstance(true)->getSelectionsCollection(
        $bundle->getTypeInstance(true)->getOptionsIds($bundle), $bundle
    );
    $items = array();

    foreach($selectionCollection as $option) {        
        $isAvailable = $option->getStockItem()->getIsInStock();
        if (!$isAvailable) {
            return false;
        }
    }
     return true;
}

Then in template you could use something like that:

<?php if (Mage::helper('my_module')->isBundleAvailable($_product)): ?>
    <?php //display add to cart button
<?php endif ?>

Related Solutions

Magento – Configurable product – Inventory – Stock Availability status doesn’t change when all associated Simple products go out of stock

Magento confirmed this is not part of Magento (Enterprise or Community). The parent (configurable) Stock Availability Status remains untouched regardless of what happens to any of it's children (simple).

Magento actually provided me with a patch (for EE v1.12.0.2) for Enterprise that checks all a parents children status before deciding to display it or not. This seems to work by default in Community 1.7. But this is only a frontend fix.

To fix the parent Availibity Status you can do one of the following:

Listen out for the cataloginventory_stock_item_save_after event. Then in your Observer class for configurable product types (or other types that have children) you can load $product->getTypeInstance()->getUsedProducts(); and do your necessary checks and updates.
Extend the class Mage_CatalogInventory_Model_Stock_Item and in the _afterSave() function do the same as above. Be careful doing rewrites. It might already be extended by another third party module.

Hope this helps. Tadhg

Magento – List configurable products with certain criteria

You can use below mysql query to get all the configurable products which are not associated with any simple products.

SELECT entity_id FROM `catalog_product_entity`
WHERE `type_id` = 'configurable' AND entity_id NOT IN(
    SELECT DISTINCT parent_id FROM catalog_product_super_link
);

Best Answer

Related Solutions

Magento – Configurable product – Inventory – Stock Availability status doesn’t change when all associated Simple products go out of stock

Magento – List configurable products with certain criteria

Related Topic