After updating from to the catalog_product_flat index is not longer shown.

The index is neither shown in Magento Backend nor if i call

php shell/indexer.php info

It is activated under System > Config > Catalog > Catalog > Shop

I can still call it directly via

php shell/indexer.php --reindex catalog_product_flat

and the database tables are filled and used.

Any idea how it comes or to fix it?

2 Answers 2


The reason is an old version of Miravisit AsyncIndex extension. If I deactivate it, the catalog product index appears. If the extension is active, the index is hidden.

  • An update of the extension fixed the problem.
    – waltavista
    Nov 20, 2015 at 15:34

That might be because your Flat Catalog Product and Flat Catalog Category is set to No in admin panel


Use Flat Catalog Category
Use Flat Catalog Product

Change this settings to Yes and check indexing page

  • No, it is activated for both.
    – waltavista
    Oct 5, 2015 at 14:10
  • Have you cleared cache ? Oct 5, 2015 at 17:27
  • Of course :) Many times. Only catalog_product_flat is not available. catalog_category_flat shown as normal.
    – waltavista
    Oct 6, 2015 at 3:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.