What is an orders by warehouse report?
It is a count of orders and units shipped from each fulfillment location for a period. It shows how volume is distributed and whether routing rules are sending orders where you expect.
Custom Report · Operations
Orders by Warehouse Report: how many orders each warehouse filled, and why they routed there
An orders by warehouse report shows how many orders and units each warehouse, 3PL, or fulfillment network shipped in a period, and what share of the total that is. InfiPlex routes every order line to a warehouse and keeps a written record of each routing decision, so an AI agent connected to the MCP server can total the volume per warehouse and also explain any single order: which warehouses were eligible, which rule applied, and how much stock each had at that moment.
- Volume per warehouseOrders, units, and share
- Split orders countedOrders filled from more than one location
- Routing explainedThe record behind every decision
The prompt
How many orders did each warehouse ship?
Name the period. The agent reads the warehouses used on each order and totals orders and units per location.
How many orders and units did each warehouse fill in the last 30 days? Include the share of orders and how many orders were split across warehouses.
Used InfiPlex OMS integration
Orders filled by warehouse for the last 30 days. Each order is counted at the warehouse that shipped most of its units:
| Warehouse | Orders | Units | Share of orders |
|---|---|---|---|
| main | 2,410 | 3,980 | 59.7% |
| west | 1,288 | 2,075 | 31.9% |
| east-3pl | 340 | 512 | 8.4% |
| Total | 4,038 | 6,567 | 100% |
96 orders were split across two warehouses, 2.4% of the total. Most splits were main plus west on orders with three or more lines.
This is the report that shows whether your routing rules do what you intended. The rules themselves are on the multi-warehouse order routing page, and zip code routing in the geo order routing guide.
What is in the report
What the InfiPlex orders by warehouse report shows
Warehouses appear under the ident you gave them in InfiPlex, whether they are your own buildings or a partner.
| Column | What it tells you |
|---|---|
| Warehouse | The InfiPlex warehouse ident |
| Orders | Orders filled from the warehouse in the period |
| Units | Units shipped from the warehouse |
| Share of orders | The warehouse share of all orders |
| Split orders | Orders with lines filled from more than one warehouse |
Make it yours
Follow-up prompts that reshape the orders by warehouse report
The first answer is a starting point. Each follow-up below is one more sentence in the same conversation, and the AI agent rebuilds the report from InfiPlex data each time.
- “Why did order 418915 ship from west?”Reads the routing record: eligible warehouses, zip rule, stock at each, and units taken.
- “Break each warehouse down by sales channel.”Shows which channels each location is serving.
- “Which states is east-3pl shipping to most?”Regroups one warehouse by ship-to state to check zone coverage.
- “List the split orders and the SKU that caused each split.”Finds the lines that could not be filled from the first warehouse.
Where the numbers come from
The InfiPlex data behind the orders by warehouse report
Order records carry the warehouses used; the routing record explains each one.
order_searchOrders for the period with the warehouses used on eachorder_search filter_items_after_query_by_warehouse_identsNarrows each order to the lines assigned to named warehousesorder_warehouse_routing_explanation_getThe step by step routing record for one orderwarehouse_searchEvery warehouse with its address, routing settings, and zip code rules
Every tool and its inputs are listed in the MCP tools reference. The same data is available as JSON through the InfiPlex REST API for teams that prefer a script.
Run it on a schedule
Schedule the orders by warehouse report daily or weekly
A weekly run is enough to see a shift in how volume is distributing. A scheduled AI agent or a short script runs the same prompt from cron and delivers the result by email, Slack, or shared folder. The scheduled custom reports guide covers both routes, and the daily inventory by warehouse report agent is a worked example to copy.
Frequently asked
Orders by Warehouse Report questions, answered
What sellers ask before they build this report on InfiPlex.
Can InfiPlex explain why an order shipped from a specific warehouse?
Yes. InfiPlex writes a routing record when each order is allocated, listing the warehouses considered, the rules checked, the stock at each, and the units taken. The agent reads it back in plain English.
Does it include 3PLs and marketplace fulfillment networks?
Yes. A 3PL, Amazon FBA, Walmart WFS, and each Wayfair CastleGate location are warehouses in InfiPlex, so they appear as rows. See the 3PL Connector.
How are orders split across warehouses counted?
The summary counts each order once, at the warehouse that shipped most of its units, and reports split orders separately. Ask for line level counts when you want every warehouse credited for its lines.
Can I see orders by warehouse for one marketplace?
Yes. Add the channel to the prompt and the agent filters orders to that order source before totaling.
Resources
Related InfiPlex pages and guides
More custom reports
- All custom eCommerce reports
- Profit by Sales Channel Report
- SKU Profitability Report
- Multichannel Sales by Channel Report
- Top Selling SKUs Report
- Daily Sales Report
- Late Shipment Report
- Marketplace Fulfillment Error Report
- 3PL Inventory Reconciliation Report
- Inventory Sent to Marketplace Report
- Shipping Method Report
- Inventory Change Audit Report
- Unknown SKU Report
AI agents and the MCP server
- InfiPlex MCP server
- MCP server set-up guide
- MCP tools reference
- Scheduled custom reports with MCP and the API
- AI agent prompts for order management
- Is it secure? A plain-English overview
InfiPlex features behind this report
See where your orders ship from, and why
Connect an AI agent to InfiPlex, ask for the report in plain English, and put it on a schedule. No spreadsheet exports, no report builder to learn.
Want the orders by warehouse report on your own data?
Tell us which channels, warehouses, and systems you run and we will build this report with you on a live InfiPlex instance. Contact us, email info@infiplex.com, or call 888‑770‑0857.
InfiPlex™ is a trademark of InfiPlex. Marketplace, retailer, carrier, and software names are trademarks of their respective owners. InfiPlex is an independent integration provider and is not endorsed by or affiliated with any of them. Report output on this page is sample data shown in the format the InfiPlex MCP server returns. ©2026 InfiPlex. All rights reserved.
