Context
PrestaShop orders had to be integrated into a legacy ERP without a modern API.
Problem
Manual re-entry caused delays, workload and avoidable errors.
Solution
A three-stage Python pipeline: order simulation/validation, compliant XML generation, then SFTP delivery with retry logic.
Key lesson
Edge cases should be designed for before production, not after the first incident.