Skip to content

Inventory logs

Published

The inventory log is the answer to “why is this number what it is”. Every change to stock lands here, with what caused it and who was responsible.

Inventory → Inventory Logs, scoped to the warehouse in the header.

The inventory log

ColumnWhat it is
DateWhen it happened
ActivityWhat caused the change
ProductWhat moved
LocationWhere it moved
AvailableThe available figure after the change
On HandThe on-hand figure after the change

The last two are the reason this screen is worth reading rather than skimming. They are running balances: pick any row and you can see what the stock was at that moment, without adding anything up.

All · Orders · Fulfilled · PO Received · Corrections · Transfers · Sync

Each maps to a reason stock moved:

  • Orders — units committed when an order arrived.
  • Fulfilled — units deducted when an order shipped.
  • PO Received — a delivery counted in.
  • Corrections — manual adjustments and approved cycle counts.
  • Transfers — stock moving between warehouses.
  • Sync — a change that came from a connected channel.

Corrections is the filter to open first when a number is wrong. It is the short list of times a human overrode what the system believed, and the explanation is usually in it.

Sync is the second. A channel that changed a quantity of its own accord — an edit in a Shopify admin, an adjustment in an eBay listing — shows up here rather than as a mystery.

When a count disagrees with the system, work backwards:

  1. Filter to the product and find the last row you believe.
  2. Read forwards from there. The first row that looks wrong is the event to investigate.
  3. Check who is on it. Most discrepancies are a real action recorded correctly and understood differently — a return put back to the wrong bin, a transfer received twice.

The log records stock movement, not intent. It will tell you that forty units left a bin at 14:20 and who did it; it will not tell you why they thought that was right. For that, the order, the task, or the person is the source.