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
- incomplete examples:
- post_password = UNKNOWN
- post_type = ‘shop_order’
- comment_count = UNKNOWN