Ran a retail shop for years before building StockPilot, and the thing that finally broke me was losing a repeat customer over a product I thought I had 6 units of. Turned out it was 0 — I just hadn't checked the shelf in 4 days.

Here's what I learned trying to fix this with spreadsheets before building software for it:

1. "I'll check when I remember" always loses. You don't forget because you're careless, you forget because running a shop is 40 things at once. The fix isn't discipline, it's automation.

1. Reorder points beat reorder guesses. Most small shop owners reorder based on vibes ("feels low") instead of a number ("below 5 units, reorder 20"). Set the number once, never think about it again.

1. The real cost isn't the stockout — it's the customer who doesn't come back. One missed sale is $30. One customer who assumes you're unreliable is thousands over their lifetime.

If you're running a single-location shop and still tracking stock by memory or a notebook, that's the exact problem StockPilot solves — real-time shelf tracking with automatic low-stock alerts and reorder lists. No spreadsheets.

Happy to answer questions from anyone dealing with the same headache.