Magento sort order

Question

I am currently displaying items from a selected category in a slider in the following way:

    $cat_id = $homepage["homeproductstype_{$homepage['amount']}_3"];
    $_products = Mage::getResourceModel('catalog/product_collection')
    ->addAttributeToSelect(array('name', 'price', 'small_image', 'short_description'), 'inner')
    ->addAttributeToSelect('special_price')
    ->addAttributeToSelect('status')
    ->addCategoryFilter(Mage::getModel('catalog/category')->load($cat_id));

What I would like to do here though, is to have them displayed by ID in ASC order.

What is the best way to have this achieved?

I think by default it is ordered by id , but if it is not than you can try something like this ->setOrder('id', "asc") at the end of query. — Mahmood Rehman
– Mahmood Rehman, Commented May 30, 2013 at 4:22

Mufaddal · Accepted Answer · 2013-05-30 04:21:24Z

1

You can use addAttributeToSort() function to sort your collection based on id.

Add this to your collection addAttributeToSort(’entity_id’, ‘asc’);

See magento collection page for more info http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/using_collections_in_magento

answered May 30, 2013 at 4:21

Mufaddal

5,3817 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nickyfsh Over a year ago

Thank you very much, I just figured this method out.

nickyfsh · Accepted Answer · 2013-05-30 04:24:27Z

0

Sorted it out by adding

    ->addAttributeToSort('entity_id', 'asc');

answered May 30, 2013 at 4:24

nickyfsh

1752 gold badges6 silver badges15 bronze badges

Collectives™ on Stack Overflow

Magento sort order

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related