Overview

Middleware ledger, allocation and transfer state — Shopify remains system of record for physical stock and fulfillment.

Time	Movement	SKU	Location	Δ	Actor
{{orow.ts}}	{{orow.movement_type}}	{{orow.sku}}	{{orow.location_id}}	{{orow.deltaLabel}}	{{orow.actor}}

Clubs

Master club records — contact details and defaults new club orders inherit.

Club	Code	Type	Status	Contact	Default pickup	Open orders
{{c.name}}	{{c.code}}	{{c.type}}	{{c.status}}	{{c.contact}}	{{c.defaultPickup}}	{{c.openOrders}}	Edit →

A club order is the backorder record — its backordered qty is simply the unallocated line balance.

Club Order	Club	Required by	Event	Partial	Status	Progress
{{co.id}}	{{co.club}}	{{co.requiredBy}}	{{co.eventDate}}	{{co.partialLabel}}	{{co.statusLabel}}	{{co.progressLabel}}	Open →

SKU ↔ variant mapping, projected as one pool. Built by a sync job — not product webhooks.

SKU	Canonical member	Members	HO qty	Langley qty	Status
{{g.sku}}	{{g.canonical}}	{{g.memberCount}}	{{g.qtyHO}}	{{g.qtyLangley}}	{{g.status}}	Details →

Change	SKU	Detail	Detected
{{r.change_type}}	{{r.sku}}	{{r.detail}}	{{r.detected}}	{{r.resolvedLabel}}

Conflict	SKU	Detail
{{c.type}}	{{c.sku}}	{{c.detail}}	{{c.resolvedLabel}}

Run	Trigger	Mode	Started	Scanned	Changes	Status
{{s.id}}	{{s.trigger}}	{{s.mode}}	{{s.started}}	{{s.scanned}}	{{s.changes}}	{{s.status}}

Every transfer here was created automatically by the middleware. Staff only ship and receive them in Shopify.

Transfer	Reason	Route	Linked	Age	Status
{{tr.id}}	{{tr.reason}}	{{tr.route}}	{{tr.linked}}	{{tr.age}}	{{tr.status}}	Details →

Route

{{it.qty}} units

Exception	SKU / Route	Detail	Status
{{e.type}}	{{e.subject}}	{{e.detail}}	{{e.status}}

Destination	Source	Reason	Priority	Safety buffer
{{rule.destination}}	{{rule.source}}	{{rule.reason}}	{{rule.priority}}	{{rule.buffer}} units

Read-only — Admin role required to edit sourcing rules.

Purchase orders as incoming supply. A PO isn't owned by one club order — receipts allocate oldest-first across backordered lines.

PO	Vendor	Lines	Expected	Received	Status
{{po.id}}	{{po.vendor}}	{{po.lineSummary}}	{{po.expected}}	{{po.receivedSummary}}	{{po.statusLabel}}

Append-only. Every quantity is reconstructable from here — nothing is ever "corrected".

Transaction Ledger Inventory Ledger

SKU

Movement type

Timestamp	Movement	SKU	Location	Δ	Resulting	Source	Actor	Reason
{{row.ts}}	{{row.movement_type}}	{{row.sku}}	{{row.location_id}}	{{row.deltaLabel}}	{{row.resulting_qty}}	{{row.source_id}}	{{row.actor}}	{{row.reason}}

No ledger entries match this filter.

SKU	Location	Physical	Incoming Supply	Available	Reserved	Backordered	Incoming	In-Transit	Public Buffer	Allocatable	Reorder Threshold	Reorder Qty	Status
{{il.sku}}	{{il.location}}	{{il.physical}}	{{il.incomingSupply}}	{{il.available}}	{{il.reserved}}	{{il.backordered}}	{{il.incoming}}	{{il.inTransit}}	{{il.buffer}}	{{il.allocatable}}	{{il.reorderThreshold}}	{{il.reorderQty}}	{{il.status}}

No inventory rows match this filter.