What is a SKU profitability report?
It lists each SKU with units sold, revenue, cost, gross profit, and margin for a period. It answers which products earn money and which only move volume.
Custom Report · Profit
SKU Profitability Report: profit and margin for every SKU across every channel
A SKU profitability report ranks your products by gross profit and margin, using units sold, revenue, and cost across all sales channels together. On InfiPlex an AI agent builds it from order line items: every sale of a SKU on Amazon, Walmart, Shopify, or an EDI retailer lands in the same order format, so one prompt returns profit per SKU with no channel left out. Connect Claude, Cursor, ChatGPT through Codex, or any MCP client to the InfiPlex MCP server and ask.
- Per SKUUnits, revenue, cost, profit, and margin
- All channels togetherOr one row per SKU per channel
- Sortable by marginBest and worst earners at the top
The prompt
How do I see profit by SKU across all channels?
Ask for the period and the sort order. The AI agent reads the order lines, totals each SKU, and ranks the list.
Show SKU profitability for the last 30 days across all channels: units, revenue, cost, gross profit, and margin. Sort by gross profit and flag anything under 15% margin.
Used InfiPlex OMS integration
SKU profitability for the last 30 days, all channels combined. Top five by gross profit:
| SKU | Units | Revenue | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| HX-2040 | 412 | $20,188 | $11,124 | $9,064 | 44.9% |
| BL-7702 | 96 | $12,384 | $6,816 | $5,568 | 45.0% |
| PM-55 | 188 | $6,580 | $3,008 | $3,572 | 54.3% |
| KT-118 | 655 | $11,790 | $8,515 | $3,275 | 27.8% |
| RS-310 | 301 | $7,224 | $6,321 | $903 | 12.5% |
RS-310 is under the 15% line: 301 units sold for $903 of gross profit. KT-118 is the unit leader at 655 but fourth by profit.
The unit leader and the profit leader are rarely the same SKU. This report puts both facts in one row, which is what pricing, purchasing, and channel decisions need. To see where a SKU sells, pair it with the profit by sales channel report.
What is in the report
What the InfiPlex SKU profitability report shows
One row per SKU, or one row per SKU per channel when you ask for the split.
| Column | What it tells you |
|---|---|
| SKU | Your InfiPlex SKU, the same one on every channel listing mapped to it |
| Units | Quantity sold in the period across the channels in scope |
| Revenue | Sum of line item prices for the SKU |
| Cost | Sum of the cost saved on those order lines |
| Gross profit | Revenue minus cost |
| Margin | Gross profit as a share of revenue |
Make it yours
Follow-up prompts that reshape the SKU profitability 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.
- “Give me one row per SKU per channel for the top 20 SKUs.”Shows whether a SKU earns the same margin on Amazon.com as on Shopify or Walmart.
- “List every SKU with a margin under 15% and its current price.”Adds the live price from InfiPlex so the low earners arrive with the number you would change.
- “Which SKUs sold fewer than 5 units but still have stock?”Combines sales with current inventory to surface slow movers.
- “Add on-hand inventory and days of stock left for each SKU.”Joins the profit list to inventory so the best earners can be checked for coverage.
Where the numbers come from
The InfiPlex data behind the SKU profitability report
Read tools only. The agent pages through the orders, then totals by SKU.
order_searchOrders and line items for the period: SKU, quantity, price, and costprice_searchCurrent price per SKU for follow-up questionsinventory_searchCurrent stock per SKU when you ask for coverage
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 SKU profitability report daily or weekly
A weekly SKU profitability run keeps pricing and purchasing looking at the same list. 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
SKU Profitability Report questions, answered
What sellers ask before they build this report on InfiPlex.
Does it combine the same product sold on different channels?
Yes. InfiPlex maps each channel listing to one SKU, so sales from Amazon, Walmart, Shopify, and EDI retailers total under the same row. Ask for a per channel split when you want to compare.
How are bundles and kits handled?
A bundle SKU sold on an order is reported as that SKU. The SKU groups, bundles, and SKU maps guide explains how InfiPlex relates a bundle to its components, and the agent can read those relationships when you want component level numbers.
Can I export the SKU profitability report to a spreadsheet?
Yes. Ask for a CSV or spreadsheet and the agent returns a file with every SKU, or schedule it and have the file emailed.
How many SKUs can it handle?
The report is built from orders in the period, so its size follows your order volume. The agent pages through results in batches, and a scheduled script on the REST API is the route for very large catalogs.
Resources
Related InfiPlex pages and guides
More custom reports
- All custom eCommerce reports
- Profit by Sales Channel 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
- Orders by Warehouse 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
Know which SKUs earn and which only move volume
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 SKU profitability 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.
