RevenueCat Webhook Processing Diagram

Event type -> effect

INITIAL_PURCHASE / RENEWAL / REFUND_REVERSED: active (trialing if TRIAL) + paid ledger row
UNCANCELLATION / PRODUCT_CHANGE / SUBSCRIPTION_EXTENDED / PAUSED: active, no ledger row
CANCELLATION: cancel_at_period_end=true (refund-like: expired + refunded row)
REFUND / EXPIRATION: expired; BILLING_ISSUE: past_due until grace expiry
TRANSFER: moves or merges the row to the new parent; NON_RENEWING_PURCHASE and others: no-op

Where paid events are lost

Ghost parent: $RCAnonymousID with no numeric alias is acked and never stored (20 purchases, 18-21 Oct)
Claim is written before apply; if the release DELETE fails or the worker dies, retries see already_processed
Skipped guards (retired plan, Stripe past_due, entitlement mismatch) all return 200
Transaction-id unique race also returns 200 and keeps the claim

Sandbox router

/sandbox-api/payments/webhooks/revenuecat is identical except the secret
Same apply_revenuecat_event, same tables, no environment check