🚀 Stripe Renewal Cron Started

📊 Total Records: 1
🔍 Checking Subscription: sub_1R02p2JSNw06INmp8eSGV1RS
📦 Raw Response:
{
  "id": "sub_1R02p2JSNw06INmp8eSGV1RS",
  "object": "subscription",
  "application": null,
  "application_fee_percent": null,
  "automatic_tax": {
    "disabled_reason": null,
    "enabled": false,
    "liability": null
  },
  "billing_cycle_anchor": 1743953304,
  "billing_cycle_anchor_config": null,
  "billing_mode": {
    "flexible": null,
    "type": "classic"
  },
  "billing_thresholds": null,
  "cancel_at": null,
  "cancel_at_period_end": false,
  "canceled_at": null,
  "cancellation_details": {
    "comment": null,
    "feedback": null,
    "reason": null
  },
  "collection_method": "charge_automatically",
  "created": 1741361304,
  "currency": "usd",
  "current_period_end": 1807025304,
  "current_period_start": 1775489304,
  "customer": "cus_RtqUrxGA7LUjqN",
  "customer_account": null,
  "days_until_due": null,
  "default_payment_method": null,
  "default_source": null,
  "default_tax_rates": [],
  "description": null,
  "discount": null,
  "discounts": [],
  "ended_at": null,
  "invoice_settings": {
    "account_tax_ids": null,
    "issuer": {
      "type": "self"
    }
  },
  "items": {
    "object": "list",
    "data": [
      {
        "id": "si_RtqWpjlD8FaiIL",
        "object": "subscription_item",
        "billing_thresholds": null,
        "created": 1741361304,
        "current_period_end": 1807025304,
        "current_period_start": 1775489304,
        "discounts": [],
        "metadata": {},
        "plan": {
          "id": "price_1H4XmLJSNw06INmpt4J6Q0dc",
          "object": "plan",
          "active": true,
          "aggregate_usage": null,
          "amount": 1999,
          "amount_decimal": "1999",
          "billing_scheme": "per_unit",
          "created": 1594670253,
          "currency": "usd",
          "interval": "year",
          "interval_count": 1,
          "livemode": true,
          "metadata": {},
          "meter": null,
          "nickname": "Yearly",
          "product": "prod_HdpR3UnTmYrwxT",
          "tiers": null,
          "tiers_mode": null,
          "transform_usage": null,
          "trial_period_days": 30,
          "usage_type": "licensed"
        },
        "price": {
          "id": "price_1H4XmLJSNw06INmpt4J6Q0dc",
          "object": "price",
          "active": true,
          "billing_scheme": "per_unit",
          "created": 1594670253,
          "currency": "usd",
          "custom_unit_amount": null,
          "livemode": true,
          "lookup_key": null,
          "metadata": {},
          "nickname": "Yearly",
          "product": "prod_HdpR3UnTmYrwxT",
          "recurring": {
            "aggregate_usage": null,
            "interval": "year",
            "interval_count": 1,
            "meter": null,
            "trial_period_days": 30,
            "usage_type": "licensed"
          },
          "tax_behavior": "unspecified",
          "tiers_mode": null,
          "transform_quantity": null,
          "type": "recurring",
          "unit_amount": 1999,
          "unit_amount_decimal": "1999"
        },
        "quantity": 1,
        "subscription": "sub_1R02p2JSNw06INmp8eSGV1RS",
        "tax_rates": []
      }
    ],
    "has_more": false,
    "total_count": 1,
    "url": "/v1/subscription_items?subscription=sub_1R02p2JSNw06INmp8eSGV1RS"
  },
  "latest_invoice": "in_1TJF5IJSNw06INmpGHvNff5G",
  "livemode": true,
  "managed_payments": {
    "enabled": false
  },
  "metadata": {},
  "next_pending_invoice_item_invoice": null,
  "on_behalf_of": null,
  "pause_collection": null,
  "payment_settings": {
    "payment_method_options": null,
    "payment_method_types": null,
    "save_default_payment_method": "off"
  },
  "pending_invoice_item_interval": null,
  "pending_setup_intent": null,
  "pending_update": null,
  "plan": {
    "id": "price_1H4XmLJSNw06INmpt4J6Q0dc",
    "object": "plan",
    "active": true,
    "aggregate_usage": null,
    "amount": 1999,
    "amount_decimal": "1999",
    "billing_scheme": "per_unit",
    "created": 1594670253,
    "currency": "usd",
    "interval": "year",
    "interval_count": 1,
    "livemode": true,
    "metadata": {},
    "meter": null,
    "nickname": "Yearly",
    "product": "prod_HdpR3UnTmYrwxT",
    "tiers": null,
    "tiers_mode": null,
    "transform_usage": null,
    "trial_period_days": 30,
    "usage_type": "licensed"
  },
  "quantity": 1,
  "schedule": null,
  "start_date": 1741361304,
  "status": "past_due",
  "tax_percent": null,
  "test_clock": null,
  "transfer_data": null,
  "trial_end": 1743953304,
  "trial_settings": {
    "end_behavior": {
      "missing_payment_method": "create_invoice"
    }
  },
  "trial_start": 1741361304
}
⚠️ Inactive Status: past_due
UPDATE tbl_customer_subscriptions SET ack_status = ack_status + 1, is_cancelled = 0, cancelled_at = NULL, renewal_date = '2026-04-16 11:12:42' WHERE id = 11822
✅ Status Updated (ack_status = 1, retry_at = 2026-04-16 11:12:42)

✅ Cron Completed