Magento 1.9 – Add Attribute Column to Admin Product Grid

Inchoo wrote a great article on extending the order grid. And on the Atwix blog there's an article on adding a column from a different table.

The Inchoo blog post basically extends it with a custom extension. In case you're not familiar with writing your own extension I'd suggest you take a loot at Alan Storms tutorial or the one from Magento 4U.

You will be rewriting the Mage_Adminhtml_Order_Grid block class adding a column to the _prepareColumns method and extending the _prepareCollection method with your custom field

Add this above your column defnition:

$weight = Mage::getModel('eav/config')->getAttribute('catalog_product', 'custom_weight');
$options = $weight->getSource()->getAllOptions(false);
$weights = array();
foreach ($options as $option){
    $weights[$option['value']] = $option['label'];
}

and define your column like this

$this->addColumn('custom_weight',
    array(
      'header'  => Mage::helper('catalog')->__('Weight'),
      'width'   => '60px',
      'index'   => 'custom_weight',
      'type'    => 'options',
      'options' => $weights
    )
);