Adding Shipping Method to the Magento Order Grid

Open /app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php

Create the file structure of :

/app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php

Copy the contents of the Core file, and paste into the Local version.

Find the protected function _prepareCollection.  You are going to modify this function by adding one line to make the custom attribute available for inserting into the grid.

Just add this line :
$collection->getSelect()->join('sales_flat_order', 'main_table.entity_id = sales_flat_order.entity_id',array('shipping_description'));

after this line:

$collection = Mage::getResourceModel($this->_getCollectionClass());
So altogether you should have a function that looks like this:
protected function _prepareCollection()
{
$collection = Mage::getResourceModel($this->_getCollectionClass());
$collection->getSelect()->join('sales_flat_order', 'main_table.entity_id = sales_flat_order.entity_id',array('shipping_description'));
$this->setCollection($collection);
return parent::_prepareCollection();
}

 

So now that you’ve modified that function we need to add the new column to the grid using the addColumn method.  So now find the _prepareColumns() function.

Now just add this code :
$this->addColumn('shipping_method', array(
'header' => Mage::helper('sales')->__('Shipping Method'),
'index' => 'shipping_description',
));

In order to prevent a massive “SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘status’ in where clause is ambiguous” ERROR when sorting your orders…Make sure you add this:
'filter_index'=>'main_table.status',
to the addColumn Status array

Now save and upload your new Local Grid.php file, login to Magento Admin, Browse to Sales > Orders  and you will see your BRAND NEW SHINY column!

 

Cheers!