Wholesale ERP Built for a Family Distributor
Fiesta Snacks LLC, Orlando FL (wholesale snack distributor)
What they do
Family-owned wholesale distributor of Caribbean snacks and Latin groceries. Sells to 50+ retail accounts across Florida.
The problem
Operations ran across 5 different Google Sheets. Invoices were PDF hell. No real visibility into inventory or profitability. A/P with vendors was a nightmare — 55+ invoices scattered.
What we built
Production ERP
Live inventory, sales tracking, recurring order automation, invoicing, P&L reports, A/R tracking.
Vendor A/P Audit Dashboard
Reconciled 55 invoices + 38 payments + 4 bank statements. 6 PDF section reports. Formal Bank Confirmation Letter generator.
AI Tools Suite
22+ Gemini 2.5 Flash tool-use loops: add_sale, bulk_adjust_stock, web_search, financial_snapshot, generate_purchase_order. One-step operations that took 20 minutes.
Customer Portal
PIN-gated portal. QR codes on invoices link to detailed order history.
Outcome
55 invoices reconciled. A/P visibility went from chaos to clarity. Financial reports run in seconds, not days. The owner can spot a cash-flow problem before it happens.
Engagement model
In-house ongoing, with paid retainer for new features.
Tech stack
- Next.js 16
- Supabase
- Gemini 2.5 Flash
- Google Sheets API
- fal.ai
Ready to stop wasting time on Wix and spreadsheets?
Let's talk. Book a 30-minute discovery call. We'll sketch scope, timeline, and ballpark cost. No obligation. No sales pitch.