Wholesale / Retail · Fooddelivered
Wholesale ↔ Retail Inventory System
Stock management system linking a Korean food wholesaler and retailer, integrated with Xero for accounting sync.
- Sync direction
- Wholesaler ↔ Retailer ↔ Xero
- Stack depth
- Spring Boot + AWS + MySQL
- Status
- Delivered (2022)
Timeline: ~12 months (2021-12 → 2022-12)Stack:JavaSpring BootAWSMySQL
Context
A Korean food importer / wholesaler in Australia needed their wholesale stock to stay in sync with a retail arm, and with Xero for accounting — without manual double entry.
Challenge
- Wholesaler and retailer operated as separate entities with separate stock books
- Accounting (Xero) was a third source of truth, edited by yet another team
- Manual reconciliation caused stockouts, over-orders, and month-end pain
Solution
A Spring Boot + AWS + MySQL inventory system with three-way sync:
- Wholesale stock → retailer stock (transfer events)
- Retail sales → wholesale replenishment signals
- All inventory movements → Xero journal entries via the Xero API
- JavaScript front-end for warehouse and back-office staff
Results
Delivered in 2022. Month-end reconciliation went from a multi-day spreadsheet exercise to a one-screen check.
What this proves
Multi-entity ERP-style integrations (custom stack + accounting + retail POS) are deliverable for SMBs — at a fraction of enterprise ERP costs.