Magento – Magento sort collection with multiple attributes

magento-1.9sorting

I want to sort Magento product collection with multiple attributes at catalog product list page. I am using this code

$this->_collection->setOrder('price', 'desc');
$this->_collection->setOrder('price_plus_shipping', 'desc');

I also tried this code as well

$this->_collection->setOrder(array('price', 'price_plus_shipping'),Varien_Data_Collection::SORT_ORDER_DESC);

When i sort these both combine its not giving me accurate results but if i use both separately like when i am using only

price_plus_shipping

its working fine also as

price

its also working file
they are showing me accurate results. But i want to use them combine.
in Price i have product prices in price_plus_shipping i have alphabets like

a,b,c etc

Best Answer

Try this :

$this->_collection->setOrder([$field1, $field2, ...], 'DESC');

OR Try this :

$this->_collection->setOrder('price', 'desc');
$this->_collection->getSelect()->order('price_plus_shipping desc');

Related Solutions

Collection Filter Sorting – How to Specify Custom Sort Order for Product Collection

Sadly Magento will validate the order options in Varien_Data_Collection_Db _setOrder function. But you can get the select of the collection and add a new expression to build the order as you like.

/* @var $collection Mage_Catalog_Model_Resource_Product_Collection */
$collection = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('status', 1)
    ->addAttributeToFilter('entity_id', array(
            'in' => $productIds,
        ));

$collection->getSelect()->order(new Zend_Db_Expr('FIELD(e.entity_id, ' . implode(',', $productIds).')'));

foreach($collection as $product) {
    var_dump($product->getId());
}

Here you should see that the product ids are in the order of the array.

Magento-1 – How to Resolve Issues Sorting by Two Attributes

I think the problem here is that there are some special code that needs to be run to sort by price.

If you take a look into the function setOrder on the model Mage_Catalog_Model_Resource_Product_Collection you will see that it does something "special" when dealing with the attribute price.

public function setOrder($attribute, $dir = 'desc')
{
    if ($attribute == 'price') {
        $this->addAttributeToSort($attribute, $dir);
    } else {
        parent::setOrder($attribute, $dir);
    }
    return $this;
}

My suggestion for you is to follow this example and try adding the sort by price in the same fashion and by calling addAttributeToSort.

Best Answer

Related Solutions

Collection Filter Sorting – How to Specify Custom Sort Order for Product Collection

Magento-1 – How to Resolve Issues Sorting by Two Attributes

Related Topic