=== CHECKING av_orders TABLE ===

✓ av_orders table exists

Columns:
  - id
  - order_number
  - first_name
  - last_name
  - email
  - phone
  - delivery_method
  - payment_method
  - bank_reference
  - address_line_1
  - address_line_2
  - city
  - postcode
  - subtotal
  - shipping
  - total
  - payment_intent_id
  - status
  - created_at
  - updated_at
  - lucky_dip_completed
  - special_requests
  - collection_date
  - collection_payment_method
  - payment_status
  - deposit_amount
  - balance_due
  - paid_amount
  - shipping_carrier
  - shipping_tracking
  - shipped_at
  - admin_notes
  - discount_code
  - discount_amount
  - shipping_address
  - shipping_cost
  - has_backorder
  - payment_token
  - payment_deadline
  - balance_paid_at
  - payment_reminder_sent
  - payment_reminder_sent_at
  - stripe_payment_intent_balance
  - is_preorder

=== SAMPLE ORDER ===
id: 203
order_number: AV-250927-TEMP-1759002146-8217
first_name: Collette
last_name: Storey
email: collette789@gmail.com
phone: 07977268889
delivery_method: delivery
payment_method: card
bank_reference: 
address_line_1: 65 Cromwell Road
address_line_2: Eccles
city: Eccles
postcode: M30 0GX
subtotal: 33.98
shipping: 9.98
total: 43.96
payment_intent_id: 
status: 
created_at: 2025-09-27 20:42:26
updated_at: 2025-11-29 13:56:22
lucky_dip_completed: 0
special_requests: 
collection_date: 
collection_payment_method: 
payment_status: PAID
deposit_amount: 0.00
balance_due: 0.00
paid_amount: 0.00
shipping_carrier: Other
shipping_tracking: delivery
shipped_at: 2025-11-01 19:46:43
admin_notes: 
discount_code: 
discount_amount: 0.00
shipping_address: 
shipping_cost: 0.00
has_backorder: 0
payment_token: 
payment_deadline: 
balance_paid_at: 
payment_reminder_sent: 0
payment_reminder_sent_at: 
stripe_payment_intent_balance: 
is_preorder: 0

=== CHECKING av_order_items TABLE ===

✓ av_order_items exists

Columns:
  - id
  - order_id
  - product_id
  - variant_name
  - product_name
  - quantity
  - item_id
  - item_type
  - name
  - unit_price
  - qty
  - line_total
  - is_bundle_item
  - parent_item_id
  - variant_details
  - variant_sku
  - backorder