🚀 Stripe Renewal Cron Started

📊 Total Records: 2
🔍 Checking Subscription: sub_1UJ1RLJSNw06INmpH4g7EAnR
📦 Raw Response:
{
  "id": "sub_1UJ1RLJSNw06INmpH4g7EAnR",
  "object": "subscription",
  "application": null,
  "application_fee_percent": null,
  "automatic_tax": {
    "disabled_reason": null,
    "enabled": false,
    "liability": null
  },
  "billing_cycle_anchor": 1790213231,
  "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,
    "feedback_option": null,
    "reason": null
  },
  "collection_method": "charge_automatically",
  "created": 1790213231,
  "currency": "usd",
  "current_period_end": 1795483631,
  "current_period_start": 1792805231,
  "customer": "cus_VJekHwiIqRiqxz",
  "customer_account": null,
  "days_until_due": null,
  "default_payment_method": "pm_1UJ1RKJSNw06INmpix1Y6eKz",
  "default_source": null,
  "default_tax_rates": [],
  "description": null,
  "discount": {
    "id": "di_1UJ1RLJSNw06INmp7Gyg59Z4",
    "object": "discount",
    "checkout_session": null,
    "coupon": {
      "id": "VPIFALLMONTHLY",
      "object": "coupon",
      "amount_off": null,
      "created": 1788845296,
      "currency": null,
      "duration": "repeating",
      "duration_in_months": 3,
      "livemode": true,
      "max_redemptions": null,
      "metadata": {},
      "name": "VPIFALL",
      "percent_off": 50.0,
      "redeem_by": null,
      "times_redeemed": 79,
      "valid": true
    },
    "customer": "cus_VJekHwiIqRiqxz",
    "customer_account": null,
    "end": 1798075631,
    "invoice": null,
    "invoice_item": null,
    "promotion_code": null,
    "start": 1790213231,
    "subscription": "sub_1UJ1RLJSNw06INmpH4g7EAnR",
    "subscription_item": null
  },
  "discounts": [
    "di_1UJ1RLJSNw06INmp7Gyg59Z4"
  ],
  "ended_at": null,
  "invoice_settings": {
    "account_tax_ids": null,
    "custom_fields": null,
    "description": null,
    "footer": null,
    "issuer": {
      "type": "self"
    }
  },
  "items": {
    "object": "list",
    "data": [
      {
        "id": "si_VJekL2Ju3LYOBg",
        "object": "subscription_item",
        "billing_thresholds": null,
        "created": 1790213231,
        "current_period_end": 1795483631,
        "current_period_start": 1792805231,
        "current_trial": null,
        "discounts": [],
        "metadata": {},
        "plan": {
          "id": "price_1UCvo6JSNw06INmp521wjbt0",
          "object": "plan",
          "active": true,
          "aggregate_usage": null,
          "amount": 599,
          "amount_decimal": "599",
          "billing_scheme": "per_unit",
          "created": 1788761610,
          "currency": "usd",
          "interval": "month",
          "interval_count": 1,
          "livemode": true,
          "metadata": {},
          "meter": null,
          "nickname": null,
          "product": "prod_VDMX4Z9QWa1fJs",
          "tiers": null,
          "tiers_mode": null,
          "transform_usage": null,
          "trial_period_days": null,
          "usage_type": "licensed"
        },
        "price": {
          "id": "price_1UCvo6JSNw06INmp521wjbt0",
          "object": "price",
          "active": true,
          "billing_scheme": "per_unit",
          "created": 1788761610,
          "currency": "usd",
          "custom_unit_amount": null,
          "livemode": true,
          "lookup_key": null,
          "metadata": {},
          "nickname": null,
          "product": "prod_VDMX4Z9QWa1fJs",
          "recurring": {
            "aggregate_usage": null,
            "interval": "month",
            "interval_count": 1,
            "meter": null,
            "trial_period_days": null,
            "usage_type": "licensed"
          },
          "tax_behavior": "unspecified",
          "tiers_mode": null,
          "transform_quantity": null,
          "type": "recurring",
          "unit_amount": 599,
          "unit_amount_decimal": "599"
        },
        "quantity": 1,
        "subscription": "sub_1UJ1RLJSNw06INmpH4g7EAnR",
        "tax_rates": []
      }
    ],
    "has_more": false,
    "total_count": 1,
    "url": "/v1/subscription_items?subscription=sub_1UJ1RLJSNw06INmpH4g7EAnR"
  },
  "latest_invoice": "in_1UTtjuJSNw06INmpCSoYdijh",
  "livemode": true,
  "managed_payments": {
    "enabled": false
  },
  "metadata": {
    "app_id": "5013",
    "order_id": "42103",
    "package_id": "231",
    "transaction_id": "42103977136256977136256",
    "user_id": "65741"
  },
  "next_pending_invoice_item_invoice": null,
  "on_behalf_of": null,
  "pause_collection": null,
  "payment_settings": {
    "payment_method_options": {
      "acss_debit": null,
      "bancontact": null,
      "billie": null,
      "blik": null,
      "card": {
        "network": null,
        "request_three_d_secure": "automatic"
      },
      "customer_balance": null,
      "konbini": null,
      "payto": null,
      "pix": null,
      "sepa_debit": null,
      "upi": null,
      "us_bank_account": 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_1UCvo6JSNw06INmp521wjbt0",
    "object": "plan",
    "active": true,
    "aggregate_usage": null,
    "amount": 599,
    "amount_decimal": "599",
    "billing_scheme": "per_unit",
    "created": 1788761610,
    "currency": "usd",
    "interval": "month",
    "interval_count": 1,
    "livemode": true,
    "metadata": {},
    "meter": null,
    "nickname": null,
    "product": "prod_VDMX4Z9QWa1fJs",
    "tiers": null,
    "tiers_mode": null,
    "transform_usage": null,
    "trial_period_days": null,
    "usage_type": "licensed"
  },
  "quantity": 1,
  "schedule": null,
  "start_date": 1790213231,
  "status": "past_due",
  "tax_percent": null,
  "test_clock": null,
  "transfer_data": null,
  "trial_end": null,
  "trial_settings": {
    "end_behavior": {
      "billing_cycle_anchor": "now",
      "missing_payment_method": "create_invoice"
    }
  },
  "trial_start": null
}
⚠️ Inactive Status: past_due
UPDATE tbl_customer_subscriptions SET ack_status = ack_status + 1, is_cancelled = 0, cancelled_at = NULL, renewal_date = '2026-10-26 02:46:55' WHERE id = 70759
✅ Status Updated (ack_status = 1, retry_at = 2026-10-26 02:46:55)
🔍 Checking Subscription: sub_1U6sb6JSNw06INmpl38xcroa
📦 Raw Response:
{
  "id": "sub_1U6sb6JSNw06INmpl38xcroa",
  "object": "subscription",
  "application": null,
  "application_fee_percent": null,
  "automatic_tax": {
    "disabled_reason": null,
    "enabled": false,
    "liability": null
  },
  "billing_cycle_anchor": 1787319304,
  "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,
    "feedback_option": null,
    "reason": null
  },
  "collection_method": "charge_automatically",
  "created": 1787319304,
  "currency": "usd",
  "current_period_end": 1795268104,
  "current_period_start": 1792589704,
  "customer": "cus_V76oGW2t41mGcF",
  "customer_account": null,
  "days_until_due": null,
  "default_payment_method": "pm_1U6sb3JSNw06INmpY4fcqLHw",
  "default_source": null,
  "default_tax_rates": [],
  "description": null,
  "discount": null,
  "discounts": [],
  "ended_at": null,
  "invoice_settings": {
    "account_tax_ids": null,
    "custom_fields": null,
    "description": null,
    "footer": null,
    "issuer": {
      "type": "self"
    }
  },
  "items": {
    "object": "list",
    "data": [
      {
        "id": "si_V76oDY0rI3GfW7",
        "object": "subscription_item",
        "billing_thresholds": null,
        "created": 1787319305,
        "current_period_end": 1795268104,
        "current_period_start": 1792589704,
        "current_trial": null,
        "discounts": [],
        "metadata": {},
        "plan": {
          "id": "price_1T5KteJSNw06INmpsZN3Oy9l",
          "object": "plan",
          "active": true,
          "aggregate_usage": null,
          "amount": 399,
          "amount_decimal": "399",
          "billing_scheme": "per_unit",
          "created": 1772175094,
          "currency": "usd",
          "interval": "month",
          "interval_count": 1,
          "livemode": true,
          "metadata": {},
          "meter": null,
          "nickname": null,
          "product": "prod_U3RnwdJbLl42GQ",
          "tiers": null,
          "tiers_mode": null,
          "transform_usage": null,
          "trial_period_days": null,
          "usage_type": "licensed"
        },
        "price": {
          "id": "price_1T5KteJSNw06INmpsZN3Oy9l",
          "object": "price",
          "active": true,
          "billing_scheme": "per_unit",
          "created": 1772175094,
          "currency": "usd",
          "custom_unit_amount": null,
          "livemode": true,
          "lookup_key": null,
          "metadata": {},
          "nickname": null,
          "product": "prod_U3RnwdJbLl42GQ",
          "recurring": {
            "aggregate_usage": null,
            "interval": "month",
            "interval_count": 1,
            "meter": null,
            "trial_period_days": null,
            "usage_type": "licensed"
          },
          "tax_behavior": "unspecified",
          "tiers_mode": null,
          "transform_quantity": null,
          "type": "recurring",
          "unit_amount": 399,
          "unit_amount_decimal": "399"
        },
        "quantity": 1,
        "subscription": "sub_1U6sb6JSNw06INmpl38xcroa",
        "tax_rates": []
      }
    ],
    "has_more": false,
    "total_count": 1,
    "url": "/v1/subscription_items?subscription=sub_1U6sb6JSNw06INmpl38xcroa"
  },
  "latest_invoice": "in_1USzfyJSNw06INmpm1G4LR6x",
  "livemode": true,
  "managed_payments": {
    "enabled": false
  },
  "metadata": {
    "app_id": "5013",
    "order_id": "29195",
    "package_id": "228",
    "transaction_id": "29195559055736559055736",
    "user_id": "56690"
  },
  "next_pending_invoice_item_invoice": null,
  "on_behalf_of": null,
  "pause_collection": null,
  "payment_settings": {
    "payment_method_options": {
      "acss_debit": null,
      "bancontact": null,
      "billie": null,
      "blik": null,
      "card": {
        "network": null,
        "request_three_d_secure": "automatic"
      },
      "customer_balance": null,
      "konbini": null,
      "payto": null,
      "pix": null,
      "sepa_debit": null,
      "upi": null,
      "us_bank_account": 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_1T5KteJSNw06INmpsZN3Oy9l",
    "object": "plan",
    "active": true,
    "aggregate_usage": null,
    "amount": 399,
    "amount_decimal": "399",
    "billing_scheme": "per_unit",
    "created": 1772175094,
    "currency": "usd",
    "interval": "month",
    "interval_count": 1,
    "livemode": true,
    "metadata": {},
    "meter": null,
    "nickname": null,
    "product": "prod_U3RnwdJbLl42GQ",
    "tiers": null,
    "tiers_mode": null,
    "transform_usage": null,
    "trial_period_days": null,
    "usage_type": "licensed"
  },
  "quantity": 1,
  "schedule": null,
  "start_date": 1787319304,
  "status": "past_due",
  "tax_percent": null,
  "test_clock": null,
  "transfer_data": null,
  "trial_end": null,
  "trial_settings": {
    "end_behavior": {
      "billing_cycle_anchor": "now",
      "missing_payment_method": "create_invoice"
    }
  },
  "trial_start": null
}
⚠️ Inactive Status: past_due
UPDATE tbl_customer_subscriptions SET ack_status = ack_status + 1, is_cancelled = 0, cancelled_at = NULL, renewal_date = '2026-10-26 02:46:56' WHERE id = 59650
✅ Status Updated (ack_status = 1, retry_at = 2026-10-26 02:46:56)

✅ Cron Completed