Show Payment Method in Order Grid in Magento (Enhance Order Grid in admin side)


Copy Grid.php "app\code\core\Mage\Adminhtml\Block\Sales\Order\Grid.php"
and paste on below path.
"app\code\local\Mage\Adminhtml\Block\Sales\Order".

Find this code "$collection = Mage::getResourceModel($this->_getCollectionClass());".


Put below line after find text.
$collection->join(array('payment'=>'sales/order_payment'),'main_table.entity_id=parent_id','method');


After that put below code where you want to show Payment Method. After which column in grid you want to show.


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

));


Comments

  1. Jeeva RathinamJanuary 19, 2017 at 1:49 AM

    supposed am not copy and paste, changes made same file app\code\core\Mage\Adminhtml\Block\Sales\Order\Grid.php, may i know the error. am faced no error.

    ReplyDelete
  2. Jeeva RathinamJanuary 19, 2017 at 2:17 AM

    how can i display country name like payment option

    ReplyDelete
  3. UnknownDecember 6, 2018 at 8:50 PM

    Its really helpfull. Clean code

    ReplyDelete
  4. Aanchal KauraFebruary 25, 2019 at 10:27 PM

    I was looking for this query ie "Show Payment Method in Order Grid in Magento" since two weeks and finally got it here. I'm working in Magento agency and always be ready to learn new things and solve my queries in the blogs as like yours. Thanks for this technical post.

    ReplyDelete

Post a Comment

Popular posts from this blog

Adding Contact us link to Top Menu in Magento

Image
Create New Category " Contcat Us ". Set " Display Mode "=" static block only " from " Display Settings " Tab. Set below code in " Custom Layout Update " from " Custom Design " Tab. <reference name="content">             <block type="core/template" name="contactForm" template="contacts/form.phtml"/> </reference> Save it.... Enjoy...
Read more

Credit card number for Testing payment methods

American Express: 378282246310005 3111111111111117 343434343434343 370000000000002 340000000000009 371449635398431 378734493671000 Visa: 4111111111111111 4007000000027 4222222222222 4012888888881881 MasterCard: 5105105105105100 5111111111111118 5454545454545454 5500000000000004 5555555555551111 5555555555554444 Discover: 6011111111111117 6011000000000004 6011000990139424 6011601160116611 6111111111111116 for expiry date select any feature month and year.... 
Read more

Magento create invoice of specific order by programmatically

<?php require_once('app/Mage.php'); Mage::app(); $orderId = '10508'; /////$order->getId(); $fullOrder = Mage::getModel('sales/order')->load($orderId); $fullOrder->setState(Mage_Sales_Model_Order::STATE_PROCESSING, true); $fullOrder->setStatus('processing', false); $fullOrder->save(); try { if(!$fullOrder->canInvoice()) { Mage::throwException(Mage::helper('core')->__('Cannot create an invoice.')); } $invoice = Mage::getModel('sales/service_order', $fullOrder)->prepareInvoice(); if (!$invoice->getTotalQty()) { Mage::throwException(Mage::helper('core')->__('Cannot create an invoice without products.')); } $invoice->setRequestedCaptureCase(Mage_Sales_Model_Order_Invoice::CAPTURE_OFFLINE); $invoice->register(); $transactionSave = Mage::getModel('core/resource_transaction')->addObject($invoice)->addObject($invoice->ge...
Read more