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: 2,517

Related Posts

1,271 Comments

  3. 789betpp com

    Howdy! Would you mind if I share your blog with my facebook group? There’s a lot of folks that I think would really enjoy your content. Please let me know. Thanks

  38. hydrolean xt official website

    It’s appropriate time to make some plans for the future and it’s time to be happy. I have read this post and if I could I desire to suggest you some interesting things or tips. Maybe you could write next articles referring to this article. I wish to read even more things about it!

  43. https://xx88.asia/

    you are in reality a excellent webmaster. The web site loading pace is amazing. It sort of feels that you’re doing any distinctive trick. Also, The contents are masterwork. you have done a fantastic job in this matter!

  44. Vanessa

    Hi, Neat post. There is a problem together with your site in web
    explorer, may check this? IE still is gambling casinos on the east coast (Vanessa) marketplace leader and a good element of
    other folks will omit your wonderful writing
    because of this problem.

  46. https://xx88.asia/

    I used to be suggested this website via my cousin. I’m now not sure whether or not this post is written by way of him as nobody else recognize such designated approximately my trouble. You are incredible! Thank you!

  55. bokep indo colmek

    Cool blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog jump out. Please let me know where you got your theme. Bless you

  58. max79

    You made some first rate points there. I seemed on the internet for the issue and found most individuals will go along with together with your website.

  64. flumberico music

    Thanks for the ideas you are giving on this blog. Another thing I’d prefer to say is getting hold of copies of your credit file in order to scrutinize accuracy of any detail is one first step you have to perform in repairing credit. You are looking to clear your credit file from destructive details faults that screw up your credit score.

  88. Jeana

    Nice blog here! Also your web site loads up fast!
    What host are you using? Can I get your affiliate link to your host?
    I wish my site loaded up as fast as yours lol

    my site: casas de apuestas deportivas peru – Jeana,

  90. akongcuan

    Excellent post. I was checking continuously this blog and I’m impressed! Extremely useful info specifically the last part 🙂 I care for such information a lot. I was seeking this certain information for a long time. Thank you and best of luck.

  91. the brain song review

    Great awesome things here. I am very glad to see your article. Thank you a lot and i’m taking a look ahead to touch you. Will you please drop me a mail?

  98. Binance推荐

    Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?

  104. bonus-casino-961

    Цікавлять бонуси? бонуси казино: актуальні акції, подарунки за реєстрацію, депозитні та VIP-бонуси. Чесно розбираємо правила, допомагаємо зрозуміти вигоду та уникнути типових помилок під час гри.

  105. casino-online-907

    Хочеш зазнати успіху? онлайн казіно: свіжі огляди, рейтинг майданчиків, вітальні бонуси та фрізпіни, особливості слотів та лайв-ігор. Докладно розбираємо правила та нагадуємо, що грати варто лише на вільні кошти.

  108. filmproductioncortina-268

    ORBS Production https://filmproductioncortina.com is a full-service film, photo and video production company in Cortina d’Ampezzo and the Dolomites. We create commercials, branded content, sports and winter campaigns with local crew, alpine logistics, aerial/FPV filming and end-to-end production support across the Alps. Learn more at filmproductioncortina.com

  109. federatsia-433

    Хочешь развлечься? купить мефедрон федерация – это проводник в мир покупки запрещенных товаров, можно купить гашиш, купить мефедрон, купить кокаин, купить меф, купить экстази, купить альфа пвп, купить гаш в различных городах. Москва, Санкт-Петербург, Краснодар, Владивосток, Красноярск, Норильск, Екатеринбург, Мск, СПБ, Хабаровск, Новосибирск, Казань и еще 100+ городов.

  120. insurance agency

    I?ve read a few good stuff here. Definitely worth bookmarking for revisiting. I wonder how much effort you put to create such a fantastic informative web site.

  124. insurance agency Rochester Hills

    Just want to say your article is as astounding. The clearness in your post is just great and i can assume you are an expert on this subject. Fine with your permission let me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please carry on the rewarding work.

  126. perdita acqua impianto irriguo

    Fantastic blog you have here but I was curious about if you knew of any message boards that cover the same topics discussed in this article? I’d really like to be a part of group where I can get comments from other knowledgeable people that share the same interest. If you have any recommendations, please let me know. Kudos!

  127. kraken

    Официальный kraken onion адрес версии v3 содержит 56 символов для максимальной криптографической защиты соединения внутри распределенной Tor сети анонимизации.

  131. TK88

    I discovered more a new challenge on this fat reduction issue. A single issue is that good nutrition is tremendously vital when dieting. A big reduction in junk food, sugary food, fried foods, sweet foods, beef, and bright flour products may be necessary. Holding wastes unwanted organisms, and harmful toxins may prevent targets for fat loss. While certain drugs temporarily solve the problem, the nasty side effects will not be worth it, and they also never present more than a temporary solution. This can be a known fact that 95 of diet plans fail. Many thanks sharing your thinking on this web site.

  136. emerald-chat-195

    Free video chat emerald chat premium find people from all over the world in seconds. Anonymous, no registration or SMS required. A convenient alternative to Omegle: minimal settings, maximum live communication right in your browser, at home or on the go, without unnecessary ads.

  137. situs toto

    Hi my friend! I want to say that this article is amazing, great written and come with almost all important infos. I would like to peer more posts like this.

  143. insurance agency Mangum

    I?d must test with you here. Which is not one thing I usually do! I enjoy reading a submit that may make folks think. Also, thanks for permitting me to remark!

  144. Royaltoto

    The site is easy to use and the stable performance keeps me coming back. Charts are accurate and load instantly.

  146. kraken 379

    Правильная подготовка обеспечивает доступ к кракен через установку Tor браузера с официального сайта torproject и проверку всех загруженных файлов через PGP подписи.

  148. nv-casino-64

    Uwielbiasz hazard? nv casino opinie: rzetelne oceny kasyn, weryfikacja licencji oraz wybor bonusow i promocji dla nowych i powracajacych graczy. Szczegolowe recenzje, porownanie warunkow i rekomendacje dotyczace odpowiedzialnej gry.

  152. hair transplant istanbul price

    Hello! I know this is kinda off topic but I was wondering which blog platform are you using for this site? I’m getting fed up of WordPress because I’ve had issues with hackers and I’m looking at options for another platform. I would be awesome if you could point me in the direction of a good platform.

  153. Royaltoto

    I personally find that this platform exceeded my expectations with reliable uptime and intuitive UI.

  156. Goltogel

    This platform exceeded my expectations with easy onboarding and responsive team. The updates are frequent and clear.

  158. dewapoker

    The interface is useful analytics, and I enjoy checking analytics here. The dashboard gives a complete view of my holdings.

  161. Donaldabugh

    Известный дилер перейти на сайт предоставляет доступ приобрести лучшие учетки для рекламы. Ключевое преимущество данной площадки — заключается в наличии огромной вики-энциклопедии, в которой написаны секретные статьи по SMM. Мы поможем, как правильно фармить аккаунты, где обходить баны и настраивать прокси. Заказывая у нас, вы получаете не просто куки, но и полную поддержку, гарантию на вход и самые адекватные прайсы на рынке.

  167. Donaldabugh

    Best dealer marketplace accounts is happy to present direct access to order premium credentials suitable for promotion. What sets us apart of our shop is our exclusive learning center, containing secret tutorials regarding lead generation. Inside the materials, our team shares tips on using proxies to boost efficiency in your daily work. The shop offers pages of Facebook, Instagram, TikTok for all needs: ranging from autoregs up to farmed business managers with activity.

  168. Ethical hacking techniques

    magnificent put up, very informative. I’m wondering why the other specialists of this sector do not understand this. You must proceed your writing. I’m sure, you’ve a great readers’ base already!

  170. 1xbet-burkina-862

    La plateforme 1xbet apk burkina: paris sportifs en ligne, matchs de football, evenements en direct et statistiques. Description du service, marches disponibles, cotes et principales fonctionnalites du site.

  171. 1xbet-congo-6

    Site web 1xbet congo – paris sportifs en ligne sur le football et autres sports. Propose des paris en direct et a l’avance, des cotes, des resultats et des tournois. Description detaillee du service, des fonctionnalites du compte et de son utilisation au Congo.

  172. parifoot-900

    Site web de pari foot rdc: paris sportifs, championnats de football, resultats des matchs et cotes. Informations detaillees sur la plateforme, les conditions d’utilisation, les fonctionnalites et les evenements sportifs disponibles.

  174. 1xbet-apk-15

    Application mobile telecharger 1xbet apk. Paris sportifs en ligne, football et tournois populaires, evenements en direct et statistiques. Presentation de l’application et de ses principales fonctionnalites.

  176. gamevip68

    Gamevip68, It’s alright and it’s got some good points but I wouldn’t go shouting from the rooftops about it. Worth a look I thought. Give it a go if you are bored for sure. To the website: gamevip68

  179. https://headquarterscomplaints.com

    One thing is that if you find yourself searching for a student loan you may find that you will need a co-signer. There are many circumstances where this is true because you could find that you do not possess a past credit standing so the loan provider will require that you’ve someone cosign the borrowed funds for you. Good post.

  181. bandar slot gacor

    It is in point of fact a great and helpful piece of info. I am satisfied that you simply shared this useful information with us. Please keep us informed like this. Thank you for sharing.

  185. app 888slot

    Việc của bet thủ là chỉ cần đặt cược con số may mắn mà mình dự đoán sẽ trúng với số tiền cược hợp lý. Hệ thống tiến hành quay thưởng và cập nhật ngay sau đó, tỷ lệ thưởng app 888slot có thể lên tới 1 ăn 99. TONY12-23

  186. app 888slot

    Việc của bet thủ là chỉ cần đặt cược con số may mắn mà mình dự đoán sẽ trúng với số tiền cược hợp lý. Hệ thống tiến hành quay thưởng và cập nhật ngay sau đó, tỷ lệ thưởng app 888slot có thể lên tới 1 ăn 99. TONY12-23

  195. cbd oil side effects

    Everyone loves what you guys tend to be up too. This type of clever work and exposure! Keep up the fantastic works guys I’ve incorporated you guys to my personal blogroll.

  196. bokep indo colmek

    A lot of what you say happens to be supprisingly legitimate and it makes me wonder why I hadn’t looked at this with this light before. This article truly did turn the light on for me personally as far as this particular subject goes. But there is one particular point I am not necessarily too cozy with so whilst I attempt to reconcile that with the central idea of your position, let me see exactly what all the rest of the subscribers have to say.Nicely done.

  201. bokep indonesia

    One more thing is that when evaluating a good on the net electronics retail outlet, look for web shops that are continually updated, trying to keep up-to-date with the most current products, the most effective deals, as well as helpful information on goods and services. This will make certain you are doing business with a shop that really stays atop the competition and provide you what you should need to make knowledgeable, well-informed electronics purchases. Thanks for the crucial tips I’ve learned through the blog.

  498. hellogpt下载

    hellogpt下载 服务下载安装，确保软件来源正规可靠。对于偏好桌面端操作的用户，推荐使用 hellogpt电脑版，该版本在性能与稳定性方面进行了专门优化，适合长时间运行。完成 hellogpt电脑版下载 后，即可在电脑上流畅使用智能对话、文本生成及 hellogpt翻译
    功能。作为一款实用的 hellogpt翻译软件，它能够帮助用户高效处理多语言内容，提升学习与工作效率。整个安装与使用过程清晰明了，即使是新手用户也能快速上手。

  596. hellogpt官网

    HelloGPT 电脑版广泛适用于办公、学习和日常内容处理等多种场景，是桌面端用户的实用智能助手。通过 hellogpt官网，用户可以了解 hellogpt电脑版 在不同使用场景下的功能展示和实际应用方式。在语言学习和资料阅读方面，hellogpt翻译 能够快速帮助用户理解外文内容，提高阅读效率，作为专业的 hellogpt翻译软件，其翻译结果更贴近真实语境。在办公场景中，hellogpt电脑版 提供稳定、流畅的操作体验，支持长时间运行和多任务处理。用户只需通过官网完成 hellogpt电脑版下载，即可在本地高效使用全部功能。官方提供的
    hellogpt下载 渠道保障软件安全与数据隐私，让用户使用更加安心。

  691. w88trangchu

    Been using w88trangchu for a while now, and overall, I’m pretty happy with it. Nice selection of games, decent payouts. Check w88trangchu, pretty sure you won’t regret it.

  715. hellogpt

    hellogpt下载 渠道获取软件安装包，确保版本正规、安全可靠。针对偏好桌面端操作的用户，hellogpt电脑版 提供了更适合电脑使用的界面与性能优化。完成 hellogpt电脑版下载 后，即可在本地快速启动，流畅使用智能对话、文本辅助及 hellogpt翻译 功能。作为一款实用性较高的
    hellogpt翻译软件，它能够帮助用户高效处理多语言内容，提升学习和工作效率。整体安装与使用流程清晰，即使是初次接触的用户也能快速掌握。

  777. axiebet88app

    Axiebet88app… Been using this one for a while now. Pretty reliable platform, decent odds. App’s easy to use too. Worth a download, IMO. Give it a try! Download the app at: axiebet88app

  778. x777ff

    X777FF, they’ve got some interesting promos going on. Bonus system isn’t bad at all! Plus, they seem to be adding new games pretty regularly. Worth keeping an eye on. Just sayin’. x777ff

  779. jilibet020

    Jilibet020 – not a bad option if you ask me! Found some good games and they pay out pretty reliably. Just keep an eye on the fine print on the bonuses like with any site. jilibet020

  1135. zaborna torilon

    Thanks for your personal marvelous posting! I definitely enjoyed reading it, you might be a great author.I will make certain to bookmark your blog and definitely will come back from now on. I want to encourage you to definitely continue your great job, have a nice afternoon!

  1143. zzz monochrome

    Keygold provides a reliable and affordable game top up solution for gamers worldwide.
    Our platform supports popular titles such as Genshin Impact, Honkai, and She, offering fast delivery and secure payment methods.

    Easily buy Primogems through our Genshin Impact top up service and get official GenshinbutPrimogems top up, genshin top up, or a Genshin Impact top up cheap, Keygold ensures smooth and instant transactions.

    We also offer a trusted Honkai Star Rail top up,buy Stellar Jade, purchase Honkai Star, and complete HSR top up or top up Star Rail without delays.

    For Zenless Zone Zero, our serbuy Mo quickly
    with instant ZZZ top up optionWith,Zenless Zone Zero buy monochrome, and ZZZ top up cheap with
    guaranteed safety.

    Choose Keygold for fast processing, competitive pricing, and a smooth top-up experience across
    all supported games.

  1148. mitolyn official

    **mitolyn official**

    Mitolyn is a carefully developed, plant-based formula created to help support metabolic efficiency and encourage healthy, lasting weight management.

  1238. spookyswap risks

    I personally find that the portfolio tracking process is simple and the quick deposits makes it even better.

Write A Comment