Magento categories are not displaying the correct amount of products

by | Dec 2, 2013 | 0 comments

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.


Submit a Comment

Your email address will not be published. Required fields are marked *

elan creative

We’re like the in-house website design team you always dreamed of, able to tell your story like nobody else, and focus on your bottom line along with you….

Elan Creative
UK: +44 (0)121 288 3449
NL: +31 (0)20 893 2923

freelance-website-designer s


Get a instant quote for your website design project with our cost calculator:



dental practice website design

LR Smiles

Website design for brand new dental practice LR Smiles




hypnotherapy website design


Nalam Hypnotherapy

Website design for brand new hypnotherapy practice, Nalam Hypnotherapy