Magento categories are not displaying the correct amount of products

This is a known bug in Magento: Magento categories are not displaying the correct amount of products even when you reindex the website. To fix this you need to be experienced in using phpmyadmin. Issue the following command and then wait for a response (it can take a few minutes)

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

Now reindex via the Magento admin and then check your categories. The product count in the Magento categories are now showing correct numbers.
Tags:
Nina Young About the author

I studied mathematics at university, taught myself software development, honed my skills with multinational companies such as IBM and have set up and sold my own businesses. My perspective covers the all important period when a business moves from small and successful to substantial and market-leading, and my personal experience allows me to provide online solutions that give business leaders mastery of their online presence and control over business development.

No Comments

Post a Comment