We've recently discovered (after an upgrade) that Magento EE 1.14.1
no longer keeps the catalog_product_flat
tables updated unless you have Use Flat Catalog Product
in System->Config->Catalog->Frontend
enabled.
Even manually re-indexing through the shell does not populate catalog_product_flat_1
like it used to in previous versions. I believe this change was made sometime on or after 1.13.
All previous versions would keep catalog_product_flat_1
up to date regardless of this Use Flat Catalog Product
setting.
We do not wish to enable Use Flat Catalog Product
on the front-end, but somehow we need to keep catalog_product_flat_1
updated as we have various extensions and feeds that use this table.
Does anyone have any ideas?