Skip to main content

update order customer if mismatch after migration like any issue

Using csv we can update customer ids

use this code in controller

 if (($handle = fopen("/chroot/home/*****/*********/html/app/code/Test/Testmodule/Controller/Index/uniqueorder.csv", "r")) !== FALSE) {
            while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) {
                $email = $data[2];
//                 echo $url;die("data");
                $objectManager = \Magento\Framework\App\ObjectManager::getInstance();

                $orderCollection = $objectManager->create('\Magento\Sales\Model\ResourceModel\Order\CollectionFactory');
                $collection = $orderCollection->create()
                        ->addAttributeToSelect('*')
                        ->load();
                foreach ($collection as $order) {
                    if ($order->getCustomerId() != NULL && $order->getCustomerEmail() == $email) {
                        $customerData = $objectManager->create('Magento\Customer\Model\Customer')->loadByEmail($email);
                        $customerId = $customerData->getId();
                        $order->setCustomerId($customerId);
                        $order->save();
                        echo '<pre>';
                        print_r($customerData->getId() . "--------" . $order->getCustomerId() . "------" . $customerData->getEmail() . '-----------' . $order->getCustomerEmail()."----------". $order->getIncrementId());
                     
                    } else {
//                        $customerData = $objectManager->create('Magento\Customer\Model\Customer')->loadByEmail($email);
//                        $customerId = $currentproduct->getId();
//
//
//                        echo '<pre>';
//                print_r($customerData->getId() . "--------" . $order->getCustomerId() . "------" . $customerData->getEmail().'-----------'.$order->getCustomerEmail());
//                        die("data");
//                        echo $order->getIncrementId() . "----------------" . $order->getCustomerEmail() . "<br/>";
                    }
                }
            }
        }

Comments

Popular posts from this blog

Magento 2 product collection Filtering multi-select attribute values

  If you have multi-select attribute of product like below If you want filter value for this option Use below syntax to get product data: ->addAttributeToFilter('store_model', array('finset' => $params['store_model'])) finset key is used for multiselect attribute filter. $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $products = $objectManager->get('Magento\Catalog\Model\Product')         ->getCollection()         ->addAttributeToSelect('*')         ->addAttributeToSelect('store_brand')         ->addAttributeToSelect('store_model')         ->addAttributeToSelect('store_year')         ->addAttributeToFilter('store_brand', array('finset' => $params['store_brand']))         ->addAttributeToFilter('store_model', array('finset' => $params['store_model']))         ->ad...

magento 2 best seller product display based on current category and subcategories

Magento 2 getting best seller based on category wise displaying i have done below for that to implement this functionality it is working fine for me. step 1 create block file in our module folder <?php namespace Pawan\Bestseller\Block; use Magento\Catalog\Api\CategoryRepositoryInterface; class Bestsellercategory extends \Magento\Catalog\Block\Product\ListProduct {     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_collection;     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_productCollection;     /**      * Image helper      *      * @var Magento\Catalog\Helper\Image     ...

order cancel from front end

if you want cancel order from front end create module like this app/etc/modules/<Namespace_Modulename>.xml <config>     <modules>         <Namespace_CustomerOrderCancel>             <active>true</active>             <codePool>community</codePool>             <depends>                 <Mage_Sales />             </depends>         </ Namespace _CustomerOrderCancel>     </modules> </config> app/community/Namespace/Modulename           ------controllers           -------etc           -------Helper if you want cancel button in history page (myorder) need override block file Mage_Sales_Block_Orde...