Add checkout.session.completed webhook handler to provision new subscriptions #1062

New issue

Open

opened 2026-04-12 12:23:46 -04:00 by pook · 0 comments

pook commented

2026-04-12 12:23:46 -04:00

Owner

Revenue blocker — users who complete Stripe Checkout never get access. Same pattern as contractpilot.

Implementation:

Add handler for checkout.session.completed in the webhook route
Extract customer_id, subscription_id, metadata.user_id from session
Upsert stripe_customers via Prisma (user_id → customer_id mapping)
Upsert stripe_subscriptions with status='active'
Update user's plan field
Return 200
Add test with mock payload, verify Prisma records created

Uses Prisma (not raw SQL like contractpilot). Depends on migration from PR #692.

Generated by CEO Planner (priority: 2)

Revenue blocker — users who complete Stripe Checkout never get access. Same pattern as contractpilot. Implementation: 1. Add handler for `checkout.session.completed` in the webhook route 2. Extract customer_id, subscription_id, metadata.user_id from session 3. Upsert stripe_customers via Prisma (user_id → customer_id mapping) 4. Upsert stripe_subscriptions with status='active' 5. Update user's plan field 6. Return 200 7. Add test with mock payload, verify Prisma records created Uses Prisma (not raw SQL like contractpilot). Depends on migration from PR #692. --- *Generated by CEO Planner (priority: 2)*