Schmitt MusicAccessory Selection Code Review
stores
not connected yet
Review by SKU
Recommended not carried 0
Change log 0
Code key
πŸ“Š Reporting
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).

βŠ• expand all βŠ– collapse all

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).

The reference for updating the system by hand. Click a column to sort; use the filter row or Action dropdown to narrow it. ⬇ Export change log downloads the current view. clear filters

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).