Magento sort items ordered

Question

When I'm in: index.php/admin/sales_order/view/order_id/[ID]/key/[KEY]/ I can see the: "Items Ordered"

I'm looking for the code where the products are loaded in this table. I want to sort the ordered items by SKU.

Any hints?

PS: I was looking in app/code/core/Mage/Adminhtml/Block/Sales/Order/View but couldn't find anything.

score 2 · Answer 1 · answered Jan 27 '15 at 12:09

$collection->getSelect()->join(array(
            'item'=>$collection->getTable('sales/order_item')),
            'item.order_id=`main_table`.entity_id AND item.product_type="simple"',
            array(
                'skus' => new Zend_Db_Expr('group_concat(item.sku SEPARATOR ", ")'),
                'name' => new Zend_Db_Expr('group_concat(item.name SEPARATOR ", ")')
            ));

$this->addColumn('skus', array(
            'header' => Mage::helper('sales')->__('SKU'),
            'index' => 'skus',
            'type' => 'text',
        ));

        $this->addColumn('name', array(
            'header' => Mage::helper('sales')->__('NAME'),
            'index' => 'name',
            'type' => 'text'
        ));

Rachel Gallen · Answer 2 · 2013-01-28T21:34:23.543

0

You can add SKU as an option in the Manage Attributes menu in Admin. Having done that, set it to be the default in System > Configuration > Catalog > Catalog > Product Listing Sort By.

try this alternatively you might like this

edited Jan 28 '13 at 21:34

answered Jan 28 '13 at 20:00

Rachel Gallen

27,943
21
72
81

thanks. But this is frontend and my question is about the backend. – Bob van Luijt Jan 28 '13 at 21:23
i have added links you might find the 2nd one more useful. – Rachel Gallen Jan 28 '13 at 21:34
I've also got the question here. It's a tricky one... http://magento.stackexchange.com/questions/3719/sort-orders-by-sku-in-order-overview – Bob van Luijt May 14 '13 at 21:55

Magento sort items ordered

2 Answers2