Magento2: Get category product count which is show in admin after the category name

Question

I want to show category product count which is shown in admin after the category name. As of now I write this code but it's not working properly.

$category->getProductCollection()->count();

Please see the image to get better idea.

Magento Backend

Magento Frontend

Answer 1

Not sure if this is still relevant but answering it anyway. The answer post by @Jean Paul CP is correct. $category->getProductCount(); return exactly the count which shown in the admin panel categories listing. On the other hand $category->getProductCollection()->count(); only returns count of active saleable products in the category.

Answer 2

To get the current category product count

Create your own module at below location Magento_root/app/code for that create Package/Modulename

Create below files there

registration.php

etc/module.xml

Block/Blockfile.php

view/frontend/layout/module_section_page.xml

view/frontend/templates/template.phtml

Put this code in your Blockfile.php

<?php
namespace Package\Module\Block;

class Blockfile extends \Magento\Framework\View\Element\Template{
public function __construct(
        \Magento\Framework\View\Element\Template\Context $context,
            \Magento\Framework\Registry $registry
    ) {
        $this->_registry = $registry;
        parent::__construct($context);
    }
    public function getCurrentCategory(){
        $current_Category = $this->_registry->registry('current_category');
        return $current_Category;
    }
}

& this code in your template.phtml

    <?php
    $current_Category = $block->getCurrentCategory();
echo $current_Category->getName().'('.$current_Category->getProductCollection()->Count().')';
$categories = $this->getStoreCategories(true,false,true);
if($current_Category->hasChildren()){
    $subCategories = $current_Category->getChildrenCategories($categories);
      foreach($subCategories as $subCategory) {
         echo '<li style="color:Green;"><a href="'.$subCategory->getUrl().'">'.$subCategory->getName().'(' .$subCategory->getProductCollection()->Count().')'.'</a></li>';
          }
}     

Run The below Command & see the changes

php bin/magento setup:upgrade

Still facing any issue feel free to revert back

Update:

It is working fine for me you can have a look

Backend:

Frontend

Note: Try to avoid the use of objectmanager into the template files

Answer 3

Admin panel uses:

Magento\Catalog\Model\ResourceModel\Category\Collection::setLoadProductCount(true)

This flag adds products count to categories in collection. Use the flag before load(). It counts products of child categories too.

For example, I want to get products count for categories 4 and 5:

$categoryCollection->setLoadProductCount(true)
    ->addIdFilter([4,5])
    ->load();

Also you can use next method of the collection:

loadProductCount($items, $countRegular = true, $countAnchor = true)

Answer 4

This one using objectmanager. You can also inject the CategoryFactory and use it. As per your requirement you need to pass the category ID in foreach to achieve this.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance(); 
$cateinstance = $objectManager->create('Magento\Catalog\Model\CategoryFactory');
$allcategoryproduct = $cateinstance->create()->load($cateid)->getProductCollection()->addAttributeToSelect('*');
echo $count = $allcategoryproduct->count();

Answer 5

$_objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$category = $_objectManager->create('Magento\Catalog\Model\Category')->load($categoryId);
$product_count = $category->getProductCount();

Answer 6

Take a look at this:

vendor/magento/module-catalog-graph-ql/Model/Resolver/Category/ProductsCount.php

    $productsCollection = $category->getProductCollection();
    $productsCollection->setVisibility($this->catalogProductVisibility->getVisibleInSiteIds());
    $productsCollection = $this->stockProcessor->process($productsCollection, $this->searchCriteria, []);

    return $productsCollection->getSize();