后台订单添加weight等栏目

后台订单添加weight等栏目

core/mage/adminhtml/Block/Sales/Order/Gird.php

订单表主要是取sales_flat_order_grid表里的数据
要取别的数据就要连表

原来的
protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel($this->_getCollectionClass());
        $this->setCollection($collection);
        return parent::_prepareCollection();
    }

改成（我这里取的是重量 也可以连表取别的数据）
protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel($this->_getCollectionClass());
        $collection->getSelect()->joinLeft('sales_flat_order','main_table.entity_id = sales_flat_order.entity_id','weight'); 
        $collection->getSelect()->group('main_table.entity_id');  
        $this->setCollection($collection);
        return parent::_prepareCollection();
    }

然后在protected function _prepareColumns()里添加
 $this->addColumn('weight', array(
            'header' => Mage::helper('sales')->__('weight'),
            'index' => 'weight',
            'type'  => 'text',
            'width' => '70px',
            'currency' => 'order_currency_code',
        ));

重写比较好(重写分页有效)

一个类似的插件  按自己要求改就好了。

key：http://connect20.magentocommerce.com/community/Vp_Ordersku

地址： https://www.magentocommerce.com/magento-connect/order-grid-sku.html  https://www.magentocommerce.com/magento-connect/order-grid-sku.html  https://www.magentocommerce.com/magento-connect/order-grid-sku.html  https://www.magentocommerce.com/magento-connect/order-grid-sku.html