Create affiliate referral record from each paid order

Paid orders can hide affiliate IDs in custom attributes, leaving referrals untracked and slowing payout reconciliation. Create referral records automatically so affiliate managers have accurate entries before the next payout.