Magento2 Sales Order Grid – Unable to Save Data in Newly Added Column of Sales_Order_Grid Table

magento-2.0magento2sales-order

trying to save the my oven data in newly added column of sales_order_grid but unable to to do so.

However, I can save my custom the data in sales_order table where I have added one extra column.
I am adding the data in sales_order table by getting below observer event.

$obj = $observer->getEvent()->getOrder();
$obj->setMyName($value);

same data is not saving in sales_order_grid table having same column name..

is there there anyway or anything alternative to achieve this???

Best Answer

Suppose column name 'delivery_date, So that you need to add di.xml for save some value for custom column to grid

Vendor/Module/etc/di.xml


<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <virtualType name="Magento\Sales\Model\ResourceModel\Order\Grid" type="Magento\Sales\Model\ResourceModel\Grid">
        <arguments>
            <argument name="columns" xsi:type="array">
                <item name="delivery_date" xsi:type="string">sales_order.delivery_date</item>
            </argument>
        </arguments>
    </virtualType>
</config>

Here is an example

Related Solutions

Magento 2 – Add Custom Catalog Product Link Type to Database

After Some R&D I came To This Solution.

Creating Preference For Magento\Catalog\Controller\Adminhtml\Product\Initialization\Helper

<preference for="Magento\Catalog\Controller\Adminhtml\Product\Initialization\Helper" type="Your\Module\Controller\Adminhtml\Product\Initialization\Helper"/>

OverRide setProductLinks() Of That Class Like This,

    protected function setProductLinks(\Magento\Catalog\Model\Product $product)
    {
        $links = $this->getLinkResolver()->getLinks();

        $product->setProductLinks([]);

        $product = $this->productLinks->initializeLinks($product, $links);
        $productLinks = $product->getProductLinks();
        $linkTypes = [
            'related' => $product->getRelatedReadonly(),
            'upsell' => $product->getUpsellReadonly(),
            'crosssell' => $product->getCrosssellReadonly(),
            'yourtype' => $product->getYourTypeReadonly()
        ];

        foreach ($linkTypes as $linkType => $readonly) {
            if (isset($links[$linkType]) && !$readonly) {
                foreach ((array) $links[$linkType] as $linkData) {
                    if (empty($linkData['id'])) {
                        continue;
                    }

                    $linkProduct = $this->getProductRepository()->getById($linkData['id']);
                    $link = $this->getProductLinkFactory()->create();
                    $link->setSku($product->getSku())
                        ->setLinkedProductSku($linkProduct->getSku())
                        ->setLinkType($linkType)
                        ->setPosition(isset($linkData['position']) ? (int)$linkData['position'] : 0);
                    $productLinks[] = $link;
                }
            }
        }

        return $product->setProductLinks($productLinks);
    }

After That Data Will Be saved In catalog_product_link And Other Related Tables.

Magento 2 – Admin Sales Grid Filter Column from Sales Order Table

You need to join your new field rescue_order_name to order grid collection first.

First override Magento\Sales\Model\ResourceModel\Order\Grid\Collection and add below function to join.

protected function _initSelect()
    {
        parent::_initSelect();

        $this->getSelect()->joinLeft(
            ['so' => $this->getTable('sales_order')],
            'main_table.entity_id = so.entity_id',
            ['rescue_order_name']
        );

        return $this;
    }

And you can remove class="\Rescuechimp\OrderManager\Ui\Component\Listing\Column\Ordername" from sales grid xml for your rescue_order_name column.

I hope this might help you it works fine to me.

Let me know if you need any more help.

Best Answer

Related Solutions

Magento 2 – Add Custom Catalog Product Link Type to Database

Magento 2 – Admin Sales Grid Filter Column from Sales Order Table

Related Topic