Why serial-number-level tracking matters here
A guitar, violin, or brass instrument isn't interchangeable with another unit of the "same" model the way a box of strings is, condition, setup, and history matter, and a specific unit is what's actually rented, sold, or sent for repair. A shop tracking only a model-level count can't answer "which specific instrument is out with customer X", a real, recurring question in a business built around rentals and repairs.
Student instrument rental programs run alongside retail sales in most music stores and need a different tracking model entirely: available for rent, currently out with a renter, due back on a specific date, or pulled for repair, not a simple in-stock/sold count.
Consignment is common for higher-value used instruments, a customer brings in an instrument to sell on the store's floor for an agreed price and split. That stock needs to be visible to sell but tracked separately from owned inventory, with the specific unit, agreed price, and condition notes attached.
Tracking instruments, rentals, and consignment
Tag every higher-value instrument individually with brand, model, serial number, condition, and location, so a specific unit's full history, sale, rental, repair, stays attached to that unit rather than a general model count.
Run rentals as their own status workflow: available, out (with renter and due date), overdue, or in for repair, using a custom date field for the due date. StockFlow doesn't send an automated reminder before a rental is due today that's a manual check against the due-date field, not a scheduled notification.
Track consignment instruments with the consignor's name, intake date, agreed price, and condition notes at intake, kept distinct from owned stock so payouts and margin calculations stay accurate when a consignment piece sells.
- Individual serial-number tracking for higher-value instruments
- Rental status model: available, out (with due date), overdue, in repair
- Consignment tracked separately with consignor, price, and condition notes
- Repair-bay parts (strings, reeds, valve oil) tracked as standard reorderable stock
Trade-ins vs. consignment: different ownership models
Trade-ins are common in musical instrument retail: a customer brings in a used instrument to put toward a new purchase, and the store either pays cash or issues store credit. Unlike consignment, a trade-in becomes owned store inventory immediately once the deal is done the store owns that unit outright and can price, repair, or resell it on its own timeline, rather than waiting on a consignor's agreed price and split.
Track the trade-in appraisal (condition, estimated resale value, cash or credit offered) at intake, then move the unit into standard owned inventory with its own serial number, condition notes, and price once it's accepted, so it shows up in regular stock counts instead of sitting in an untracked back-room pile.
Because trade-ins often need reconditioning before resale (new strings, a setup, cleaning), routing them through the same in-for-repair status used for rentals keeps a traded-in instrument visible as work-in-progress instead of disappearing from inventory between intake and the sales floor.
- Trade-in intake: condition, appraisal value, cash or store-credit offer
- Ownership transfers immediately, unlike consignment which stays consignor-owned
- Traded-in units routed through repair/recondition status before resale
Repair shop parts alongside retail and rental stock
Most music stores run a repair or maintenance service alongside sales and rentals, consuming parts (strings, reeds, valve oil, replacement hardware) from the same stock a customer might buy at the counter. Tracking that consumption the same way a retail sale is tracked keeps parts stock accurate instead of drifting from what the shelf actually shows.
Everyday accessories and back-to-school rental season
Serialized tracking covers the guitars and violins, but most of a music store's SKU count is ordinary retail stock: strings, reeds, picks, cables, method books, and sheet music. That stock doesn't need a serial number or a status workflow it needs a standard reorder point per item, so a bestselling reed size or string gauge doesn't sit out of stock for a week waiting on a manual restock decision.
Back-to-school season (typically late July through September in markets running school band and orchestra programs) is the single biggest demand spike most music stores see all year, and it hits both sides of the business at once: the rental fleet needs to be counted, cleaned, and marked available well before the first pickup date, while accessories tied to school method books (reeds, valve oil, rosin, specific string sets) see a demand jump that a normal reorder point sized for the rest of the year won't cover.
Sizing accessory reorder points from last year's back-to-school sell-through, and running a rental-fleet readiness count a few weeks before pickup day, avoids the two most common seasonal failure modes: a parent turned away because the store is out of reeds for a specific school's method book, and a rental fleet that's short of available units because condition and repair status weren't checked until pickup day itself.
- Standard reorder points for strings, reeds, picks, cables, and sheet music, separate from serialized instrument tracking
- Size back-to-school accessory reorder points from last year's actual sell-through, not the rest-of-year average
- Run a rental-fleet readiness count (available, needs repair, needs cleaning) a few weeks before school pickup dates
- Track accessories tied to specific school method books as their own line, since demand for them is predictable but concentrated in a few weeks
Multiple locations and school rental programs
A music store running a school-district rental program across multiple pickup locations, or operating more than one retail site, benefits from one shared view of which specific instruments are where available at a given location, out on rental, or in for repair rather than each site or program keeping its own separate list.
Music store inventory management across multiple locations means every pickup point and retail site works from the same stock record, so a rental due back at one school pickup location doesn't show as available at another, and a sale at one retail site immediately updates what the other can promise. Transfers between locations, whether a school rental swap or restocking a second retail floor, should be logged at the moment of the physical move so the shared view stays accurate.
- One shared stock view across every retail site and rental pickup location
- Transfers logged at the moment of the physical move, not a periodic reconciliation
- Prevents the same rental unit or trade-in being promised at two locations at once
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”