Magento 2 – How to Get All Orders of Customer by Email ID

magento2magento2.2magento2.3order-emailsales-order

How can I get all orders of a customer via his/her email id who is logged in,
I am using current session to get user's email id

public function getCustomerData() {
    if ($this->_customerSession->isLoggedIn()) {
        return $this->_customerSession->getCustomerData();
    }
    return false;
}

In phtml

  $customerData = $block->getCustomerData();
  if($customerData) {
    echo 'Customer Email: ' . $customerData->getEmail() . '<br/>'; }

Earlier I was getting my orders information by order id

public function getOrderInformation($orderid)
{
    $objectManager = \Magento\Framework\App\ObjectManager::getInstance();
    $order = $objectManager->create('Magento\Sales\Api\OrderRepositoryInterface')->get($orderid);
    return $order;
}

How can I get all orders by customer email id

Best Answer

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();

//*****************loading Customer session *****************//
$customerSession = $objectManager->create('Magento\Customer\Model\Session');

//******** Checking whether customer is logged in or not ********//
if ($customerSession->isLoggedIn()) {
$customer_email = $customerSession->getCustomer()->getEmail();

// ***********Getting order collection using customer email id ***********//
 $order_collection = $objectManager->create('Magento\Sales\Model\Order')->getCollection()->addAttributeToFilter('customer_email', $customer_email);

 //echo "<pre>";print_r($order_collection->getData());
 foreach ($order_collection as $order){ 
    echo "Order Id: ".$order->getEntityId(); 
    echo "Customer Id: ".$order->getCustomerId(); 
   } 
}

Order collection based on logged in Customer Email Id (Customer All orders)

I hope this will help

Related Solutions

Magento – Convert quote to order generating empty order

One general remark here: You're trying to set the full customer session object (Mage::getSingleton('customer/session')) as the quote's customer. You should do Mage::getSingleton('customer/session')->getCustomer().

As for the whole process, I have been doing this in the past as follows:

$quote = Mage::getSingleton('checkout/session')->getQuote();
$quote->assignCustomer(Mage::getSingleton('customer/session')->getCustomer());

$quote->collectTotals()
    ->getPayment()->setMethod('purchaseorder');

$convert = Mage::getModel('sales/convert_quote');
$order = $convert->toOrder($quote)
    ->setBillingAddress(
        $convert->addressToOrderAddress($quote->getBillingAddress())
    )
    ->setShippingAddress(
        $convert->addressToOrderAddress($quote->getShippingAddress())
    )
    ->setPayment(
        $convert->paymentToOrderPayment($quote->getPayment())
    );

foreach ($quote->getAllItems() as $quoteItem) {
    $orderItem = $convert->itemToOrderItem($quoteItem);
    if ($quoteItem->getParentItem()) {
        $orderItem->setParentItem(
            $order->getItemByQuoteItemId($quoteItem->getParentItem()->getId())
        );
    }
    $order->addItem($orderItem);
}

$order->save();

I'm manually setting the payment method on the quote to 'purchaseorder'. You should see if this works for you too and/or fits your needs.

Sales Order – Filter Orders by Customer Email ID

Use addAttributeToFilter instead of addFieldToFilter as in some case Sales model follow eav patten filter and select.

$customer_email ='abc@gmail.com';
$orders = Mage::getModel('sales/order')->getCollection()
    ->addAttributeToFilter('customer_email', $customer_email);

Best Answer

Related Solutions

Magento – Convert quote to order generating empty order

Sales Order – Filter Orders by Customer Email ID

Related Topic