How would I go about creating a customization to search for orders/customers by a product in their order.
You can get by simple mysql query:- select order_id from sales_flat_order_item where product_id=//given product id. OR. You can customize ...
Filter the search · Click the Filters tab to display the selection of search filters. · Complete as many of the filters as needed to describe the order(s) ...
The following search finds all the products that are provided in the value
An order, in your Order Management System (OMS), is a request for products. Find all of the details for orders in Sales > Orders in your OMS.
Magneto 2 does not allow to filter Orders by product's IDs so you have to write custom API(code) for it by Joining "sales_order_item" table.
Furthermore, Magento 2 Quick Order module brings a highlight function of searching for products by SKU. With this useful method, wholesale ...
with quick access to sales, order, search term and best-selling product data. Enhanced navigation and search make it easy to find information, and management ...
Extended Order Grid · Show all necessary product data on the order grid · Search and sort orders by product data - name, SKU, etc · Display product thumbnails on ...
Search by SKU is always an useful feature in Magento for product