Get product count of Parent Category

Question

Trying to get the product count of a category which also counts the products in its children. Currently, I have:

$categories = Mage::getModel('catalog/category')->getCollection()
        ->addAttributeToSelect('*')
        ->addAttributeToFilter('level', 2)
        ->addAttributeToSelect('is_active', 1);

 foreach ($categories as $cat) {
      echo count($cat->getProductCollection());
 }

however this returns the product count of the parent category without counting its child category products. How do I include the child categories in the parent count?

score 1 · Accepted Answer · answered Jun 28 '16 at 11:25

I figured it out - here's my code for anyone who has the same issue:

public function countProductsInCategory() {
       $parentCategories = $this->getParentCategories();

       //sets up the arrays
       $parentArray      = array();//parent categories
       $valueArray       = array();//the count of the child category products
       $tmp              = array();//merging of the two

       foreach ($parentCategories as $_parent) {
           $parentCat   = Mage::getModel('catalog/category')->load($_parent->getId());
           $parentCount = $parentCat->getProductCount();
           $children    = $_parent->getChildrenCategories();
           $i           = $parentCount;

           $parentArray[$_parent->getName()][] = $i;

           foreach ($children as $_child) {
                $childCat   = Mage::getModel('catalog/category')->load($_child->getId());
                $childCount = $childCat->getProductCount();

                $parentArray[$_parent->getName()][] = $childCount;
            }
        }

        foreach ($parentArray as $val) {
            $valueArray[] = array_sum($val);
        }

        $i = 0;//start i as 0

        foreach ($parentCategories as $name) {
            $tmp[$i] = array('name' => $name->getName(), 'url' => $name->getUrl());
            $i++;
        }

        $i = 0;//reset $i to 0 to match indexes

        foreach ($valueArray as $val) {
            $tmp[$i]['value'] = $val;
            $i++;
        }

        return $tmp;
    }

score 0 · Answer 2 · answered Jun 28 '16 at 04:42

0

You can use for get product count of a specific category.

$productsCount = Mage::getModel('catalog/category')->load($category->getId())
 ->getProductCount();

echo($productsCount);

You can use here $category->getId() replace category ID as static. Here you replace category ID which you want get product count.

answered Jun 28 '16 at 04:42

Vikal Singh

1
2

Hi this only gets the product count of that category - it doesn't include the children categories or its products to the parent :( – 123TFO Jun 28 '16 at 08:09

score 0 · Answer 3 · answered Jun 28 '16 at 11:37

Try this:

$categories = Mage::getModel('catalog/category')->getCollection()
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('level', 2)
    ->addAttributeToSelect('is_active', 1)
    ->setLoadProductCount(true);

foreach ($categories as $category) {
    echo $category->getProductCount();
}

Get product count of Parent Category

3 Answers3