🚀 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