Tronix Login

321 STRONG · Tronix

Sign in with Google

Access restricted to @321strong.com and @quietmine.com emails

or

π Warehouse
Admin Logout
Tronix/Supply Chain/Warehouse

Warehouse

Data as of —
Legend:— never counted (no value recorded, not zero)

Warehouse On-Hand

…
Loading…

Feeding Crons

Loading cron status…

Data Provenance

Click a card for the full provenance detail.

SOURCE⤢Active spinetronix.db.dim_sku (real + active) — thecanon…Manual entry — B's physical count — B hand-counts on-hand units at the 3PL and records them in his authority spreadsheet ('Amazon' tab, col AT "WH Inventory"). That spreadsheet is a manual transcription surface, NOT a scheduled/ongoing feed — nothing reads it unless a human runs the import below.SOURCE⤢Manual entry — B's physic…B hand-counts on-hand units at the 3PLand re…import-warehouse-from-sheet (MANUAL, no schedule) — Human-invoked only · POST /api/admin/tronix/cron/import-warehouse-from-sheet · point-in-time import of the hand-counted per-ASIN qty onto each ASIN's canonical SKU (source='sheet'), sibling alias rows NULLed so the per-ASIN SUM matches the count exactly. NO cron, NO plist — Warehouse is a No-Cron wedge (#14002).PIPELINE⤢import-warehouse-from-she…Human-invoked onlyManual correction — B's durable override (#14002) — When a hand-counted value is wrong, B records the true per-ASIN count via POST /api/admin/tronix/warehouse-override. The correction WINS over the mirrored sheet value at read time and the manual import SKIPS those ASINs, so it survives every re-import instead of being clobbered back. Clear the override once the sheet cell itself is fixed.SOURCE⤢Manual correction — B's d…When a hand-counted value is wrong, Brecords…tronix.db.warehouse_inventory + warehouse_qty_overrides — warehouse_inventory = the sheet MIRROR, one row per active-spine SKU, source = sheet, NULL when never counted (never 0-filled). warehouse_qty_overrides = B's per-ASIN corrections. Displayed on-hand is COALESCE(override, Σ mirror); both numbers stay visible so divergence is never hidden.STORE⤢tronix.db.warehouse_inven…warehouse_inventory = the sheet MIRROR,one r…VIEW⤢This View/admin/tronix/supply-chain/warehouse

Docs & References

Agent Brief
docs/tronix/wedges/warehouse.md
References
None.

Edit agent brief — docs/tronix/wedges/warehouse.md

Markdown. Saved to the DB (wedge_docs) live — no deploy. This is the brief handed to dispatched agents.
Saved successfully!
Something went wrong