1. Problem Context

E-commerce teams often rely on spreadsheets as their operational source of truth. Meanwhile, e-commerce platforms expose order data through APIs and webhooks.

Manual exports introduce:

• Data drift
• Operational overhead
• No retry semantics
• No consistency guarantees

The objective was …