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

关注

原创最新推荐文章于 2026-09-06 13:57:20 发布 1.6k 阅读 AI 写同款· GEO 优化 ›

别只聊天了！手把手教你为Ollama+Open WebUI搭建本地知识库（基于BGE-M3和Qwen）本文详细介绍了如何利用Ollama、Open WebUI和BGE-M3构建本地知识库，实现智能问答和文档检索。通过环境准备、文档处理、向量化实战和应用案例，帮助用户突破基础聊天场景，打造高效的个人知识管理体系。特别适合技术文档管理和学术研究场景。阅读详情

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',
));

收录于