Magento – Column “Payment method” or. “Payment Method” in the bills overview in the backend / Orders Overview Add column

By default, the overview of the invoices in the backend is the column “Payment method” not included. They can now but manually add.

A general notice, how to add columns of information in the Admin Grids, This already exists HERE.

Here it is only briefly to a column go a overview in this. For this purpose we take the file app / code / core / Mage / Admin Html / block / Sales / Invoice / Grid.php and copy it to app / code / local / Mage / Admin Html / block / Sales / Invoice / Grid.php

Then we open it up and do the following:

1. The following lines by

$collection = Mage::getResourceModel($this->_getCollectionClass());

(as. Line 57) insert:

        $collection->getSelect()
            ->joinLeft('sales_flat_order_payment', 'main_table.order_id = sales_flat_order_payment.entity_id','method');

2. insert the new column to the desired location between the other columns. We did this by

        $this->addColumn('order_created_at', array(
            'header'    => Magus::helper('sales')->__('Order Date'),
            'index'     => 'order_created_at',
            'type'      => 'datetime',
        ));

done. To this end, then only the code is inserted:

        $this->addColumn('method', array(
            'header' => Magus::helper('sales')->__('Payment method'),
            'index' => 'method',
            'type'   => 'text',
        ));

And already the new column appears to the payment methods in the Invoice Overview.

you want in the Admin Product Overview also a column Add (in our case, we want the column here “Payment method” show), then the procedure is very similar to the above. It uses the Gripd.php from the directory app / code / core / Mage / Admin Html / block / Sales / Order and copies it to the directory app / code / local / Mage / Admin Html / block / Sales / Order.

Unlike change #1 but the following code is inserted

        $collection->join(array('payment'=>'sales/order_payment'),'main_table.entity_id=parent_id','method');
            $this->setCollection($collection);

All else being equal.

Used in Magento Version 1.9 Comments? Additions? Notes? Gladly!