← All Projects Case Study: SaaS Replacement

Custom Inventory System

A specialty food distributor paying $2,400/mo for Fishbowl + two other tools now runs on a single custom system. Team adoption jumped from 40% to 95%.

Industry
Specialty Food Distribution
Timeline
4 Build Days
Investment
$4,000
Annual Savings
$28,800

The Problem

The company distributed artisan food products across 200+ retail locations. They were running Fishbowl for inventory ($1,200/mo), a separate order management tool ($800/mo), and Airtable for tracking vendor relationships and reorder schedules ($400/mo). Three different systems that didn't talk to each other.

The warehouse team used Fishbowl reluctantly — it had 50+ features they didn't need, and the ones they did need were buried under menus designed for manufacturing companies, not distributors. Only 40% of the team actually logged in regularly. The rest used paper clipboards and a whiteboard, then someone would "update the system" at the end of the week. By then, the data was already stale.

Before

  • Fishbowl Inventory: $1,200/mo (built for manufacturing)
  • Separate order management tool: $800/mo
  • Airtable for vendor tracking: $400/mo
  • 40% team adoption — rest used paper + whiteboard
  • Inventory counts always a week behind
  • Stockouts on popular items, overstock on slow movers

After

  • Single app: inventory + orders + vendor tracking
  • Mobile-first design for warehouse floor
  • Barcode scanning via phone camera
  • Auto-reorder alerts based on actual velocity
  • 95% team adoption within first 2 weeks
  • Real-time inventory counts, always accurate

How It Was Built

Day 1: Friction Audit + Core Data Model. Spent half a day at the warehouse. Watched the team work. Noted every moment someone switched between systems, grabbed a clipboard, or said "I'll update that later." Built the PostgreSQL schema that evening — products, locations, orders, vendors, and reorder rules all in one database.

Day 2: Inventory Management Core. Built the product catalog, receiving workflow, and stock level tracking. The key insight: the warehouse team thinks in terms of "what came in today" and "what's running low" — not inventory theory. So the UI mirrors their actual workflow: Receive > Count > Pick > Ship. Four screens, not forty.

Day 3: Orders + Vendor Integration. Added the order management flow (incoming orders auto-decrement inventory) and vendor reorder system. Implemented velocity-based alerts: if a product's sell rate means it'll run out in < 5 days, flag it amber. Under 2 days, flag it red. Connected to their existing supplier email contacts for one-click reorder requests.

Day 4: Mobile, Barcode Scanning, Deploy. Made every screen mobile-first — warehouse staff use phones, not desktops. Added barcode scanning via the phone camera for quick receiving and picking. Deployed, migrated existing product data from Fishbowl export, and trained the team in a 30-minute session.

Results

$28.8K
annual SaaS cost eliminated
95%
team adoption (was 40%)
73%
reduction in stockouts

The Takeaway

Fishbowl is built for complex manufacturing operations with BOM management, work orders, and multi-warehouse routing. This distributor needed: what do we have, what's coming in, what's going out, and what do we need to reorder. That's it. The custom system does exactly that — nothing more, nothing less — and the team loves it because it mirrors how they actually work instead of forcing them into someone else's workflow. ROI: the tool pays for itself every 7 weeks.

Build Something Like This See More Work