Skip to main content

Get Product Inventory Tally

GET 

/api/v2/products/:product/inventory-tally

Get the enriched inventory tally for a product at a specific warehouse — a chronological movement ledger with running balances.

Required scope: products:read

Grant this scope to your token under Settings → Developer → Personal Access Tokens.

The movements array is a merged ledger of two row kinds, discriminated by row_kind:

  • movement — a real inventory movement. Carries id, type, quantity, reference, and the ledger running_balance.
  • channel_debt — a sales order line the sales channel fulfilled while the warehouse had no stock. No inventory movement exists for these units, so the row never changes running_balance. Carries sales_order_id, sales_order_line_id, the gross owed quantity (negative), outstanding_quantity (gross minus active allocations), and is_covered.

Every row also carries implied_physical_balance — the ledger running balance minus cumulative channel debt so far, i.e. the physical stock level implied once channel-shipped-but-never-deducted units are counted.

Channel-debt rows are only interleaved when inventory_status is active (the default); an in_transit tally returns zeroed channel-debt totals.

Summary fields: movement_count counts movement rows only; channel_debt_count, channel_debt_units (gross), channel_debt_outstanding_units, and channel_debt_order_count describe the debt; implied_physical_closing_balance = closing_balance minus gross channel debt.

Authentication: Requires Bearer token.

Movement rows also carry recorded_at — when the movement was booked. A sale recorded well after its movement date is the settled-fulfillment-debt signature: the deduction was minted when stock arrived, backdated to the ship time.

Movement rows carry the polymorphic source document (link_type, link_id, parent_link_id, detail_link_id) so the reference can link to its page. A channel_debt row's date is its chronological settlement position: the channel ship time when a recorded shipment exists, else the order date — the date its movement will carry once settled. Scarce arriving stock settles debt in exactly this order.

Request​

Responses​

OK

Response Headers
    Content-Type