Just copy Grid.php to app/code/local/Mage/Adminhtml/Block/Sales/Order/ Then appendsales_flat_order table to collection protected function _prepareCollection () { $collection = Mage :: getResourceModel ( $this -> _getCollectionClass ()); $collection -> getSelect ()-> join ( 'sales_flat_order' , 'main_table.entity_id = sales_flat_order.entity_id' , array ( 'customer_email' )); $this -> setCollection ( $collection ); return parent :: _prepareCollection (); }; And a addColumn to _prepareColumns() $this -> addColumn ( 'customer_email' , array ( 'header' => Mage :: helper ( 'sales' )-> __ ( 'Payment method' ), 'index' => 'customer_email' , 'filter_index' => 'sales_flat_order.customer_email' , ));
find some magento simple technical solution easly get solution with wide explanation. how we can use the solution code. Here i am posting what i faced issues and found issues solving solution. Magento is most powerful eCommerce frame work. working in magento framwork finding soluiotn and sharing technical knowledge here.