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