Skip to main content

Stock take statuses, fields & list

A stock take is a warehouse-scoped count document that reconciles what SKU.io thinks is on your shelves with what a physical count finds. Every take carries a status, a mode, a count date, a variance direction, and a set of items — one line per product. This page is the field-level lookup for all of it: the three statuses and what each allows, the variance-direction and root-cause codes, the list (filters, sorts, tabs, view modes) and detail sub-views, the CSV export, and every field on the take, its items, and its reconciliation.

For why the model works the way it does — full-count vs adjustment mode, the snapshot-vs-count-date split, and what finalizing does to your books — read the concept How stock takes work. For the tasks themselves, see Create a stock take, Count stock, Finalize a stock take, and Amend a stock take.

You manage stock takes under Inventory → Stock Takes.

Two modes decide the path

The mode is chosen when you create a take and never changes. It decides which statuses a take passes through and how each item records its variance.

ModeOn-screen labelItem recordsLifecycle
full_countFull CountA counted quantity per line; variance is counted minus system on-hand.Draft → Open → Closed (a snapshot is captured at Open).
adjustmentAdjustmentA signed adjustment quantity per line; the delta is the variance.Draft → Closed (finalized directly, no snapshot).

The status tables below call out which actions apply to which mode.

Status

A stock take has exactly one status at a time. New takes start Draft.

ValueOn-screen labelMeaningInventory effect
draftDraftEditable staging. Items are added and scoped; adjustment-mode deltas are entered here.None — no snapshot, no movements, no accounting.
openOpenFull-count only. A system snapshot is captured and counters enter their counted quantities.Snapshot recorded; no movements yet.
closedClosedFinalized. Variance is written to stock, cost, and the books.Movements and FIFO layers created; value and accounting posted.

draft — staging, no inventory effect

Draft is the editable staging state. You add items, set the warehouse, and — in adjustment mode — enter each line's adjustment quantity. Nothing is committed: there is no snapshot, no movement ledger entry, and no accounting transaction. A draft take is freely editable and freely deletable.

Where a draft goes next depends on mode:

  • Full-count draft → Open. Initiate captures the snapshot and moves the take to Open. Initiate is rejected on an adjustment-mode take with a clear message (use finalize-adjustment instead), and a take must have at least one item to initiate.
  • Adjustment draft → Closed. Finalize adjustment posts the deltas and closes the take directly, skipping Open.

open — snapshot taken, counting in progress

Open exists only for full-count takes. When you initiate, SKU.io stamps the take and each of its items with a point-in-time snapshot of on-hand, available, and committed quantities. Counters then enter a counted quantity per line. Available actions while Open:

ActionWhat it does
Re-snapshotRecaptures the system quantities against current stock, re-baselining the count if inventory moved since Open.
Zero outBulk-sets the counted quantity for every line, in one of three modes: zero all (0 everywhere), keep submitted (each line's submitted / committed-to-fulfillment quantity), or keep all allocated (each line's full allocated total — pending + submitted). Keep all allocated preserves stock that orders have already claimed rather than counting it to zero.
Revert to draftClears the snapshot fields and value, returning the take to Draft for re-scoping.
Finalize & reconcilePosts the variance and closes the take. Every item must be counted first — finalize is blocked while any line is uncounted.

Movements that happen after the snapshot but before you finalize are tracked separately as during-count movements — see Detail sub-views and the reconciliation flow in Finalize a stock take.

Blind counts hide the system quantity

When a take is created with blind on, the system on-hand for an item that hasn't yet been counted is withheld, so the counter records what they physically find without anchoring to the expected number. Once a line is counted, its snapshot is revealed for variance review.

closed — finalized, inventory and accounting posted

Closing is terminal. Finalizing (full count) or finalize-adjustment (adjustment) writes the variance into FIFO layers and the movement ledger, sets the take's value change and variance direction, and posts the accounting transaction. A closed take isn't re-approved, but it supports these post-close actions:

ActionWhen it's available
ReverseUndoes all inventory effects — allowed only while no FIFO layer created by the take has been consumed, and not for channel-managed (Amazon FBA/AWD/WFS) stock.
Compensating adjustmentCreates a child adjustment take to correct a closed take whose FIFO layers have already been consumed (so it can't be reversed).
Cost correctionRe-costs the closed take's lines and reposts accounting, without touching quantities.
Edit notes / re-dateEdits the notes or moves the count date. Re-dating replays FIFO consumption and COGS; preview the impact first with the reallocation preview.

Delete on a closed take reverses its inventory effects, but is blocked when any FIFO layer it created has already been drawn from. The take reports whether it's deletable and, per item, what's blocking it; the list's Deletable check gives you the same answer in bulk.

Re-dating into a locked period is refused

Moving a closed take's count date into a locked accounting period is rejected, as is a reallocation that would cross a locked period. Amend the accounting period first.

variance_direction

At finalize, SKU.io summarizes the whole take's variance into a single variance direction. It compares each item's variance — the adjustment quantity in adjustment mode, the counted quantity for an initial count, otherwise counted minus snapshot — and rolls the signs up.

ValueOn-screen chipChip colorSet when
(null)(no chip)No item had a non-zero variance.
positivePositiveGreenEvery non-zero item was a gain.
negativeNegativeRedEvery non-zero item was a loss.
mixedMixedAmberThe take had both gains and losses.

Variance direction is stored on the take, so you can filter and sort the list by it. It's empty until the take closes.

Variance root-cause codes

Each item can optionally carry a variance reason — a cycle-counting root-cause code that records why the counted quantity differs from the system on-hand, so variance can be analysed by cause rather than as one undifferentiated adjustment. It's optional: leaving it blank is fine.

ValueOn-screen labelTypical use
receiving_errorReceiving ErrorStock was mis-counted or mis-booked at receipt.
picking_errorPicking ErrorA pick took the wrong quantity or wrong SKU.
mislabelMislabelProduct was labelled as the wrong SKU.
damageDamageUnits were damaged and pulled from sellable stock.
shrinkageShrinkageLoss with no identified cause (theft, spoilage).
unknownUnknownCause not determined.

The reason is chosen per line on the count table and stored on the item; it doesn't change the quantity or cost math, only the analytics.

The stock takes list

The list at Inventory → Stock Takes is server-paginated (10 per page by default) and built on the standard datatable stack — search, filters, saved views, sorts, column selector, and three view modes (table, grid card, and mobile card).

Filters

The following filters are exposed, most also as quick tabs and dropdowns above the table:

FilterTypeNotes
SearchtextMatches take ID (exact), notes, and warehouse name.
Statustab / selectAll, Draft, Open, Closed.
ModeselectAll, Full Count, Adjustment.
WarehouseselectFilters by warehouse.
Initial countselectAll, Yes, No.
Variance directionselectAll, Positive, Negative, Mixed.
Count datedate rangeCount date between two dates.
Created / Updateddate rangeCreated and updated date ranges.
Value changenumericFilters on the take's value change.
ArchivedselectDefault hides archived; only shows archived, all shows both.

Sorts

Sortable columns: ID, Count Date, Status, Value Change, Variance Direction, Created, and Updated. The default sort is newest first.

Columns

The table shows ID, Status, Mode, Warehouse, Count Date, Value Change, Variance Direction, Notes, Created, and Updated. The list omits the item lines — those load only on the detail page.

Detail sub-views

Open a take to its detail page. Beneath the header, a set of tabs exposes the take's data. Which tabs appear depends on status:

TabShown whenContents
ItemsAlwaysOne row per product — SKU, snapshot, counted/adjustment quantity, unit cost, variance reason, and lot fields. Includes the Export action.
FIFO LayersClosedThe FIFO layers the take created, with product, warehouse, and cost.
Inventory MovementsClosedThe movement ledger entries the take wrote (type Stock Take).
Reconciliation LogWhen entries existThe audit of reconciliation actions taken at finalize (see below).
ActivityAlwaysThe activity log filtered to this take as subject.

While a take is Open, the header separately surfaces a Movements Since Snapshot count and dialog — the during-count movements that landed after the snapshot (and aren't this take's own). These feed the reconciliation preview when you finalize.

Reconciliation log actions

The Reconciliation Log records what finalize did when a count collided with in-flight orders. Each entry records one action:

ActionMeaning
adjustment_appliedThe item's variance was written to stock.
count_adjustedA line's counted quantity was changed during reconciliation (for example, to absorb during-count movement).
item_removedA line was dropped from the take during reconciliation.
fulfillment_cancelledAn open shipment was cancelled to free stock the count removed.
fulfillment_cancel_failedA cancellation was attempted but failed (see the entry detail).
order_deallocatedAn order's allocation was released.
order_backorderedAn order line was pushed to the backorder queue because the count left it short.
allocation_downgradedA committed allocation was downgraded to planned.

Export count lines

The Export button on the Items tab downloads the take's lines as CSV (stock_take_lines.csv). The columns depend on status:

ColumnAlwaysNotes
idYesThe product ID.
skuYesProduct SKU.
barcodeYesProduct barcode.
nameYesProduct name.
snapshot_inventoryPast draft onlyThe captured system quantity.
qty_countedPast draft onlyThe counted quantity.
adjustmentPast draft onlyThe counted quantity minus the snapshot.
unit_costPast draft onlyThe item's unit cost (falls back to the product's).

A Draft take exports only the four identity columns — it has no snapshot yet. The same shape is the round-trip template for the import-lines upload, so an exported file can be edited and re-imported.

What a stock take records

The take itself carries:

DetailWhat it holds
IDThe take's reference number.
Count dateThe effective date the count applies to — this drives FIFO placement and the accounting date.
Snapshot takenWhen the system snapshot was captured. Full-count takes only; adjustment takes have no snapshot.
WarehouseThe warehouse being counted. Every line and movement is scoped to it.
ModeFull Count or Adjustment.
ConditionAn optional condition label. Combined with the warehouse, it's what keeps initial counts unique.
Initial countMarks an opening count that establishes stock from zero.
BlindHides the system quantity for uncounted lines while counting.
StatusDraft, Open, or Closed.
Value changeTotal cost value the take moved, once finalized.
Variance directionPositive, Negative, Mixed, or none.
NotesFree-text notes; searchable, and editable after close.
CorrectsLinks a compensating adjustment back to the take it corrects.
Created fromWhat created the take, when another process created it — for example an FBA inbound.
Accounting transactionThe accounting transaction the finalized take posted into.
ArchivedSet when archived; archived takes are hidden from the default list.

A take also reports whether it's deletable and, if not, what's blocking deletion; how many movements happened during an open count; and a summary of its parent and child takes.

What each counted item records

One item per product on the take:

DetailWhat it holds
ProductThe counted product.
Counted quantityThe physical count, in full-count mode. Empty until the line is counted.
Adjustment quantityThe signed delta, in adjustment mode.
VarianceCounted quantity minus the system snapshot — the effective variance for a full count.
Unit costThe cost basis, saved at snapshot time from the best available cost.
Realized unit costThe actual per-unit cost realized from FIFO once the take closed. Closed takes only.
Variance reasonA root-cause code.
BinThe counted bin, stamped onto the item's variance movements.
System on handOn-hand captured at Open. Zero for an initial count.
Available at snapshotAvailable quantity at the time of the snapshot.
Rsv (Submitted)Units committed to fulfillment at snapshot.
Rsv (Pending)Allocated units not yet submitted — the total allocated at snapshot minus the submitted portion. This is also what the Keep all allocated zero-out mode preserves. Zero for an initial count.
LotsBatch number, manufacture and expiry dates, quantity, and notes, for lot-tracked products.
Lot allocationThe FIFO layers chosen to consume for a negative-variance override.

Each item also carries the product's lot settings — whether it's lot-tracked, its tracking method, shelf life, and expiry thresholds — so the count table can enforce lot entry where it's required.

"Reserved" on a count means allocated, not a stock state

SKU.io has no "reserved" inventory status — the product list column that once read "Reserved" is now On Hold. On a stock take, Rsv (Pending) and Rsv (Submitted) are allocation figures, not a status: Submitted is the portion already committed to fulfillment at snapshot, and Pending is the rest of the allocated total. For the real states — on-hand, available, allocated, on-hold, non-sellable, incoming, and in-transit — see Stock states and the stock states and fields reference. On-hand reconciles as Available + Allocated + On Hold + Non-Sellable.

What the reconciliation preview shows

When you finalize a full count, SKU.io builds a preview of the variance against current stock and any orders it touches, then reports the outcome after you execute. This is what powers the reconciliation dialog in Finalize a stock take.

Per counted item

ShownMeaning
Snapshot and CountedThe system quantity at snapshot and what you counted.
VarianceCounted minus snapshot.
Movement during countNet stock movement between the snapshot and finalize.
Adjusted snapshot and adjusted varianceSnapshot and variance re-based to absorb that during-count movement.
Available now, On hand nowCurrent stock, so you can see what the count would do to it.
Allocated nowAllocations pending, and those already submitted to a shipment.
ShortfallHow far the count falls below what open orders need.
Affected ordersThe orders a negative variance would disrupt — see below.
Movements during countThe individual movements that landed while counting.

Per affected order

ShownMeaning
OrderThe sales order and its reference.
LinesThe affected order lines.
QuantityUnits in contention.
Order date and statusWhen the order was placed and where it stands.
Shipment and statusThe shipment, if one exists, and its status.
Shipping providerThe provider, and whether the shipment was already dispatched to them.
CancellableWhether SKU.io can cancel it as part of reconciliation.

After you execute

The result reports whether reconciliation succeeded and the take closed, the total cost value moved, which shipments were cancelled and any that couldn't be, which lines had their counted quantity adjusted or were dropped from the take, which order lines were pushed to backorder, which allocations were downgraded from committed to planned, and the error message if finalize failed.

Next steps

Last verified: