=== CHECKING DATABASE STRUCTURE === 1. TRANSACTION_TBL COLUMNS: ---------------------------------------------------------------------------------------------------- id | int(11) | NO user_id | int(11) | NO gateway_transaction_id | varchar(100) | NO apex_client_id | varchar(100) | YES user_email | varchar(255) | NO item_quantity | int(11) | NO sub_total | float(10,2) | NO shipping_amount | float(10,2) | NO shipping_method | varchar(255) | YES shipping_method_id | varchar(50) | YES final_amount | float(10,2) | NO total_saving | float(10,2) | NO product_detail | text | NO gateway_response | text | NO shipping_address | text | NO user_ip | varchar(45) | YES paypal_order_id | varchar(100) | YES paypal_capture_id | varchar(100) | YES payment_status | varchar(50) | NO gateway_status | varchar(50) | YES hosted_payment_status | varchar(50) | YES payment_method | varchar(50) | YES order_status | varchar(50) | NO shipping_carrier | varchar(255) | YES tracking_number | varchar(255) | YES label_url | text | YES shipped_date | datetime | YES coupon_code | varchar(50) | NO coupon_discount_amount | float(10,2) | NO created_date | datetime | NO session_id | varchar(100) | YES 2. PAYMENT_ORDERS COLUMNS: ---------------------------------------------------------------------------------------------------- id | int(11) | NO transaction_id | int(11) | YES client_id | varchar(255) | NO client_name | varchar(255) | YES amount | int(11) | NO way_code | varchar(50) | NO order_status | varchar(50) | NO pay_url | text | YES response_data | longtext | YES paypal_order_id | varchar(100) | YES paypal_capture_id | varchar(100) | YES payment_decline_reason | text | YES is_refunded | tinyint(1) | YES refund_amount | decimal(10,2) | YES refund_date | timestamp | YES created_at | timestamp | NO updated_at | timestamp | NO 3. RECENT TRANSACTIONS (Last 10, any payment method): ------------------------------------------------------------------------------------------------------------------------ ID | Email | Amount | Created ------------------------------------------------------------------------------------------------------------------------ 289 | kf.baumann@outlook.com | $179.97 | 2026-04-27 21:09:48 286 | donmacc@gmail.com | $59.99 | 2026-04-27 14:14:38 287 | rhonda.bryant@nutrien.com | $599.90 | 2026-04-27 10:49:08 285 | moomooval@yahoo.com | $59.99 | 2026-04-26 22:19:38 284 | ways0603@gmail.com | $59.99 | 2026-04-26 13:32:59 283 | caddie628@aol.com | $119.99 | 2026-04-25 20:33:11 281 | sinrubjj@nep.net | $59.99 | 2026-04-25 08:09:52 278 | wsegal1234@gmail.com | $59.99 | 2026-04-24 21:20:02 277 | susiec462@gmail.com | $119.98 | 2026-04-24 21:03:41 276 | armando.urrutia4@gmail.com | $127.98 | 2026-04-24 20:55:08 4. SEARCHING FOR APPLE/GOOGLE PAY TRANSACTIONS: ------------------------------------------------------------------------------------------------------------------------ Found column: payment_method Unique values in 'payment_method': - credit_card - Stripe - Stripe CARD - Stripe LINK 5. TRANSACTIONS WITH GATEWAY DATA: ------------------------------------------------------------------------------------------------------------------------ ID | Email | Gateway ID | Amount ------------------------------------------------------------------------------------------------------------------------ 289 | kf.baumann@outlook.com | pi_3TQwPWRwMI1RGK7E0aejE75e | $179.97 286 | donmacc@gmail.com | pi_3TQpvlRwMI1RGK7E1vAX0qnS | $59.99 287 | rhonda.bryant@nutrien.com | pi_3TQqT7RwMI1RGK7E0FB27NnH | $599.90 285 | moomooval@yahoo.com | pi_3TQb1XRwMI1RGK7E01yCwiyy | $59.99 284 | ways0603@gmail.com | pi_3TQSnuRwMI1RGK7E1bpFByVQ | $59.99 283 | caddie628@aol.com | pi_3TQCszRwMI1RGK7E04FpV7NZ | $119.99 281 | sinrubjj@nep.net | pi_3TQ51uRwMI1RGK7E1bTvWBBx | $59.99 278 | wsegal1234@gmail.com | pi_3TPr8mRwMI1RGK7E0gn91OAU | $59.99 277 | susiec462@gmail.com | pi_3TPqswRwMI1RGK7E1Xejg3UA | $119.98 276 | armando.urrutia4@gmail.com | pi_3TPqkaRwMI1RGK7E1aie76LR | $127.98 6. ABANDONED_CHECKOUTS_TBL STRUCTURE: ---------------------------------------------------------------------------------------------------- id | int(11) | NO user_email | varchar(255) | NO shipping_address | longtext | YES product_detail | longtext | YES final_amount | decimal(10,2) | NO user_ip | varchar(45) | YES payment_method | varchar(50) | YES payment_error | text | YES gateway_reference_id | text | YES payment_token | text | YES paypal_order_id | varchar(100) | YES paypal_capture_id | varchar(100) | YES apex_client_id | varchar(100) | YES payment_status | varchar(50) | YES payment_decline_reason | text | YES is_refunded | tinyint(1) | YES refund_amount | decimal(10,2) | YES refund_date | timestamp | YES last_webhook_update | timestamp | YES created_at | timestamp | NO updated_at | timestamp | NO reminder_count | int(11) | YES last_reminder_sent_at | datetime | YES status | varchar(50) | YES === STRUCTURE CHECK COMPLETE ===