What is an inventory audit trail?
It is a dated record of every change to an item quantity and what caused it. It lets you explain the current number and find the exact change behind a discrepancy.
Custom Report · Inventory
Inventory Change Audit Report: every change to a SKU quantity, with its cause
An inventory change audit report lists every change to a SKU quantity in order: when it happened, how much it moved, the resulting total, and what caused it. InfiPlex writes that history for each SKU, covering orders, uploads, manual edits, and API changes, so an AI agent connected to the MCP server can answer the question every inventory manager asks: why does this SKU show the number it shows?
- Every changeOrders, uploads, edits, and API sets
- Running totalThe quantity after each change
- Cause attachedAn order number or the action taken
The prompt
Why does this SKU show the inventory quantity it shows?
Name the SKU. The agent reads the change history and walks the quantity back step by step.
Why is RS-310 at 12 units? Show every inventory change this week with the cause.
Used InfiPlex OMS integration
RS-310 is at 12. Changes this week, newest first:
| When | Change | Resulting total | Cause |
|---|---|---|---|
| Wednesday 9:14 AM | -2 | 12 | Order 418951 |
| Wednesday 7:02 AM | -1 | 14 | Order 418933 |
| Tuesday 4:40 PM | Set to 15 | 15 | Inventory upload |
| Tuesday 11:26 AM | -3 | 9 | Order 418790 |
| Monday 2:15 PM | +10 | 12 | Manual inventory add |
| Monday 8:03 AM | -1 | 2 | Order 418622 |
The upload on Tuesday set the quantity to 15 when the running total was 9, an increase of 6. Everything since is order deductions.
Six rows explain the number. A change with an order number is a sale; a set is someone or something replacing the quantity. For quantities crossing to and from channels and partners, see the inventory sent to marketplace report.
What is in the report
What the InfiPlex inventory change audit report shows
Deltas and absolute sets are shown differently, because they answer different questions.
| Column | What it tells you |
|---|---|
| When | Time of the change in your account time zone |
| Change | Units added or removed, or the value the quantity was set to |
| Resulting total | Total inventory for the SKU after the change, across warehouses |
| Cause | What made the change: an order number, an upload, a manual edit, or product creation |
Make it yours
Follow-up prompts that reshape the inventory change audit 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.
- “Show only the changes that were not orders.”Isolates uploads, edits, and sets.
- “Which orders took the most units of RS-310 this month?”Follows the order numbers in the history back to the orders.
- “Do the same for these five SKUs and summarize what looks unusual.”Runs the history per SKU and flags large sets or reversals.
- “What does our 3PL report for RS-310 right now?”Checks the partner side for the same item.
Where the numbers come from
The InfiPlex data behind the inventory change audit report
One read per SKU, with orders and partner data a follow-up away.
inventory_change_history_getThe change history for a SKU: time, delta or set, resulting total, and noteinventory_getCurrent quantity, in total or per warehouseorder_getThe order behind any order number in the historyfulfillment_connection_productsWhat a 3PL or supplier last reported for the item
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 inventory change audit report daily or weekly
Run it on demand, or daily for a short list of SKUs you are watching. 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
Inventory Change Audit Report questions, answered
What sellers ask before they build this report on InfiPlex.
What kinds of changes does InfiPlex record?
Order deductions, order quantity changes, inventory uploads, manual edits in the inventory tools, API and AI agent changes, and product creation. Each entry carries a note on its cause.
How far back does the history go?
The MCP tool returns the most recent 100 changes for a SKU, newest first, which covers the working window for most investigations.
Does the history show per warehouse quantities?
The resulting total in the history is the SKU total across warehouses. Ask for current stock by warehouse and the agent adds the per location view from inventory.
Can it tell me who changed the quantity?
The note on each entry records what made the change, such as an order number or an upload. Access to make changes is controlled by user roles and by the permissions on each API key.
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
- Orders by Warehouse Report
- Shipping Method 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
Explain any inventory number in one question
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 inventory change audit 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.
