How to solve Product Flat Data and Category Products (Indexed category/products association) reindex issue

Posted: October 14, 2011 in Version 1.6.*

Hello

Getting to this point ultimately lead to the resolution. Below is the process we used to solve the reindexing issue for Product Flat Data:

1) Export all catalog_product_flat _* tables with data and structure with “Disable foreign key checks? enabled.
2) Drop all catalog_product_flat _* tables.
3) Once check in Frontend , that products are categories are visible
4) Login to Magento backend
5) Go to: System -> Index Management
6) Click “Reindex Data? next to “Product Flat Data? index

Below is the process we used to solve the reindexing issue for Category Products (Indexed category/products association):

1) Log into phpMyAdmin
2) Go to `catalog_category_product_index`
3) Click “Export?.
4) Export only structure with “Disable foreign key checks? enabled.
5) Drop the table `catalog_category_product_index`
6) With the SQL that was exported, remove the constraints at the bottom of the export. Be sure to keep the “SET FOREIGN_KEY_CHECKS? statements.
7) Click “SQL?, paste in modified SQL and click “Go?
8) Login to Magento backend
9) Go to: System -> Index Management
10) Click “Reindex Data? next to “Category Products? index

This worked for me ..Hope it will help you too.

If it helps dont forget to comment me ..

Bijal Bhavsar 🙂

Advertisements
Comments
  1. stavros says:

    Hello Meghna,

    Thanks for sharing your knowledge here much appreciated.
    I have Magento 1.6 running for a store and since last week there is a very odd thing happening.
    The proucts wont show up in the category listing and show up “half” in the product view page.

    Here is the page
    http://www.griekseolie.nl/extra-vergine-olijfolie-uit-griekenland.html

    I have searched the web for a solution but found nothing
    The indexing works.
    Everything is double checked.

    Any help or idea would be much appreciated.
    Stavros

  2. aaa says:

    Worked great for the Product Flat data! Thanks!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s