Case Study
Inventory, Sales Integration and Royalty Management
Designed and developed a business-critical platform that centralised product, sales, stock, and royalty data across multiple external systems. The goal was to replace fragmented reporting and reconciliation work with one trusted operational source.
Back to all projectsProblem Context
Dear Inventory, Xero, and EDI-driven ordering data each had their own structure and assumptions. The business needed a consistent view across sales, stock, catalogue items, SKU registration, and royalty calculations. Without that, reporting and reconciliation were slow, fragile, and error-prone.
What I Did
- Architected the core application and data model around products, SKUs, catalogue items, and royalty structures.
- Integrated multiple external systems and normalised their differing data shapes into a coherent schema.
- Built dynamic SKU and catalogue registration logic to keep pace with changing product ranges.
- Implemented pattern-driven royalty logic and reporting workflows for operational and financial visibility.
Why This Mattered
This was not a simple CRUD build. The real value came from understanding how the organisation operated, then encoding that operational reality into repeatable workflows the business could trust for reporting, royalties, and catalogue growth.
Project Themes
- Schema and model design
- API ingestion workflows
- Cross-system reconciliation
- Royalty pattern engines
- Business-specific reporting
Why It Matters
A good system reduces reconciliation, not just clicks
The main achievement here was turning fragmented operational data into something dependable enough to guide reporting, financial decisions, and day-to-day catalogue growth.