Sprint 1: Spine POC - identity/status/QR foundation

At a glance

Goals

Prove the identity/status/QR backbone (B1-B3) by reusing existing CSV/status primitives, before any heavier operational features.

Implementation — what to build

Checklist

• ○ Document item identity + status-event contract (B1)
• ○ Opaque QR resolver + binding demo, no mutable internal IDs (B2)
• ○ CSV sold/status roundtrip via troveInventoryStatus.parseStatusCsv (B3)
• ○ Demo fixtures for QR-bound / unbound items

Gates & testing

• ○ B1 Item identity and status event contract is documented and accepted for the POC.
  CODE TEST
• ○ B2 QR resolver and item binding demo is proven without exposing mutable internal IDs.
  CODE TEST
• ○ B3 CSV sold/status roundtrip works using current primitives.
  CODE TEST
• ○ B4 QR/identity binding tables (qr_codes / item_identity_bindings) model opaque public codes, binding state, and binding history.
  CODE TEST
• ○ B5 Inventory status-event audit contract records transitions for reconciliation and recovery.
  CODE TEST

Requirements

• REQ-SPINE-001 accepted Items need stable identity suitable for sale operations and later recovery.
  Done when: A POC item keeps a stable identity across status updates and CSV roundtrip.
  Spec: docs/product/capture-to-sale-tracking.md · docs/technical/data-model.md (Tracking identity)
• REQ-SPINE-002 accepted Status changes need an event contract that can support audit and reconciliation.
  Done when: Status event fields (previous/new status, source, final price) are documented and used by the POC path.
  Spec: docs/product/capture-to-sale-tracking.md · docs/technical/data-model.md (inventory_status_events)
• REQ-SPINE-007 accepted The canonical item lifecycle and its events must be defined, including disposition branches and an event stream safe to replay into analytics.
  Done when: Lifecycle draft->reviewed->published->active_sale->pending->sold->picked_up plus not_sold->disposition branches; the ~21 named events are emitted without implying every event mutates canonical inventory.
  Spec: docs/product/capture-to-sale-tracking.md (Status Contract, Events) · docs/product/disposition-engine.md
• REQ-SPINE-003 accepted QR codes need opaque resolver bindings rather than exposed mutable internal IDs.
  Done when: A QR demo resolves item state through an opaque binding; a code can start unbound, bind on first scan, be released, and be rebound.
  Spec: docs/product/capture-to-sale-tracking.md · docs/CC-Analysis/qr-closed-loop-and-sticker-packs.md
• REQ-SPINE-004 accepted Sold/status CSV roundtrip needs to work with existing primitives before richer workflows.
  Done when: CSV export/import can update sold/status state in demo fixtures.
  Spec: docs/product/capture-to-sale-tracking.md · docs/product/post-sale-reconciliation.md
• REQ-SPINE-005 accepted QR/identity binding needs durable tables with opaque public codes.
  Done when: qr_codes / item_identity_bindings model opaque codes, binding state, bound/released timestamps, and binding history.
  Spec: docs/technical/data-model.md (Tracking identity)
• REQ-SPINE-006 accepted Status transitions need an audit trail for reconciliation and recovery.
  Done when: inventory_status_events records transitions (with source: manual|csv_import|platform_sync|barcode|harness) that reconciliation and recovery read.
  Spec: docs/technical/data-model.md (inventory_status_events)

Verify (done when)

an item keeps a stable identity across status updates, resolves via an opaque QR binding, and round-trips sold/status through CSV.

Cost triggers

No paid API / infra spend triggered by this item.

Status & editing

in progress   Sprint: Sprint 1 - Spine POC

Edit status / sprint on the ★ Live Board → — changes are logged live with who / when / why.

Human-in-the-loop

No human tasks linked.

Findings

None recorded yet.

Concerns

• Reuse the LIVE CSV/status primitives rather than rebuild; confirm troveInventoryStatus covers the roundtrip.
• Per D9 (human-ratified), Platform & Contracts (ingestion/data-model) is build-first — Sprint 1 depends on it.

Risks

• Scope creep into operational-floor UI before the spine gates are proven.

Tech debt

None recorded yet.

Tools used

No tool calls recorded.

Files & artifacts

• Build-order decision (D6)
• Capture-to-sale tracking contract

Update log