Woocommerce Order data in posts table

WIP 20171218

select *
from wp1_posts po
where post_type = 'shop_order'
order by po.ID desc;

Relevant/useful/unsure fields only

  • ID = POST ID = ORDER ID
  • post_date / post_date_gmt = timestamp
  • post_excerpt = customer added note
  • post_status = order status
    • incomplete examples:
      • wc-cancelled
      • wc-completed
      • wc-refunded
  • post_password = UNKNOWN
  • post_type = ‘shop_order’
  • comment_count = UNKNOWN