Project Description
I need a complete inventory ingestion and synchronisation layer for my B2B mobile application. The core of the project is a set of secure, well-documented REST APIs that can pull stock data from DRC and other external sources, as well as from custom third-party inventory platforms we already work with.
Key requirements
• Real-time and incremental sync of product details, supplier information and stock levels.
• Custom validation rules plus structured error handling and logging so any bad payloads are quarantined and surfaced with clear messages.
• Field-by-field data mapping and normalisation to keep SKUs, supplier IDs and quantity formats consistent across all sources.
• A supplier access pipeline that relies on API keys or tokens, supports role-based permissions, and encrypts data in transit and at rest.
• Centralised logging, monitoring dashboards and alerting hooks for failure events.
Excel integration
On the web front end I want a lightweight JavaScript component that lets staff drag-and-drop an Excel sheet, validates it locally, then pushes only the delta rows through the same API pipeline. The same capability must be exposed inside the existing Android and iOS apps so users can perform uploads and see sync status from their phones.
Deliverables
1. Production-ready API suite with full Swagger / OpenAPI docs
2. DRC and third-party connectors working end-to-end
3. Web Excel uploader + mobile upload module
4. Source code, unit/integration tests, and deployment scripts (Docker/Kubernetes preferred but not mandatory)
Acceptance will be based on automated test cases proving data integrity, latency under load, and the completeness of the error logs.