Custom Report · Profit
A profit by sales channel report shows revenue, cost of goods, gross profit, and margin for each place you sell, side by side on the same cost basis. On InfiPlex you build it by asking: an AI agent connected to the InfiPlex MCP server reads your orders from Amazon, Walmart, Shopify, eBay, and every other connected channel, uses the price and cost saved on each order line, and returns the channel P&L as a table you can sort, chart, or schedule. It works with Claude, Cursor, ChatGPT through Codex, or any MCP client.
The prompt
Ask for it. The AI agent pulls the orders for the period, groups them by order source, and totals revenue and cost from the line items.
Build a profit by sales channel report for the last 30 days: orders, revenue, cost, gross profit, and margin for each channel, highest profit first.
Used InfiPlex OMS integration
Here is gross profit by sales channel for the last 30 days, canceled orders excluded:
| Channel | Orders | Revenue | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| Amazon.com | 1,842 | $148,260 | $96,370 | $51,890 | 35.0% |
| Shopify | 1,204 | $88,410 | $49,510 | $38,900 | 44.0% |
| Walmart | 611 | $46,930 | $32,380 | $14,550 | 31.0% |
| Target Plus | 148 | $17,390 | $10,960 | $6,430 | 37.0% |
| eBay | 233 | $14,720 | $10,160 | $4,560 | 31.0% |
| Total | 4,038 | $315,710 | $199,380 | $116,330 | 36.8% |
Amazon.com brings 47% of revenue and 45% of gross profit. Shopify is the highest margin channel at 44.0%, nine points above Amazon.com.
That is a channel P&L from one sentence. The channel that sells the most and the channel that earns the most are different rows, which is the reason sellers ask for this report first. For the same view one level down, see the SKU profitability report.
What is in the report
Every column is computed from order data InfiPlex already holds, so the report covers each channel the same way.
| Column | What it tells you |
|---|---|
| Channel | The order source InfiPlex recorded on the order: Amazon.com, Walmart, Shopify, an EDI retailer, or any other connection |
| Orders | Order count for the period, canceled orders left out |
| Revenue | Sum of the line item prices on those orders |
| Cost | Sum of the cost saved on each order line |
| Gross profit | Revenue minus cost |
| Margin | Gross profit as a share of revenue |
Make it yours
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.
Where the numbers come from
The AI agent calls three read tools and does the arithmetic itself. Nothing is written to your account.
order_searchOrders for the date range with their line items, price, and cost, filtered by order source when neededorder_search group_byOrder counts per channel in one call, used to check the totalschannel_listThe exact order source value for every channel InfiPlex supportsEvery 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
Most sellers run channel profit weekly for the operations meeting and monthly for the close. 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
What sellers ask before they build this report on InfiPlex.
It is a report that lists each sales channel with its revenue, cost of goods, gross profit, and margin for a period, so channels are compared on profit instead of sales alone. On InfiPlex an AI agent builds it from your order records when you ask for it.
InfiPlex saves cost on the order lines, and the report reads it from there. The SKU Cost of Goods report in the OMS uses the same order data if you prefer a built-in screen.
Gross profit in this report is price minus cost from the order. For fees, refunds, and payouts as the marketplace settled them, pair it with the InfiPlex Settlement report, and ask the agent to place the two side by side.
Every order source connected to InfiPlex: marketplaces, shopping carts, EDI retailers, and manual orders. The full list is on the integrations page.
Profit apps start from one storefront and add channels one at a time. InfiPlex already holds the orders from every channel in one normalized format, so the report is a question asked of data you already have, with no extra connector to buy.
Resources
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.
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.
InfiPlex provides eCommerce companies, warehouses, and 3PLs with a robust platform to manage their sales channels.
©2026. All Rights Reserved. Privacy Policy | Terms & License