🚀 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