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.

0 Comments

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
hello@elancreative.studio
UK: +44 (0)121 288 3449
NL: +31 (0)20 893 2923

freelance-website-designer s

QUOTE

Get a free quote for your website design project: