Fashion · ERP ↔ shop
Three systems, one set of data — without handwork
Apparel Magic and the shop keep stock, prices and orders in sync; every discrepancy lands in the log instead of an inbox.
0
manual imports since go-live
- Year
- 2023
- Client
- Joyce & Girls
- Role
- Developer · middleware and sync logic
- Areas
- System integration
AI-generatedThe starting point
The ERP system Apparel Magic needed to be connected to Breuninger — through the marketplace platform TB.One. The data formats didn't line up, and both stock and orders had to stay current in both directions.
What was built
A relational middleware database that reads incoming order data, maps it to the ERP's structure and passes it on. Plus end-to-end automation of stock and order synchronization over API connections — in both directions, with no manual cleanup.
Every discrepancy is logged instead of overwritten.
01What you touch
02Where the data sits
03How it is operated
Stack
- API
Python REST-APIs
- Data
SQL / MariaDB
- Connected
Apparel Magic TB.One Shopify
Result
Three systems in sync, without manual import and export steps.
