Internal Business Management Platform
Halcy Hijab Admin Dashboard
“Turning spreadsheets and WhatsApp threads into one operational system.”
- Role
- Software Engineer & Product Manager
- Year
- 2025–2026
- Category
- Web Development, Product Management, Business
Project Overview
An internal dashboard designed to centralize Halcy Hijab's operational workflows that previously depended on spreadsheets, WhatsApp, and separated manual records. Because Ni'mah also runs the business, the requirements came from lived operational pain rather than a stakeholder document.
The Problem
Orders arrived via chat, stock lived in spreadsheets, and pricing tiers were tribal knowledge. Every question — “what's in the warehouse?”, “which invoices are open?” — required manual cross-referencing.
The Solution
A Next.js application on Supabase/PostgreSQL that models the business directly: products with variants and tiered pricing, warehouse stock, orders and order items, warehouse and production order sources, stock-out records, and invoice workflows — all behind one authenticated admin interface.
Project Gallery
What I Owned
- Designed the PostgreSQL schema from real operational workflows
- Built the Next.js/TypeScript application and admin tools
- Implemented Supabase authentication and data access
- Created the business performance dashboard views
- Deployed and iterated on Vercel
- Acted as both product manager and the toughest user
Before → After
Before: manual spreadsheets, separated records, WhatsApp-based coordination, and stock that was hard to monitor.
After: one centralized operational system with structured product data, consistent order records, and stock that can be checked in seconds.
Architecture
User Interface → Next.js Application → Supabase Authentication → PostgreSQL Database → Business Operations. The flow is deliberately boring: a well-modeled relational core with a thin, fast admin UI on top.
Key Learning
Translating a real business into tables is product work: every schema decision (is a stock-out an order type or its own record?) is really a decision about how the business thinks.