Problem
A fashion brand with a growing production operation was managing everything across spreadsheets and paper records. Tracking was manual, payments were calculated by hand and prone to disputes, and reports could break from a single wrong entry. There was no central place to see what was actually happening on the production floor.
Approach
Two deliberate phases. Phase 1: replaced scattered sheets and paper with a single structured Google Sheet — garment-level tracking via a unique key combining Ticket ID, Product Type, and Item Number. Built a centralised rate database; used Apps Script to automate payment calculations and weekly summaries. Designed real-time reports for items produced per category, backlog status, and average production time. Phase 2: translated the validated workflow into a Next.js + Supabase web application. PostgreSQL handles structured data; Supabase Auth manages authentication; Row Level Security enforces role-based access at the database level — production, QC, accounts, and admin each see and do only what they're permitted.
Result
Live system tracking every garment, every tailor, and every payment in real time. Quote from client: 'We went from chasing payments in spreadsheets to having a live system where every garment, every tailor, and every payment is tracked in real time.'
