WooCommerce - Multiple meta query not working

Question

Any help on why this multiple meta query is not working is greatly appreciated, both meta_query arguments have been tested independently.

I'm looking for bringing Featured products as well as Best Selling(popular) products. Currently this snippet of code is bringing all posts that are 'post_type' => 'product', completely ignoring the 'meta_query'.

$args = array(
    'post_type' => 'product',
    'post_status' => 'publish',
    'posts_per_page' => 10,
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'meta_key' => 'total_sales',
            'orderby' => 'meta_value_num'
        ),
        array(
            'meta_key' => '_featured',
            'meta_value' => 'yes'
        )
    )
);

Anybody out there in the wild?

Answer 1

meta_query format and orderby format should be as follows:

$args = array(
    'post_type'     => 'product',
    'post_status'   => 'publish',
    'posts_per_page'=> 10,
    'orderby'       => 'total_sales',
    'order'         => 'DESC',
    'meta_query'    => array(
        'relation'  => 'OR',
        array(
            'key'       => '_featured',
            'value'     => 'yes',
            'compare'   => '='
        ),
        array(
            'key'       => 'total_sales',
            'value'     => '10',
            'compare'   => '>='
        )
    )
);
$query = new WP_Query( $args );

Instead of meta_key and meta_value use key and value with compare as mentioned. You can see related documentation of WP_Meta_Query which also works with WP_Query.