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