test

1. Staff Member Configuration (ID: 1)

Field	Value	Status
Zoom Authentication	oauth	✅ OAuth
Token Exists	Yes (1501 chars)	✅
Token Expiry	2026-09-13 22:56:54	✅ Valid
Token Scope	meeting:read:list_meetings meeting:write:meeting meeting:update:meeting meeting:delete:meeting	✅ Has meeting:write

2. Service Configuration (ID: 2)

Field	Value	Status
Service Name	Live Session 1 on 1
Online Meetings	zoom	✅ Enabled

3. Staff-Service Relationship

Warning: Undefined property: stdClass::$online_meetings_enabled in /home/masterc2/public_html/staging.theorango.com/wp-content/themes/astra-child/functions.php on line 1471

Warning: Undefined property: stdClass::$online_meetings_enabled in /home/masterc2/public_html/staging.theorango.com/wp-content/themes/astra-child/functions.php on line 1472

Field	Value	Status
Relationship Exists	Yes	✅
Online Meetings Enabled	No	❌ Should be enabled

4. Upcoming Appointments

No upcoming appointments found.

5. Recommended Fixes

Warning: Undefined property: stdClass::$online_meetings_enabled in /home/masterc2/public_html/staging.theorango.com/wp-content/themes/astra-child/functions.php on line 1544

1. Enable Zoom for Staff-Service: UPDATE wp_bookly_staff_services SET online_meetings_enabled = 1 WHERE staff_id = 1 AND service_id = 2;
2. For Existing Appointments: Edit and resave the appointment to trigger Zoom creation

Starting Auto Refund Process
Current Time: 2026-09-13 16:56:55
Stripe Key: Found
Stripe SDK initialized successfully
SQL Query:
        SELECT 
            ca.id, 
            ca.payment_id, 
            p.details, 
            p.ref_id, 
            p.status as payment_status
        FROM wp_bookly_customer_appointments ca
        JOIN wp_bookly_payments p ON ca.payment_id = p.id
        WHERE ca.status = 'cancelled'
          AND p.type = 'stripe'
          AND p.status IN ('pending', 'completed')
          AND (p.details NOT LIKE '%"refunded":true%' OR p.details IS NULL)
          AND (p.details NOT LIKE '%"rejected":true%' OR p.details IS NULL)
    
Found 2 cancellations to process
Results: Array
(
    [0] => stdClass Object
        (
            [id] => 453
            [payment_id] => 437
            [details] => {"items":[{"type":"appointment","app_start_info":null,"appointment_date":"2025-08-15 15:30:00","ca_id":453,"deposit_format":0,"discounts":null,"duration":3600,"extras":[],"number_of_persons":1,"service_name":"Live Session 1 on 1","service_price":10,"service_tax":0,"staff_name":"Amari T.","units":1,"wait_listed":false}],"coupon":null,"coupon_id":null,"gift_card":null,"gift_card_id":null,"subtotal":{"deposit":0,"price":10},"customer":"Arpita Student","customer_id":"39","customer_group":null,"tax_in_price":false,"tax_paid":null,"extras_multiply_nop":1,"gateway_ref_id":null,"tips":null,"adjustments":[],"refundable":null,"group_discount":null,"discounts":null,"from_backend":true}
            [ref_id] => 
            [payment_status] => completed
        )

    [1] => stdClass Object
        (
            [id] => 514
            [payment_id] => 484
            [details] => {"items":[{"type":"appointment","app_start_info":null,"appointment_date":"2025-08-15 10:00:00","ca_id":514,"deposit_format":0,"discounts":null,"duration":3600,"extras":[],"number_of_persons":1,"service_name":"Live Session 1 on 1","service_price":50,"service_tax":0,"staff_name":"Wpadmin","units":1,"wait_listed":false}],"coupon":null,"coupon_id":null,"gift_card":null,"gift_card_id":null,"subtotal":{"deposit":0,"price":50},"customer":"Arpita Student","customer_id":"39","customer_group":null,"tax_in_price":false,"tax_paid":null,"extras_multiply_nop":1,"gateway_ref_id":null,"tips":null,"adjustments":[],"refundable":null,"group_discount":null,"discounts":null,"from_backend":true}
            [ref_id] => 
            [payment_status] => completed
        )

)
Processing Payment ID: 437 (Status: completed)
Processing completed payment...
No Stripe charge/payment intent ID found — cannot refund
Processing Payment ID: 484 (Status: completed)
Processing completed payment...
No Stripe charge/payment intent ID found — cannot refund
Auto Refund Process Completed