get orders by custom field (meta data)

Question

I want to loop through my orders and get only the orders with a specific custom field and value.

function lwb_5483845() {

    $args = array(
        'limit' => 9999,
        'return' => 'ids',
        'meta_query' => array(

            'key' => 'lwb_pickup_time_email_notification',
            'value' => '31-07-2022',
            'compare' => '=',
        ),
    );
    
    $query = new WC_Order_Query( $args );
    $orders = $query->get_orders();
    
    foreach( $orders as $order_id ) {
        echo $order_id . '<br />';
    }

}
add_filter( 'woocommerce_before_cart', 'lwb_5483845', 10, 2 );

score 2 · Answer 1 · answered Jun 21 '22 at 21:38

meta_query is not enabled (by default at least) for WC_Order_Query. To make this work, you need to use the meta_key, meta_value, meta_value_num and meta_compare parameters.

This is detailed in this answer discussing how meta_query isn't active.

So in your case, you could do:

function lwb_5483845() {

  $args = array(
    'limit' => 9999,
    'return' => 'ids',
    'meta_key' => 'lwb_pickup_time_email_notification',
    'meta_value' => '31-07-2022',
    'meta_compare' => '='
  );

  $query = new WC_Order_Query( $args );
  $orders = $query->get_orders();

  foreach( $orders as $order_id ) {
    echo $order_id . '<br />';
  }
}
add_filter( 'woocommerce_before_cart', 'lwb_5483845', 10, 2 );

worked on Woocommerce 7.4.1 – apripuppey Mar 17 '23 at 09:39 — apripuppey, Mar 17 '23 at 09:39

score 0 · Answer 2 · answered Jul 16 '20 at 09:33

The meta_query index need to be an array of array, because you can set multiple where statements :

function lwb_5483845() {

    $args = array(
        'limit' => 9999,
        'return' => 'ids',
        'meta_query' => array(
            array(
                'key' => 'lwb_pickup_time_email_notification',
                'value' => '31-07-2022',
                'compare' => '=',
            ),
        ),
    );
    
    $query = new WC_Order_Query( $args );
    $orders = $query->get_orders();
    
    foreach( $orders as $order_id ) {
        echo $order_id . '<br />';
    }

}
add_filter( 'woocommerce_before_cart', 'lwb_5483845', 10, 2 );

get orders by custom field (meta data)

2 Answers2