I'm trying to set the sort order in the category view for magento.

In */app/design/frontend/template_name/default/template/catalog/product/list.phtml* the product category is called this way:


Is there a possibility to sort this collection using e.g. the following? For the record, this doesn't work. ;)

->addAttributeToSort('updated_at','asc')->setOrder('updated_at', 'asc')

1 Answer 1


All I had to do was doing some SQL queries.

Set a frontend label for the sort-by attribute.

update eav_attribute set frontend_label = "Updated" where attribute_code = "updated_at"

Enable used_for_sort_by

update catalog_eav_attribute set used_for_sort_by = 1 where attribute_id = (select attribute_id from eav_attribute where attribute_code = "updated_at")

Set updated_at as standard sorting value (could also be done in back-end)

update core_config_data set value = "updated_at" where path = "catalog/frontend/default_sort_by" 

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.