How to add an attribute to product_flat_table Either one of the following attribute settings is true: backend_typ = 'static' is_filterable > 0 used_in_product_listing = 1 is_used_for_promo_rules= 1 used_for_sort_by = 1 Or you add it manually by observing this event: