Magento – save order attribute

attributesmagento2sales-order

I created an order attribute using quoteSetupFactory or eavSetupFactory which yields in creation of a row in the eav_attribute table with entity_type_id of 5.

$quoteInstaller = $this->quoteSetupFactory->create(['resourceName' => 'quote_setup', 'setup' => $setup]);
$quoteInstaller->addAttribute(
        'order',
        'me_attrib',
        ['type' => \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER]
    );

when I try to set the value for that attribute using orderResource an sql error complains that the column doesn't exist.

$order->setData("me_attrib","1");
$this->orderResource->saveAttribute($order, ['me_attrib']);

**error**  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'me_attrib' in 'field list', query was: UPDATE `sales_order` SET ` `me_attrib` = ? WHERE (entity_id= 2)

So apparently I have to create a new column on sales_order table in order to store the new attribute.

I was wondering if there is any way to use the eav_attribute instead of creating a new column?

Best Answer

Quotes and orders do not implement EAV storage, so no, you will not be able to use EAV attributes for those models. You have to add your table or column manually, and you should handle the data via ExtensionAttributes.

The only EAV storage data types (out of box) are customer, address, category, and product. If you look at those in the database, you'll notice each one has a primary table (usually named *_entity), followed by several storage tables for different data types: *_entity_text, *_entity_varchar, *_entity_int, etc. No such tables exist for sales_order.

Related Solutions

How to Add Email Address in Sales Orders Admin Grid in Magento 1.9

First of all, you need to get the customer email by performing a join with sales_flat_order table. Your _prepareCollection() function will be:

protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel($this->_getCollectionClass());
        $collection->getSelect()->joinLeft(
           array('ordersTable'=>'sales_flat_order'),
           'ordersTable.entity_id = main_table.entity_id',
           array('ordersTable.customer_email')
         );
        $this->setCollection($collection);
        return parent::_prepareCollection();
    }

In _prepareColumns() you'll need to add:

$this->addColumn('customer_email', array(
            'header' => $this->helper('sales')->__('Email'),
            'index' => 'customer_email',
            'filter_index' => 'ordersTable.customer_email',
        ));

Now, to fix the search issue on order number, you'll need to add 'filter_index' on 'order number' column. The issue is happening because there is duplicate increment_id column. Here is the code:

$this->addColumn('real_order_id', array(
            'header'=> Mage::helper('sales')->__('Order #'),
            'width' => '80px',
            'type'  => 'text',
            'index' => 'increment_id',
            'filter_index'=>'main_table.increment_id'
        ));

Magento 2 – Add Billing and Shipping Company Column on Sales Order Grid

Try this:


class AddColumnsSalesOrderGridCollection
{

    public function aroundGetReport(
        \Magento\Framework\View\Element\UiComponent\DataProvider\CollectionFactory $subject,
        \Closure $proceed,
        $requestName
    ) {
        $collection = $proceed($requestName);

        if ($requestName === "sales_order_grid_data_source") {
            if ($collection instanceof \Magento\Sales\Model\ResourceModel\Order\Grid\Collection) {
                $collection->getSelect()->join(
                    ["soa" => "sales_order_address"], 'main_table.entity_id = soa.parent_id AND soa.address_type = "billing"', array('billing_company' => 'company')
                )
                    ->distinct();

                $collection->getSelect()->join(
                    ["soa2" => "sales_order_address"], 'main_table.entity_id = soa2.parent_id AND soa2.address_type = "shipping"', array('shipping_company' => 'company')
                )
                    ->distinct();
            }
        }

        return $collection;
    }
}

[Update]

Add preference:

app/code/SR/MagentoCommunity/etc/adminhtml/di.xml


<preference for="Magento\Sales\Model\ResourceModel\Order\Grid\Collection" type="SR\MagentoCommunity\Model\Sales\ResourceModel\Order\Grid\Collection"/>

app/code/SR/MagentoCommunity/Model/Sales/ResourceModel/Order/Grid/Collection.php


<?php
namespace SR\MagentoCommunity\Model\Sales\ResourceModel\Order\Grid;

class Collection extends \Magento\Sales\Model\ResourceModel\Order\Grid\Collection
{
    protected function _construct()
    {
        parent::_construct();
        $this->_map['fields']['shipping_company'] = 'soa2.company';
        $this->_map['fields']['billing_company'] = 'soa.company';
    }
}

Best Answer

Related Solutions

How to Add Email Address in Sales Orders Admin Grid in Magento 1.9

Magento 2 – Add Billing and Shipping Company Column on Sales Order Grid

Related Topic