Posted By

ddavidd on 03/30/12

Tagged

php
magento

Versions (?)

Last Edited at 03/30/12 03:24pm

Statistics

Viewed 1896 times

Favorited by 1 user(s)

Related snippets

Add a SKU column to the order grid in Magento 1.6.1

/ Published in: PHP

Add the below commented sections into the appropriate functions in your /app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php and you'll be good to go! This has been (personally) tested with 1.6.1.0

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

/* You will need to edit/replace your $collection declaration in _prepareCollection() */
 
$collection = Mage::getResourceModel($this->_getCollectionClass())
    ->join(
        'sales/order_item',
        '`sales/order_item`.order_id=`main_table`.entity_id',
        array(
            'skus'  => new Zend_Db_Expr('group_concat(`sales/order_item`.sku SEPARATOR ",")'),
            'names' => new Zend_Db_Expr('group_concat(`sales/order_item`.name SEPARATOR ",")'),
            'quantities' => new Zend_Db_Expr('group_concat(`sales/order_item`.qty_ordered SEPARATOR ",")'),
            )
    );
$collection->getSelect()->group('entity_id');
 
/* You will then need to add new columns in _prepareColumns() */
 
$this->addColumn('sku', array(
    'header'    => Mage::helper('Sales')->__('Skus'),
    'width'     => '100px',
    'index'     => 'skus',
    'type'        => 'text',
 
));
$this->addColumn('names', array(
    'header'    => Mage::helper('Sales')->__('Name'),
    'width'     => '100px',
    'index'     => 'names',
    'type'        => 'text',
));