Case Studies
Real problems. Real solutions.
Detailed examples of how messy operations became coherent systems. Each case covers the situation, solution architecture, and results.
From Access chaos to real-time visibility across 200+ concurrent projects
The Situation
A leading FF&E manufacturer serving hospitality and commercial clients had grown rapidly, but their systems hadn't kept pace. Order data lived in Sage 300. Production schedules were in Excel. Installation tracking was in a Microsoft Access database that only two people understood.
Key Pain Points
- 1No single source of truth for project status
- 215+ hours/week spent compiling status reports
- 3Installation scheduling conflicts discovered too late
- 4Critical Access database was a single point of failure
The Solution
Built a modern data backbone in Supabase that connected Sage 300, factory operations, and field installation—without replacing the ERP or disrupting daily operations.
Hierarchical schema with full audit trail and RLS by team
Automated sync from Sage 300 and webhook-driven updates
Production teams scan units through stations in real-time
Mobile-first installer app with offline sync
85%
Reduction in manual entry
200+
Real-time project visibility
"For the first time in our company's history, we can see exactly where every piece is—from factory floor to final installation. The ROI was obvious within the first month."
VP of Operations
Zero missed installation windows across 15 hotel openings
The Situation
A hospitality development firm was managing FF&E installation for 15 new hotel properties scheduled to open over 18 months. Each property had thousands of items. The existing process: Excel trackers emailed weekly, WhatsApp for field communication, and a shared drive of photos nobody could find.
Key Pain Points
- 1No real-time visibility into installation progress
- 2Punch items discovered weeks later
- 3Field teams wasted time hunting for schedules
- 4Executive reporting required days of compilation
The Solution
An orchestration system centered on Airtable for tracking, Glide-based mobile apps for field teams, and automated alerting for exceptions.
Property → Room → Item hierarchy with status tracking
Photo capture, punch logging, offline sync
Automated routing and escalation
Program-wide view with drill-down
0
Missed install windows
70%
Punch resolution reduction
"The visibility changed how we ran the entire program. We went from reactive firefighting to actually managing the rollout."
Director of Project Management
90% reduction in order processing errors
The Situation
A regional distribution company handled 200+ orders daily. Orders arrived via email PDFs, which someone manually re-keyed into the warehouse system. Errors discovered at shipping were common. Customer service spent significant time tracking status.
Key Pain Points
- 1Manual re-entry of every order
- 2High error rate on items and quantities
- 3No order status visibility until shipment
- 4No early warning for inventory issues
The Solution
A webhook-driven order intake system that parses incoming orders, validates against master data, creates WMS entries via API, and flags exceptions for review.
PDF parsing and data extraction
Central order database with history
Item and inventory validation
Self-service order status lookup
90%
Reduction in errors
60%
Fewer status inquiries
"We used to spend half our day re-keying orders. Now the system handles routine stuff and we focus on exceptions that need human judgment."
Operations Manager
Have a similar challenge?
If your operations are dealing with disconnected systems, manual processes, or legacy technology—let's talk about what's possible.