Connecting store, ecommerce and ERP order data on AWS
- Situation
- A retailer reconciles online and in-store orders against its ERP with overnight file transfers, so stock and refund data is a day behind.
- Approach
- We publish order, return and inventory events from the commerce platform and point-of-sale system to EventBridge, process them with Lambda, and post them to the ERP through its APIs. Failed messages go to a dead-letter queue with alerts to the support team.
- Outcome
- Stock and refund data reach the ERP during the day, and support staff can see and replay any message that failed.