A tip to disable flat tables on the fly in your Magento scripts.
This is sometimes useful to disable flat tables when you want to use EAV tables directly.
A tip to disable flat tables on the fly in your Magento scripts.
This is sometimes useful to disable flat tables when you want to use EAV tables directly.
5 Responses to “Magento: Disable flat catalog on the fly”
What’s the benefits of disabling the flat catalog on the fly?
Not all attributes are included in flat tables. You may need to filter on an attribute that is not included.
This also ensures that you are using the real attribute values since flat tables are indexed and may include obsolete data.
Is this not circumventing the way Magento is supposed to work. I mean if you enabled FLAT then you want to use FLAT?
This has been very useful as our users need to view products in their digital libraries that are no longer enabled.
Thanks!!
I cannor get it to work. Even with this workaround my collection counts 0 products. When I enable the flat catalog again, the collection contains 750 products. Any ideas? This is exactly what I need though.