How to get users data from wordpress woocomerce database to display

WooCommerce uses a custom post type “shop_order” to store orders. This means that the orders will be stored in the wp_posts database table with the post_type column set to shop_order SELECT ID, post_author, post_date, post_status, post_type FROM wp_posts WHERE post_type=”shop_order” WooCommerce stores a large portion of the order related data as post meta. Once you … Read more