← All work
Manufacturing · Flexography
Multi-Tenant ERP for Label Manufacturing
A real-time, multi-tenant ERP built for the flexography (label printing) industry — replacing spreadsheets and shared drives with a single production system handling orders, scheduling, machine load, and inventory.
Many → 1
Spreadsheets replaced
Multi
Tenants on one deploy
<1s
Realtime sync
Role
Sole engineer · Architecture → build → deployment → ongoing support
Timeline
Initial v1 in ~14 weeks · iterating in production
Stack
Next.jsTypeScriptSupabasePostgreSQLRow-Level SecurityTailwind
The challenge
- Multiple manufacturing units running on Excel + WhatsApp + paper job cards.
- No real-time view of machine load — capacity decisions made by gut feel.
- Order changes silently lost between sales, planning, and the shop floor.
- Each tenant has its own pricing rules, machine roster, and substrate library.
Approach
- Multi-tenant Postgres schema with RLS — strict tenant isolation, single deploy.
- Real-time order + job-card sync over Supabase Realtime to shop-floor screens.
- Auto-scheduler weighing substrate, ink, machine speed, and active job queue.
- Role-aware UI (Owner / Planner / Operator / Sales) on the same codebase.
- Audit log on every state change so dispatch disputes resolve in minutes.
Outcome
- Live shop-floor visibility for the first time — planners stopped calling operators.
- Order-to-dispatch cycle time dropped meaningfully once handoffs went digital.
- Single codebase serves multiple manufacturing units with zero per-tenant forks.