Retail Solutions
Supplier Stock Visibility Platform
A cloud-based stock monitoring platform connecting suppliers with customers and multiple branches.
Challenge
Blind supply chain
Branch POS data lived in silos. Suppliers could not see what customers held or sold in time to allocate stock.
Solution
Cloud visibility layer
Sync from branch SQL Server into a Django API and PostgreSQL model, with dashboards for allocation, sales sync, and reporting.
Outcome
Live branch insight
Suppliers see stock and sales across customer branches without manual spreadsheet consolidation.
Architecture
Branch POS
SQL Server
Sync Service
Django API
PostgreSQL
Web Dashboard
Interface overview
Add screenshots to assets/images/projects/supplier-stock-*.png.
Supplier dashboard — customers, branches, allocated stock
Branch sales sync and real-time reporting views
Tech stack & highlights
Python, Django, PostgreSQL, SQL Server, Windows Service, REST API.
- Supplier dashboard
- Customer branch management
- Stock allocation
- Sales synchronization
- Real-time reporting