How to query WooCommerce orders where meta data does not exist?

patrick

I need to get all my orders from WooCommerce where some extra metadata is equal to not zero.

$orders = wc_get_orders( array(
    'orderby'   => 'date',
    'order'     => 'DESC',
    'meta_query' => array(
        array(
            'key' => 'var_rate',
            'compare' => 'NOT EXISTS',
        )
    )
));

Whenvar_rateis empty or doesn't exist then it will not return that record. Presently all orders are returned using those arguments.

See the example of empty record

object(WC_Meta_Data)#2344 (2) {
  ["current_data":protected]=>
  array(3) {
    ["id"]=>
    int(6471)
    ["key"]=>
    string(15) "var_rate"
    ["value"]=>
    NULL
  }
  ["data":protected]=>
  array(3) {
    ["id"]=>
    int(6471)
    ["key"]=>
    string(15) "var_rate"
    ["value"]=>
    NULL
  }
}

anderson

Okay see in the meta_query argument (that can be used in a WP_Query) does not enabled by default when using a WC_Order_Query throughwc_get_orders() WooCommerce function.

For that you can use the undocumented Custom Field Parameters (just like in a WP_Query):

meta_key
meta_value
meta_value_num
meta_compare

You can use

$orders = wc_get_orders( array(
    'limit'        => -1, // Query all orders
    'orderby'      => 'date',
    'order'        => 'DESC',
    'meta_key'     => 'var_rate', // The postmeta key field
    'meta_compare' => 'NOT EXISTS', // The comparison argument
));