How to add extra fields in products ordered report

Question

We want to show extra fields in products ordered report. Extra fields are sku, cost_price(new attribute) and sold price(price)

I have found following class which handle this.

Mage_Adminhtml_Block_Report_Product_Sold_Grid

And also I found following controller class which handle this.

Mage_Adminhtml_Report_ProductController

I was failed to full fill this requirement. Can anyone help me on this? Thanks.

Chandresh Rana · Accepted Answer · 2016-08-17 05:23:25Z

Open app\code\core\Mage\Adminhtml\Block\Report\Product\Sold\Grid.php and put the below code in _prepareColumns() function

You can move Grid.php in your local folder as well.

$this->addColumn('sku', array(
    'header'    => Mage::helper('reports')->__('Product Sku'),
    'index'     =>'sku'
));

Neeraj Garg · Accepted Answer · 2013-12-19 06:26:46Z

You need to add a field in sales_flat_order table and just use following code:-

for save data:

$orders = Mage::getModel('sales/order')->load($orderId);
$orders->setYourField($data);

for display

$orders = Mage::getModel('sales/order')->load($orderId);
$orders ->getYourField();

2 Answers 2