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

INSTANT QUOTE

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

LATEST DESIGNS

 

dental practice website design

LR Smiles

Website design for brand new dental practice LR Smiles

 

LATEST DESIGNS

 

hypnotherapy website design

 

Nalam Hypnotherapy

Website design for brand new hypnotherapy practice, Nalam Hypnotherapy