Magento: Rebuilding Flat Catalog Programmatically

Posted by karnage on Stack Overflow See other posts from Stack Overflow or by karnage
Published on 2010-03-18T17:17:53Z Indexed on 2010/03/18 17:21 UTC
Read the original article Hit count: 544

Filed under:

I am using a cron to import inventory changes nightly. When I try to change a product's information (price, etc) I get the following error:

Column not found: 1054 Unknown column 'e.display_price_group_0' in 'field list'

I can fix this by clicking "Rebuild Flat Catalog Product" in the Cache Management panel. I setup a cron to do this programmatically using the following code:

Mage :: getResourceModel( 'catalog/product_flat_indexer' ) -> rebuild();

I don't get any errors when I run the script, but the "Column not found" error persists.

Does anyone know how I can rebuild the flat catalog other than through the admin interface?

© Stack Overflow or respective owner

Related posts about magento