Magento – Sales Order Grid Custom Field value not saved

customgridmagento-2.1magento2sales-order

I have create a custom field(zipcode) in sales_order and sales_order_grid, after that i try to save to database while click placeorder the order in frontend,so try to use checkout_submit_all_after event, But its not save my custom field value.

what i did:

vendor/module/etc/frontend/events.xml

  <?xml version="1.0"?>
  <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
      <event name="checkout_submit_all_after">
          <observer name="custom_checkout_submit_all_after"
                    instance="vendor\Module\Observer\SalesOrderPlaceAfter"
                    />
      </event>
  </config>

Then create a Observer to to save Custom Field Value.

vendor/module/Observer/SalesOrderPlaceAfter.php:

    use Magento\Framework\Event\ObserverInterface;

    class SalesOrderPlaceAfter implements ObserverInterface
    {

        public function execute(\Magento\Framework\Event\Observer $observer)
        {
            try {
                $order = $observer->getEvent()->getOrder();
                $order->setZipcode("604503");
                $order->save();
            } catch (\Exception $e) {
                error_log($e->getMessage());
            }
        }
    }

But its have save My custom Field value, Suggest me How to fix this.

Best Answer

If we want to set the custom attribute data to order, it's better if we use before saving observer. For example: sales_model_service_quote_submit_before.

    $order = $observer->getOrder();
    $order->setZipcode($feeAmount);

Order table and order grid are in sync:

app/code/Vendor/Module/etc/adminhtml/di.xml

   <virtualType name="Magento\Sales\Model\ResourceModel\Order\Grid">
        <arguments>
            <argument name="columns" xsi:type="array">
                <item name="your_column" xsi:type="string">
                     sales_order.your_column
                </item>
            </argument>
        </arguments>
    </virtualType>

Related Solutions

Magento 2 – How to Rewrite TierPrice Block

Suppose package:Learning and module: Custom

Module.xml looks like

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../lib/internal/Magento/Framework/Module/etc/module.xsd">
    <module name="Learning_Custom" setup_version="2.0.0">
        <sequence>
            <module name="Magento_Catalog"/>
        </sequence>
    </module>
</config>

And then create a layout xml following path -> app/code/Learning/Custom/view/frontend/layout/catalog_product_prices.xml

<layout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../../lib/internal/Magento/Framework/View/Layout/etc/layout_generic.xsd">
    <referenceBlock name="render.product.prices">
        <arguments>
            <argument name="default" xsi:type="array">
                <item name="prices" xsi:type="array">
                    <item name="tier_price" xsi:type="array">
                        <item name="render_template" xsi:type="string">Learning_Custom::product/price/tier_prices.phtml
                    </item>
                </item>
            </argument>
        </arguments>
    </referenceBlock>
</layout>

Create template inside your module or copy base template file inside your module path should be -> app/code/Learning/Custom/view/frontend/templates/product/price/tier_prices.phtml

Magento2 Module – Fix ‘main.CRITICAL: Plugin Class Doesn’t Exist’

I couldn't reproduce your error, but I got an other one.

Then I did some minor adjustments to your code and it worked.
First drop the InstallSchema.php file. It does nothing so it is useless.

Then make sure that your plugin file is in Amaj/CorePlugin/Model/Currency/Plugin.php and it looks like this:

<?php

namespace Amaj\CorePlugin\Model\Currency;

class Plugin
{
    protected $logger;

    public function __construct(\Psr\Log\LoggerInterface $logger) {
        $this->logger = $logger;
    }

    /**
     * @param $subject
     * @param \Closure $proceed
     * @param $price
     * @param array $options
     * @return string
     */
    public function aroundFormatTxt(
        $subject,
        \Closure $proceed,
        $price,
        $options = []
    )
    {
        $this->logger->info('Amaj aroundFormatTxt');
        return '2';
    }

}

you don't need parent::__construct(); in the constructor because there is no parent class.
And I replaced $logger->info with $this->logger->info because there is no $logger variable.

Best Answer

Related Solutions

Magento 2 – How to Rewrite TierPrice Block

Magento2 Module – Fix ‘main.CRITICAL: Plugin Class Doesn’t Exist’

Related Topic