Magento后台订单列表添加Shipping Address（送货地址）

1.#打开
\app\code\core\Mage\Adminhtml\Block\Sales\Order\Grid.php

#找到 protected function _prepareCollection()方法，大约57行

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel($this->_getCollectionClass());

    /*2015年5月6日 关联查询 Shipping Address送货地址*/

 $collection->getSelect()->joinLeft('sales_flat_order_address', 'main_table.entity_id = sales_flat_order_address.parent_id',array('ShippingAddress'=>new Zend_Db_Expr('CONCAT_WS(", ",sales_flat_order_address.street,sales_flat_order_address.city,sales_flat_order_address.region,sales_flat_order_address.postcode,sales_flat_order_address.telephone)')) );

    $collection->getSelect()->where('sales_flat_order_address.address_type="shipping"');//address_type="shipping"

    $this->setCollection($collection);
    return parent::_prepareCollection();

}

2. #找到 protected function _prepareColumns()方法，大约84行   

添加如下代码：

/*Shipping Address*/
$this->addColumn('Shipping Address', array(
    'header' => Mage::helper('Sales')->__('Shipping Address'),
    'index' => 'ShippingAddress',
));