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