Wholesale Distribution
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 ship the real thing?
Start with a Digital Strategy Session — $399, 60 min, bilingual. You leave with a written plan and a scoped quote. The $399 is credited 100% toward your project. We hold only 5 active custom slots at a time.
Or email us at hello@luxorusstudio.com