Retail POS & Service-Log Platform
Unified Sales, Inventory & Service Tracking for Retail Operations
Spreadsheet replacement built around how daily retail operators actually work.
Context
Challenge
Sales, service revenue, inventory, and staff accountability lived in disconnected spreadsheets.
Solution
A unified POS, file-style inventory hub, reporting system, and audit layer brought retail operations into one platform.
Signal
Registering the entire product catalog now takes about an hour, replacing stock re-keyed by hand out of separate Excel workbooks
Preview
Constraints
- Replace Excel workflows without slowing daily retail and service operations.
- Keep stock, service income, sales, and staff accountability connected.
- Support role-based permissions, audit trails, and exportable reporting.
Workflows
- File explorer inventory with inline editing
- Dual-mode product and service POS
- Executive reports, Excel export, and staff activity audit
Features
A unified POS, file-style inventory hub, reporting system, and audit layer brought retail operations into one platform.
File Explorer Inventory
Uses a category and sub-category folder paradigm with spreadsheet-like inline editing, condition-based visual states, and global cross-folder search.
Dual-Mode POS
Logs both product sales with real-time inventory deduction and service revenue through one interface with mobile-optimized input.
Role-Based Access Control
Superadmins see the full operation while assistants see only their own sales and activity, with ownership-based edit and delete permissions.
Executive Reports & Excel Export
Delivers sales breakdowns, inventory valuation, revenue analysis, consultation counters, date filtering, and one-click Excel export.
Architecture
Built as a decoupled React frontend with Vite, TypeScript, Tailwind CSS, and Zustand, backed by an Express. js and Node. js API. PostgreSQL with Prisma ORM provides transactional data integrity. JWT authentication supports PIN-based quick login with rolling sessions.
Outcomes
~1 hour
Full Stock Registration
Registering the entire product catalog now takes about an hour, replacing stock re-keyed by hand out of separate Excel workbooks
6-10
Spreadsheets Retired
Disconnected Excel workbooks for stock, sales, service revenue, and categorization consolidated into a single system
3
Branches Unified
Three retail locations reporting into one inventory, sales record, and audit trail instead of separate local files
Full Audit
Staff Accountability
Every action is stamped with who and when, with ownership-based permissions and exportable activity logs
* The client name is confidential. This project is presented as an anonymized retail electronics business while preserving the system architecture, workflows, and outcomes.