Skip to content

Instantly share code, notes, and snippets.

@Jany-M

Jany-M/wp_wc_sql_order_query.sql

Created December 20, 2016 19:17
Show Gist options
  • Save Jany-M/7f3d039b1d4b8b1c8d4dcbfd5568c094 to your computer and use it in GitHub Desktop.
Save Jany-M/7f3d039b1d4b8b1c8d4dcbfd5568c094 to your computer and use it in GitHub Desktop.
Download ZIP
[WP][WooCommerce] SQL query for orders
Raw
wp_wc_sql_order_query.sql
/* List of useful SQL queries */
SELECT * FROM wp_posts where post_type = 'shop_order' and post_status = 'wc-pending';
SELECT * FROM wp_posts where post_type = 'shop_order';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment