query orders by products woocommerce

Solutions on MaxInterview for query orders by products woocommerce by the best coders in the world

showing results for - "query orders by products woocommerce"

20 Nov 2019

1/**
2 * Get All orders IDs for a given product ID.
3 *
4 * @param  integer  $product_id (required)
5 * @param  array    $order_status (optional) Default is 'wc-completed'
6 *
7 * @return array
8 */
9function get_orders_ids_by_product_id( $product_id, $order_status = array( 'wc-completed' ) ){
10    global $wpdb;
11
12    $results = $wpdb->get_col("
13        SELECT order_items.order_id
14        FROM {$wpdb->prefix}woocommerce_order_items as order_items
15        LEFT JOIN {$wpdb->prefix}woocommerce_order_itemmeta as order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id
16        LEFT JOIN {$wpdb->posts} AS posts ON order_items.order_id = posts.ID
17        WHERE posts.post_type = 'shop_order'
18        AND posts.post_status IN ( '" . implode( "','", $order_status ) . "' )
19        AND order_items.order_item_type = 'line_item'
20        AND order_item_meta.meta_key = '_product_id'
21        AND order_item_meta.meta_value = '$product_id'
22    ");
23
24    return $results;
25}
26

source

similar questions

woocommerce sql query pulls products from category

queries leading to this page

order by woocommerce products query query orders by products woocommerce get orders woocommerce php woocommerce product query order by status woocommerce wp query order by price woocommerce select orders by product wp query woocommerce orders woocommerce query order by product woocommerce query products by category woocommerce mysql query all products by order id how to woocommerce db comleted order get in query get all orders woocommerce function php get order query woocommerce woocommerce order sql query woocommerce query orders by item query products woocommerce woocommerce sql orders how to get all orders from woocommerce php woocommerce get orders query woocommerce query orders woocommerce shop order query orders woocommerce woocommerce get orders products database get all orders woocommerce php get woocommerce orders wp query query woocommerce products wp query get woocommerce orders get orders by id woocommerce woocommerce product query order by get woocommerce orders query woocommerce orders woocommerce query order items get order by id woocommerce wp query woocommerce orders query query orders by products woocommerce