Count Associated Products for Configurable Products in Magento 1.9

associated-productsconfigurable-productmagento-1.9

Is it possible to get a count of the total number of associated products assigned to a configurable product?

I have tried using the following functions:

getConfigurableAttributesAsArray()
getProductCount()
count()

However, I've only seen this working when applied to categories, not configurable products. While I do want to output the count in list.phtml, I want to output it per product, not for the entire category.

Best Answer

While the approach offered by jigs parmar does work, it is a HUGE performance hit if used in a loop! A much better approach is:

$childIds = $_product->getTypeInstance(true)->getChildrenIds($_product->getId(), false); //$_product is defined in the loop
$colors = count($childIds[0]); //getChildrenIds() returns an encapsulated array
echo $colors.' Color';
if ($colors != 1) echo 's'; //make "Color" plural

The reason is that getUsedProducts() returns every simple product along with every attribute of those products. In a loop, that took forever!

Since I only needed the number of products, I could use getChildrenIds() which only returns the ID of the simple products--much lighter code!

Related Solutions

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
);

Magento Configurable Products – Count In-Stock Associated Products

Like Tim said in him comment above ideally you don't want to be running load within a loop as this causes extra work and MySQL calls. (Making it "really slow")

I had a play around and I think I have a rough version of what your trying to achieve - get a count of configurable products who have at least 1 associated products that are in stock in category X?

May not be perfect, but should work and much faster too.

    <?php
//Update part 1 start
$eavAttribute = new Mage_Eav_Model_Mysql4_Entity_Attribute();
$code = $eavAttribute->getIdByCode('catalog_product', 'status');
//Update part 1 end

    $currentCat = Mage::registry('current_category');

    //Gets all simple products that belong to a configurable product
    $productCollection = Mage::getResourceModel('catalog/product_type_configurable_product_collection')
        ->setFlag('require_stock_items', true)
        ->setFlag('product_children', true);

    //Adds stock, status and visibility filters.
    Mage::getSingleton('cataloginventory/stock')->addInStockFilterToCollection($productCollection);
    $productCollection->addAttributeToFilter('status', 1);
    $productCollection->addAttributeToFilter('visibility', 1);

    //Filters by simple products who's parents are in the current category
    $productCollection->getSelect()->joinLeft(
        array('ccp' => 'catalog_category_product'),
        'link_table.parent_id=ccp.product_id',
        array('*'))->where('ccp.category_id = ?',$currentCat->getId())->group('parent_id');

//Update part 2 start
    $productCollection->getSelect()->joinLeft(
        array('statust' => 'catalog_product_entity_int'),
        'link_table.parent_id=statust.entity_id',
            array('value'))->where('statust.value = ?',Mage_Catalog_Model_Product_Status::STATUS_ENABLED)->where('statust.attribute_id = ?',$code);

//Update part 2 end

    $cnt = $productCollection->count();
echo $cnt;

    ?>

Best Answer

Related Solutions

Magento – List configurable products with certain criteria

Magento Configurable Products – Count In-Stock Associated Products

Related Topic