Function handleSubscriptionDeleted

apps/sim/lib/billing/webhooks/subscription.ts:280–470

(
  subscription: {
    id: string
    plan: string | null
    referenceId: string
    stripeSubscriptionId: string | null
    seats?: number | null
    periodStart?: Date | null
    periodEnd?: Date | null
  },
  stripeEventId?: string
)

 * webhook retries from scratch.
 */
export async function handleSubscriptionDeleted(
  subscription: {
    id: string
    plan: string | null
    referenceId: string
    stripeSubscriptionId: string | null
    seats?: number | null
    periodStart?: Date | null
    periodEnd?: Date | null
  },
  stripeEventId?: string
) {
  const stripeSubscriptionId = subscription.stripeSubscriptionId || ''

  logger.info('Processing subscription deletion', {
    stripeEventId,
    stripeSubscriptionId,
    subscriptionId: subscription.id,
  })

  // Fall back to the subscription DB id when we don't have an event id
  // (e.g. called outside the Stripe webhook context). Still dedupes a
  // single subscription's deletion, just not event-granular.
  const idempotencyIdentifier = stripeEventId ?? `sub:${subscription.id}`

  try {
    await stripeWebhookIdempotency.executeWithIdempotency(
      'subscription-deleted',
      idempotencyIdentifier,
      async () => {
        const totalOverage = await calculateSubscriptionOverage(subscription)
        const stripe = requireStripeClient()

        if (isEnterprise(subscription.plan)) {
          await resetUsageForSubscription({
            plan: subscription.plan,
            referenceId: subscription.referenceId,
            periodStart: subscription.periodStart ?? null,
            periodEnd: subscription.periodEnd ?? null,
          })

          const dormantResult = await transitionOrganizationToDormantState(
            subscription.referenceId,
            subscription.id
          )

          logger.info('Successfully processed enterprise subscription cancellation', {
            subscriptionId: subscription.id,
            stripeSubscriptionId,
            ...dormantResult,
          })

          captureServerEvent(subscription.referenceId, 'subscription_cancelled', {
            plan: subscription.plan ?? 'unknown',
            reference_id: subscription.referenceId,
          })

          return { totalOverage: 0, kind: 'enterprise' as const }