Magento2

Magento2 Order Search by Phone

By 2 Mins Read

When we work in magento with out of box customization then we might need to add feature for search order by phone in admin grid or somewhere else.

In this blog we are going to search order by phone number/telephone/mobile number in magento2.

As technially, we need to search phone in order’s address table and need to get order ids and use that order ids to get order information.

Here is code for search order by phone

PHP
<?php
declare(strict_types=1); //We recommend to use always strict_types = 1 for quality code

namespace MageDad\Module\Model;

use Magento\Sales\Model\ResourceModel\Order\CollectionFactory as OrderCollectionFactory;
use Magento\Sales\Model\ResourceModel\Order\Address\CollectionFactory as AddressCollectionFactory;

class OrderSearch
{
  public function __construct(
    private OrderCollectionFactory $orderCollectionFactory,
    private AddressCollectionFactory $addressCollectionFactory
  ) { }

  /**
   * {@inheritdoc}
   */
  public function getOrderByPhone($phone)
  {
    $addressCollection = $this->addressCollectionFactory->create();
    $addressCollection->addFieldToFilter('telephone', ['eq' => $phone]);
    $orderIds = $addressCollection->getColumnValues('parent_id');
    
    if (count($orderIds) > 0) {
        $collection = $this->orderCollectionFactory->create();
        $collection->addFieldToFilter('entity_id', ['in' => $orderIds]);
        return $collection->getItems();
    }
    
    return [];
  }
}

If you want to create API for search order by phone then you can refere GitHub module.

I hope this blog is useful to search order by phone in magento2. In case, I missed anything or need to add some more information, Don’t heisted to leave a comment in this blog, I’ll get back with some positive approach.

Keep loving ❤️ Keep inspiring 🤩 Keep liking 👍 No sharing 😂

Post Views: 203

Related Posts

7 Comments

  1. CBD Kaufen

    Hello! Do you know if they make any plugins to help with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good success. If you know of any please share. Thank you!

  2. Trade Databases

    businessiraq.com: Your Ultimate Iraqi Business Gateway. Embark on a journey of discovery and opportunity with our meticulously crafted Iraq business directory, home to comprehensive online business listings that paint a vivid picture of the nation’s diverse economic tapestry. Stay informed and make strategic decisions with our up-to-date Iraq business news, while our Iraq jobs portal connects you with exciting career prospects. And for businesses ready to make their mark, our tender opportunities directory presents a world of procurement possibilities. Connect, explore, and succeed in Iraq with Businessiraq.com.

  5. binance

    I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

  7. Cristina Heidenreich

    A code promo 1xBet est un moyen populaire pour les parieurs d’obtenir des bonus exclusifs sur la plateforme de paris en ligne 1xBet. Ces codes promotionnels offrent divers avantages tels que des bonus de dépôt, des paris gratuits, et des réductions spéciales pour les nouveaux joueurs ainsi que les utilisateurs réguliers.code 1xbet télécharger

Write A Comment