🔍 Checking WooCommerce HPOS Tables
Date: 2025-11-05 03:48:35

HPOS Enabled: Yes

Table Existence Check:
- wp_wc_orders: ✅ Exists
- wp_wc_orders_meta: ✅ Exists
- wp_wc_order_product_lookup: ✅ Exists
- wp_wc_order_stats: ✅ Exists
- wp_wc_orders_meta: ✅ Exists
- wp_posts: ✅ Exists
- wp_postmeta: ✅ Exists

📊 wc_orders Table Structure:
- id (bigint unsigned)
- status (varchar(20))
- currency (varchar(10))
- type (varchar(20))
- tax_amount (decimal(26,8))
- total_amount (decimal(26,8))
- customer_id (bigint unsigned)
- billing_email (varchar(320))
- date_created_gmt (datetime)
- date_updated_gmt (datetime)
- parent_order_id (bigint unsigned)
- payment_method (varchar(100))
- payment_method_title (text)
- transaction_id (varchar(100))
- ip_address (varchar(100))
- user_agent (text)
- customer_note (text)

📊 wc_orders_meta Table Structure:
- id (bigint unsigned)
- order_id (bigint unsigned)
- meta_key (varchar(255))
- meta_value (text)

📊 wc_order_product_lookup Table Structure:
- order_item_id (bigint unsigned)
- order_id (bigint unsigned)
- product_id (bigint unsigned)
- variation_id (bigint unsigned)
- customer_id (bigint unsigned)
- date_created (datetime)
- product_qty (int)
- product_net_revenue (double)
- product_gross_revenue (double)
- coupon_amount (double)
- tax_amount (double)
- shipping_amount (double)
- shipping_tax_amount (double)

🧪 Testing HPOS Query:
Sample orders from wc_orders:
- Order 67245: Status=wc-cancelled, Type=shop_order, Date=2024-04-01 10:21:00
- Order 67300: Status=wc-cancelled, Type=shop_order, Date=2024-04-01 16:29:30
- Order 67384: Status=wc-cancelled, Type=shop_order, Date=2024-04-01 22:40:20
- Order 67393: Status=wc-cancelled, Type=shop_order, Date=2024-04-01 23:03:13
- Order 67459: Status=wc-cancelled, Type=shop_order, Date=2024-04-02 17:37:40

🔍 Testing Event Product Query:
Orders with event products:

✅ HPOS check complete.