← Back to Cases
Order Management System ✅ Executed

Lino's Bakery

Next.js 15 | NestJS | Prisma | Puppeteer | Supabase | MUI | JWT | TypeScript

The Challenge

Traditional bakery in João Pessoa serving ~140 active clients (hotels, construction companies, businesses) processed ~35 orders/day using a 100% manual process: handwritten notes on paper, accumulated in binders, then manually transcribed to Excel spreadsheets at the end of each billing cycle. Illegible handwriting caused errors, orders got lost, and closing accounts consumed hours of manual labor.

The Solution

MVP developed in 6 weeks: complete web system with client, product, and order management. Each order automatically generates a PDF receipt via Puppeteer, sent along with the delivery. Trackable history by client, period, and status. Billing reports generated in seconds by filtering period. Monorepo architecture with Next.js 15 frontend and NestJS backend.

Architecture

  • Monorepo Yarn Workspaces + TurboRepo
  • Frontend: Next.js 15 (App Router) + React 18 + MUI
  • Backend: NestJS + Prisma ORM + SQLite (migratable to PostgreSQL)
  • JWT authentication with refresh token + permission-based RBAC
  • PDF generation via Puppeteer (receipts and reports)
  • PDF upload to Supabase Storage with signed URLs
  • Deploy: Render (backend) + Vercel-ready (frontend)
  • REST API documented with Swagger (dev)

Metrics

  • Time to register order: from ~3 min to ~30 sec (-83%)
  • Spreadsheet transcription: eliminated (0 min vs ~2h/cycle)
  • Billing report generation: from ~2h to ~10 sec
  • Estimated savings: ~44h/month of manual work
  • Trackable orders: 100% (vs. lost papers)
  • ~35 orders/day | ~140 active clients

Differentiators

  • Functional MVP in 6 weeks: fast delivery of real value, not just a prototype.
  • Automatic PDF: each order generates a professional receipt, sent with the goods. Client signs and returns.
  • Instant billing report: filter period, generate PDF with all client orders, ready to send.
  • Scalable architecture: monorepo ready to evolve (client portal, mobile app, integrations).
  • Hybrid storage: Supabase in production with local fallback, signed URLs for security.

Results

  • Order process digitized in 6 weeks
  • Zero paper: all digital orders with PDF receipt
  • Automated account closing by period
  • Complete traceability: who ordered, when, how much
  • Foundation for evolution: client self-service portal in development
"From pen and paper to complete system in 6 weeks. Technology that solves, not complicates."

Scale: 6-week MVP | 35 orders/day | 140 clients | ~44h/month saved