Integrity inbox

JSS · investigate, don't accuse

Register SQLite snapshot

Inventory records worth an owner review.

Time & store scope

JSS · store 1001 · register Station1 · snapshot 2026-09-29 00:17 UTC

Calculation

Negative, zero, and low quantity bands from the register snapshot

Source fields

Station1 retail register (active retail test site) · catalog SKU, price, cost, 42 suppliers · inventory quantity on hand · snapshot 2026-09-29T00:17:58Z

Read-only Station1 register snapshot. Station1 local sales history holds 1,139 sales ($44,304.14 historical, not a period total). Department/category breakdowns and the 3 negative-stock rows come from the earlier register extract until Station1 detail rows are supplied.

Needs a look

SKU / itemQoHStatusAdmin
Crct 54500-8Needs a lookOpen in admin
Smatk 405-2Needs a lookOpen in admin
CRAVE MAX SMOOTH CLEAR 3% 2500 PUFFS-1Needs a lookOpen in admin

Inventory review queue

PrioritySignalSKUsBasisNext step
1Negative quantity3Quantity on hand below zeroCount shelf and check receiving history
2Zero quantity1,234Quantity on hand equals zeroSeparate active items from inactive catalog records
3Low quantity834Quantity on hand is 1–2Spot-count before preparing replenishment