Loading case study...
Archive vol.2
Loading case study...
Inventory Management · Prototype
A phone-first inventory management system designed for small businesses. Tracks stock movements, sales, purchases, and suppliers.
Stockly is a mobile-first inventory management system built to replace pen-and-paper tracking for small retail businesses in Vietnam. It provides real-time visibility into stock levels, sales, and supplier orders.
Small business owners lose significant revenue due to stockouts, overstocking, and unrecorded shrinkage. Existing enterprise ERPs are too complex and expensive, while basic spreadsheet solutions lack mobile accessibility and real-time syncing.
Retail shop owners, pharmacy managers, and small warehouse operators who need to track inventory on the go using their smartphones.
Sole Architect & Full-Stack Engineer
The design prioritizes speed and thumb-friendly navigation. High-contrast UI for outdoor use, large tap targets, and a dashboard that surfaces critical alerts (low stock) immediately upon opening the app.
The system uses a modular architecture. The frontend is a Next.js PWA for offline capabilities. The backend is designed as a multi-tenant API, allowing a single deployment to serve multiple independent businesses with isolated data.
Implemented a complex state machine for stock movements (e.g., a single "sale" event automatically decrements inventory, records revenue, and logs the transaction). Built a custom data-grid component optimized for mobile touch scrolling.
The primary challenge was designing the database schema to support the planned multi-business architecture without sacrificing query performance for single-business views. Solved by implementing Row Level Security (RLS) in PostgreSQL.
All API routes are protected by middleware checking session tokens. Database queries are heavily indexed. The PWA caches critical assets using Workbox, allowing the app to load instantly even on slow 3G networks.
The frontend prototype is fully functional with local state. The user can create products, record sales, and view reports. The backend API and database integration are currently being built.
Designing for mobile-first forced me to ruthlessly prioritize features. I learned that small business owners don't need complex analytics; they need to know what to reorder today.
Complete the backend API integration. Implement barcode scanning using the device camera. Add SMS notifications for low-stock alerts.
Core UI and local state management are complete. Multi-business backend architecture is currently in development.
Back to selected work