Custom Affiliate System on Railway

My website is already live on the Railway hosting platform and now needs a full-featured affiliate system that works much like AffiliateWP. Every partner must be able to earn a different commission rate—some higher, some lower—so the logic has to let me set unique percentages manually for each individual affiliate.

Key features I have to see from day one:

• Affiliate dashboard – each partner logs in to view personal stats, payouts, and creative assets.
• Referral link tracking – unique, auto-generated URLs (or coupon codes) that record clicks and conversions in real time.
• Commission reporting – clear, exportable reports showing earnings by date range, status, and affiliate.

Additional notes
• I’ll define commission rates myself inside an admin panel; no blanket or global percentage.
• The solution must plug in cleanly with the existing Railway-deployed stack and database without forcing a big rewrite.
• Accuracy is critical: tracked referrals must match the payment gateway records so I can reconcile payouts with confidence.

Acceptance criteria
1. I can create, edit, and disable affiliates and their individual commission rates from an admin screen.
2. A new affiliate receives a working referral link immediately after creation.
3. Dashboard numbers (clicks, conversions, commissions) update within 60 seconds of an event.
4. Reports export to CSV and match the raw database values.
5. Your code is documented and deploys to Railway with a single command.

If you’ve built custom affiliate or referral modules before—especially on Node.js, Next.js, or similar stacks hosted on Railway—this should be straightforward. Let’s get it running smoothly so I can start inviting partners right away.