CODEWITHSUNDEEP
magento
saurav
saurav

Reputation: 487

magento admin category product count wrong

magento admin category product count wrong , in my admin category count is more that real product in that category how can it be fixed please guide , i am using magento 1.9.2.1

i check few older answer most of them deals with deleting database or some db query , but is it righ to do that please guide way to sort it out

Upvotes: 0

Views: 1912

Answers (2)

Pratik Kamani
Pratik Kamani

Reputation: 758

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

Upvotes: 0

Makwana Ketan
Makwana Ketan

Reputation: 1388

This is a bug in Magento but it will not create any issue at frontend.

In normal case, when you assign products to category then those products will be linked with that category and linked product count will be increased for that category. And if you unlink that product from that category then linked product count will be decreased.

Now problem will be arise when you delete product from catalog->product section. Still category will have entry for that product. So old product count will be in category.

If you want then follow below link.

magento showing wrong product count in category

Hope you understood well.!

Upvotes: 2

Related Questions