1. Problem Context

Affiliate systems are easy to describe at the UI level.

Partners get a referral code, see referred users, and eventually request a payout.

That is not the hard part.

The harder problem is financial correctness:

• When does a referral become a real earning?
• When does that earning …

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 …