Three Stores, One Source of Truth
The client had grown from one flagship store to three locations across the DFW metro in under six years — fast growth with slow infrastructure to match. Each store ran its own point-of-sale system, maintained its own bound book independently, and ordered inventory on gut instinct rather than data. Transfer coordination between locations was done by phone call and spreadsheet.
The owner knew he was hemorrhaging money on duplicate stock and lost transfers, but had no visibility into how bad it actually was. An upcoming ATF compliance inspection forced the issue to the top of the priority list.
- Conducted a full operational audit across all three locations over 10 business days — shadowing staff, reviewing bound books, mapping transfer workflows, and stress-testing POS data against physical inventory counts
- Identified $218K in dormant and duplicated inventory and a 22% discrepancy rate between POS records and bound book entries
- Designed and implemented a unified inventory architecture using Orchid POS, integrating ATF-compliant A&D record-keeping with real-time multi-location stock visibility
- Established standardized inter-store transfer SOP with same-day digital A&D logging requirements and manager sign-off checkpoints
- Delivered a 3-day staff training program across all locations and built a compliance dashboard for weekly manager reviews
- ATF compliance inspection passed with zero findings or recommendations — a first for the business in its history
- Inventory discrepancy rate dropped from 22% to under 8% within 60 days, and to 4% by month six
- Interstore transfers increased 34% as staff gained confidence in the new system, reducing out-of-stock situations at high-demand locations
- Owner transitioned from daily firefighting to a weekly 45-minute dashboard review — a fundamental shift in how the business was managed
- Two store managers subsequently promoted to an operational director role the business previously couldn't justify creating
“We went from hoping our books were right to knowing they were right. That's not a small thing in this industry — that's the difference between keeping your license and losing it.”
The Diagnostic That Changed Everything
The 10-day operational audit revealed that the inventory problem wasn't a technology problem — it was aprocess accountability problem. Each store had developed its own informal habits around transfers and entries that made perfect sense locally and created chaos systemically. The fix wasn't just a new POS. It was standardized behavior enforced by a system that made the right action easier than the wrong one. The technology was the enabler. The SOP was the solution.
