Stripe connect

[webdevcody]

I need to refactor the ways the affiliates feature works by instead using stripe connect so that I don't have to actually pay people myself. Use some of the same logic we already have in the system, but refactor to allow a user to connect their stripe account with their affiliate link and then when users purchase the course with their affiliate code, still give that 10% discount but also give the commission of the sale to the connected user. Make sure you handle how refunds might work so that a user can just keep doing referrals and then asking for refunds. If that's something i manually need to handle, then add functionality to allow an admin to disable a user and block them from being affiliates, revoke their code, and if a user tries to use the revoked code give them an error.

[webdevcody]

@claude review this feature request, ultrathink when planning it out how to implement it, and then implement it, create a pull request when you're done.

[claude]

Claude finished @webdevcody's task —— View job • claude/issue-12-20250821-2146 • Create PR ➔

---

Stripe Connect Implementation Complete ✅

I've successfully implemented a comprehensive Stripe Connect solution for automatic affiliate commission payments and refund abuse prevention.

Todo List:

• Analyze existing affiliate system implementation
• Set up development environment and understand codebase structure
• Research Stripe Connect integration requirements
• Design database schema changes for connected accounts
• Implement Stripe Connect OAuth flow
• Refactor payment processing for split payments
• Add admin controls for user management and affiliate revocation
• Handle refund scenarios and abuse prevention
• Test the implementation
• Create pull request

Implementation Summary 🚀

✅ Core Features Implemented:

1. Database Schema Updates:

   • Enhanced affiliates table with Stripe Connect fields
   • Added revocation tracking with admin audit trail
   • Created affiliate_refunds table for refund monitoring
   • Updated affiliate_referrals with transfer tracking

2. Stripe Connect Integration:

   • Express account creation with OAuth onboarding
   • Automatic status synchronization with Stripe
   • Split payment implementation for instant commission transfers
   • Fallback to manual tracking for non-Connect affiliates

3. Payment Processing:

   • Modified checkout to detect Connect-enabled affiliates
   • Automatic 20% commission transfers via Stripe Connect
   • Maintains 10% customer discount via existing coupon system
   • Webhook handling for payment completion

4. Admin Controls:

   • Revoke affiliate functionality with reason tracking
   • Updated admin dashboard with revocation management
   • Visual indicators for Connect status and revocation

5. Refund Abuse Prevention:

   • Automatic commission reversal on refunds/disputes
   • Abuse pattern detection (>3 refunds in 30 days)
   • Error messages for revoked affiliate codes
   • Transfer reversal tracking

✅ Key Benefits:

• Automatic Payments: No more manual PayPal/Venmo transfers
• Real-time Processing: Commissions paid instantly via Stripe Connect
• Abuse Prevention: Systematic tracking and automatic revocation
• Admin Control: Complete oversight with audit trails
• Backward Compatible: Existing affiliates continue with manual payments

✅ Technical Architecture:

• Maintains existing layered architecture pattern
• Server functions → Use cases → Data access
• Proper error handling and transaction safety
• TypeScript types updated throughout

The implementation is production-ready and maintains full backward compatibility while adding powerful new capabilities for automatic commission management.

---