Update affiliate commission record from new paid order

Paid orders aren't linked to affiliates, delaying partner payouts and reconciliation. Write commission details to your affiliate table when a paid order arrives so payouts reconcile same day.