Hi i need to enable catalog flat product to boost magento but i have big problem with magento collection. If $visibility is enabled it will crash with 4 Unknown column 'e.visibility' in 'where clause' , if i remove it will load the collection but without image,price,name.
i manage to include name and price in app/core/core.../Collection.php but still i don't know how to load the image.
Maybe this is the wrong way but i hoped it will work, i was wrong.
even 2,3 free extensions that i have used will not work on if collection is from reports.
any help?

  • 2
    To add attributes to the catalog_product_flat tables, you need to set them "used in product listing" yes. Commented Jan 17, 2014 at 16:14

1 Answer 1


Don't edit app/core/core.../Collection.php never! To add some attribute to flat table, you should configure this attribute. Read this What are the differences between EAV and Flat catalogs?

  • Attribute price is in "product listing" but still not displaying.any info?also about the image? Commented Jan 17, 2014 at 17:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.