How to use this review
Company Review (master) β start here. One row per SKU for the whole company. Set a Company decision (change the code or "Remove everywhere") and it cascades to every store as the default; then work store-by-store to confirm or override. A store change always wins, and store rows show β§ from company review where a company decision is in effect.
Stores: items grouped by category/sub-category with 12-month sales (trailing May 2025βApr 2026), estimated GMROI, current code, and the recommendation (SS core vs CS custom). Change the code, Remove to pull the SKU, or mark Reviewed to track progress.
Warehouse (19) is judged company-wide: Remove weak/dead, Reassign (target store shown), Keep. Model Store is the ideal core assortment with suggested Min/Max.
π Transfer-supported: demand isn't only retail sales. "Transfers out" are units pulled to fulfill instrument contracts and maintenance plans (B&O support), from 2 years of company history. A SKU with meaningful transfer demand is badged π transfer-supported β keep and protected from removal even if it barely sells β because it still has to be stocked. The row's company line shows sold/yr and π transfer/yr; tune the threshold in the toolbar and filter with "Only transfer-supported".
β Likely stock-out: the per-store 12-mo units are the trailing 12 months, so a store that ran out shows low/zero sales. When a SKU under-sells here but sells well at other stores (and no pack/size sibling is covering it locally), it's badged β likely stock-out β restock β investigate/replenish rather than remove. Tune the sensitivity in the toolbar; filter to just these with "Only likely stock-outs".
Saq_pk is built in. The system record key (InventoryLocID) per SKU+location is preloaded from your stock-sheet reference and shown in the change log, so whoever updates the system can find each exact record. π¦ Daily inventory is now just for refreshing on-hand: upload your daily inventory export (needs loc_stloc, sku_sku, saq_available) and current quantities update in the review (the "On hand" column and "Units on hand" KPI). Re-upload any time β the footer shows the as-of timestamp.
β³ Selection code update: after you push your changes to the inventory system, upload the system's new selection-code list here (CSV or XLSX with SKU, Location/Stloc, and a Qty Sel Code/Sel Code column β full ACC-SS or short S1 codes both work). It re-baselines every "current" code to match the system and resets the workbook β clearing all decisions and review marks (after a confirmation) so there's no carryover from prior days.
β» Reset reviews: clears all decisions and review marks on demand to start a fresh review, without changing baseline codes. It asks for confirmation first (and reminds you to Save a backup) so it can't happen by accident. Baseline codes, Saq_pk, on-hand, images and the change log are always kept.
Product images: each row links to the item on schmittmusic.com. Click πΌ Images and load a SKUβimage CSV (a Shopify product export works β it has Variant SKU and Image Src columns) to show real thumbnails inline. A β³ related note flags pack/size variants (the JSR6125 / JSR6125/3 case).
What each selection code means. ACC-SS (Essential) and ACC-CS (Custom) are the general stocksheets any store uses β the Company Rec column recommends between these two. The ACC-P** codes are Pro specialty shops at the flagship (11 only); ACC-SDC, ACC-SS/ALT, and ACC-TP/Online are warehouse stock types (19 only).
A snapshot of review progress, based on the company-level review data and the change log above β updates live as marks are made (by you or, once synced, by anyone else).