Cancel a Church Subscription
Handle subscription cancellation via Stripe CLI — immediate cancellation vs end-of-period, DB access revocation, voice agent deactivation, and the lifecycle email win-back sequence
Handle subscription cancellation via Stripe CLI — immediate cancellation vs end-of-period, DB access revocation, voice agent deactivation, and the lifecycle email win-back sequence
Index of customer ops runbooks — onboarding, cancellation, refunds, support escalation, claim disputes, church data updates, voice number provisioning, and listing removal
Triage and resolve inbound church support requests — classify by type (billing, access, bug, content), investigate with Supabase + Stripe + Vercel logs, and respond via Gmail
Resolve a PewSearch listing claimed by the wrong person — verify legitimate ownership, transfer the claim record, and communicate the outcome to both parties
Provision a Premium Page manually when automated checkout fails or for founding/manual deals — create the premium_churches record, optionally link a Stripe subscription, and test the page
Consolidate two duplicate church records in the churches table — identify the canonical record, migrate any premium_churches or voice_agent rows, and hide the duplicate
Verify automated onboarding completed after checkout — check premium_churches record, confirm chatbot/voice provisioning, send magic link, and run manual fallback if webhook failed
Issue a full or partial refund via Stripe CLI in live mode — look up the charge, apply the refund, verify in Stripe, and send the customer a confirmation email
Buy a local Twilio number for a church, configure forwarding to the Cartesia voice agent, and create the church_voice_agents row to make the church live on the agent
Set directory_visible=false on a church record to hide it from PewSearch — for closures, duplicates, spam, or church requests — with founder approval required
Correct or update a church's data in the churches table — name, address, phone, website, service times — with safety checks to avoid corrupting the 218K directory