Stripe shows the charge, your database has no order. Eight ways the record goes missing between checkout and your orders table, and the query that finds every one.
Stripe took the money but the order never landed in your CRM. Nine places the chain breaks, in the order to check them, plus what a free outside check can and cannot tell you.
Your Stripe webhook passes every test and then fails for real customers. Eight causes, in the order to rule them out, with the exact thing to look at for each.
A working checklist for Supabase security: RLS policies, anon keys, service role leaks, and the mistakes I keep finding in AI-built apps.