If you’ve ever gone in to re-index your Product Flat Data index, and noticed that the orange Processing… status icon won’t go away, you are not alone! It’s quite a common problem, especially for those that have backed-up and restored any piece of the Magento database, especially anything relating to emptying or truncating the product tables to remove all products in Magento and reset product IDs to 0. Luckily, there’s *usually* a simple fix!
A simple way that typically works is to truncate (empty) the catalog_product_flat_1 table that Magento uses for it’s product flat data index. To do that:
1. Login to phpMyAdmin if you have it.
2. Locate your Magento database, and run this SQL query:
3. Run the query (**Don’t forget to append any table prefixes that you may be using!! If your tables look like: “mymagento_catalog_product_flat_1” for instance**)
Another thing that might be happening is that your /var/locks folder may have stale locks, which need to be removed.
1. Find /var/locks folder in your file structure, and delete everything within the locks folder.