Magento : Categories Page Products Count Showing Wrong in Admin

Question

I have totally added 1594 products in my Magento store. Here 806 products are enabled other 788 products are disabled.

In catalog->manage categories counting product shows wrongly see below image.

I have a Categorie called WHAT'S NEW it showing 817 products. And Sub Categorie are

Here please count the sub categories totally 380. But in parent categories shows 817. How it comes...?

And I refer these links Link Here if I select Is Anchor no in view page PRICE, COLOR are hidden.

So how can I solve this counting problem..?

Are you sure there are no products assigned to "Whats New" category specifically? — John
– John, Commented Apr 6, 2017 at 13:01
@John: There are 672 products assigned in Whats New category. And thanks for your replay — Ramesh S
– Ramesh S, Commented Apr 6, 2017 at 13:05

Vadym Kalin · Accepted Answer · 2017-04-11 14:02:51Z

Please use reindex in Magento from the Admin Panel or from the command line.

Method 1: Using the Admin Panel

Method 2: Using the command line

cd shell

php indexer.php --reindexall

Pratik Kamani · Accepted Answer · 2017-07-31 08:21:27Z

2

I have the same issue and just tested this. Without any issue, it works perfectly.

DELETE FROM catalog_category_product where product_id NOT IN (SELECT entity_id FROM (catalog_product_entity))

answered Jul 31, 2017 at 8:21

1,4932 gold badges16 silver badges35 bronze badges

Alex Silenko · Accepted Answer · 2017-07-31 08:32:23Z

1

Please check this answer Category children count fix

answered Jul 31, 2017 at 8:32

1705 bronze badges

3 Answers 3