The problem
The client sells in several countries through different courier companies. Orders arrive from Shopify. Supplier data arrives in whatever format that country uses: CSV one day, Excel the next, XML from a courier abroad, with local quirks such as Croatian currency formatting, missing images and inconsistent reference data. All of it had to land in one place, linked and auditable, with warehouses and packages tracked end to end. By hand, the work did not scale past a few countries.