Stripe→Postgres sync: force-finalize 8,833 zombie trialing subs
- Assignees
- Unassigned
- Created
- 5/11/2026, 10:34:52 PM
- Source
content/artifacts/toby-state-of-business---nightly-report/b9bfe5ec-9a61-4206-89bf-3257224a21dc/state-of-business-2026-05-18.html
8,833 subscriptions have status='trialing' with trial_end older than 180 days (oldest from 2023). Stripe should have transitioned these to canceled or active long ago. Owner action: (a) re-poll Stripe per subscription_id and reconcile, OR (b) run a one-shot Stripe Sigma reconciliation to bulk-transition them. Until fixed, every trial/funnel calc is polluted by ~8.8K phantom rows. Source: state-of-business-2026-05-18.html, query SELECT count(*) FROM subscriptions WHERE status='trialing' AND trial_end < now() - interval '180 days' = 8833.