Magento 1.9 – How to Change Sort Order for Search Results

magento-1.9searchsorting

i have made a new attribute called Best sellers (attribute code: search_order) so I can sort my products showing the best sellers at the top when someone searches for products. However when someone searches at the moment it is sorted by relevance and they have to select Best sellers. Is there a way i can change it so by default it is sorted by best sellers?

I tries to change the function setListOrder in result.php to

 public function setListOrders()
    {
        $category = Mage::getSingleton('catalog/layer')
            ->getCurrentCategory();
        /* @var $category Mage_Catalog_Model_Category */
        $availableOrders = $category->getAvailableSortByOptions();
        unset($availableOrders['position']);
        $availableOrders = array_merge(array(
            'search_order' => $this->__('Best sellers'),
            'relevance' => $this->__('Relevance')

        ), $availableOrders);

        $this->getListBlock()
            ->setAvailableOrders($availableOrders)
            ->setDefaultDirection('desc')
            ->setSortBy('search_order');

        return $this;
    }

but that just put Best sellers at the top of the sort by list but didnt actually sort the results

Thank you if you can help

Best Answer

I found the answer after some intense searching on Stack Overflow all i had to do was add these lines to my layout.xml

<catalogsearch_result_index>
    <reference name="search_result_list">
        <action method="setDefaultDirection"><param>asc</param></action>
        <action method="setSortBy"><param>attribute_you_want_to_use</param></action>
    </reference>
  </catalogsearch_result_index>
  <catalogsearch_advanced_result>
        <reference name="search_result_list">
            <action method="setDefaultDirection"><param>asc</param></action>
            <action method="setSortBy"><param>attribute_you_want_to_use</param></action>
        </reference>
    </catalogsearch_advanced_result>

Related Solutions

Magento Search Results – Sort by Ordered Quantity

One way of solving your issue is; by adding additional sort option like Relevance/Position sort option. In order for you to add a "ordered quantity" option you need to do the following:

First copy Config.php from app/code/core/Mage/Catalog/Model/Config.php to app/code/local/Mage/Catalog/Model/Config.php and replace this function getAttributeUsedForSortByArray() with the following code:

public function getAttributeUsedForSortByArray()
{
    $options = array(
        'position'  => Mage::helper('catalog')->__('Position'),
        'ordered_qty'  => Mage::helper('catalog')->__('Ordered Qty'),
    );
    foreach ($this->getAttributesUsedForSortBy() as $attribute) {
        /* @var $attribute Mage_Eav_Model_Entity_Attribute_Abstract */
        $options[$attribute->getAttributeCode()] = $attribute->getStoreLabel();
    }

    return $options;
}

Second copy Toolbar.php from app/code/core/Mage/Catalog/Block/Product/List/Toolbar.php to app/code/local/Mage/Catalog/Block/Product/List/Toolbar.php and replace this function setCollection() with the following code:

public function setCollection($collection)
{
    $this->_collection = $collection;

    $this->_collection->setCurPage($this->getCurrentPage());

    // we need to set pagination only if passed value integer and more that 0
    $limit = (int)$this->getLimit();
    if ($limit) {
        $this->_collection->setPageSize($limit);
    }
    if ($this->getCurrentOrder()) {
        if($this->getCurrentOrder() == 'ordered_qty') {
            $this->getCollection()->getSelect()
                 ->joinLeft('sales_flat_order_item AS so', 'e.entity_id = so.product_id', 'SUM(so.qty_ordered) AS ordered_qty')
                 ->group('e.entity_id')->order('ordered_qty ' . $this->getCurrentDirection());
        } else {
            $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
        }
    }
    return $this;
}

Third to set "Ordered Qty" sort option as default for Search Result and Advance Search Result add/edit local.xml under your active theme folder app/design/frontend/your_package/your_theme/layout/local.xml and add the following:

<?xml version="1.0" encoding="UTF-8"?>
<layout>
    <catalogsearch_result_index>
        <reference name="search_result_list">
            <action method="setDefaultDirection"><param>desc</param></action>
            <action method="setSortBy"><param>ordered_qty</param></action>
        </reference>
    </catalogsearch_result_index>
    <catalogsearch_advanced_result>
        <reference name="search_result_list">
            <action method="setDefaultDirection"><param>desc</param></action>
            <action method="setSortBy"><param>ordered_qty</param></action>
        </reference>
    </catalogsearch_advanced_result>
</layout>

I hope this will help you.

Best Answer

Related Solutions

Magento Search Results – Sort by Ordered Quantity

Related Topic