Let's talk Contact us. No cost. No obligation.

Fill out this form and we will contact you with in 24 hrs.




Knowledge Base

Error – There was a problem with re-indexing process (Product flat data) indexes

April 22, 2014

If re-indexing the Product flat data index gives an unknown re-indexing error or “Some problem with re-indexing process” error message or the re-indexing of Product flat data index is never completed, then it is most likely due to references to products that have been deleted or no longer exist.

You could try truncating those catalog_product_flat_* tables. Backup your database and then via MySQL console, phpMyAdmin or other MySQL client run the following:
truncate table catalog_product_flat_1;
truncate table catalog_product_flat_2;
truncate table catalog_product_flat_3;

Do this for all catalog_product_flat_* tables. Then re-index the Product flat data index to rebuild / repopulate those tables.

About Tarun Vishnoi

Software Professional with around six years of experience in software industry. My area of expertise includes:- Php, Mysql, Magento, Joomla, Wordpress, Ajax, JQuery, Javascript, Json.