Filter WooCommerce products with post__in and additional meta queries

 

2 Answers

Sorted by:

                                              Highest score (default)                                                                   Date modified (newest first)                                                                   Date created (oldest first)                              

0

$on_sale_product_ids = wc_get_product_ids_on_sale();

$queried_products = wc_get_products(array(
    'limit' => 1000,
    'orderby' => 'id',
    'order' => 'asc',
    'price_and_stock' => true,
));
$on_sale_products = wc_get_products(array('include' => array_values($on_sale_product_ids) , 'limit' => count($on_sale_product_ids)) );

$total_products = array_merge($on_sale_products,$queried_products );

Add below code snippet for price_and_stock combination query.

function handle_custom_query_var( $query, $query_vars ) {
    if ( ! empty( $query_vars['price_and_stock'] ) ) {
        $query['meta_query'][] =    array( 'relation' => 'AND',
    'price' => array(
        'key' => '_price',
        'value' => 9,
        'compare' => '<',
        'type' => 'numeric'
    ),
    'stock_status' => array(
        'key' => '_stock_status',
        'value' => 'instock',
        'compare' => '=',
    )
            );
    }

    return $query;
}
add_filter( 'woocommerce_product_data_store_cpt_get_products_query', 'handle_custom_query_var', 10, 2 );

More details on the custom query can be found here

== Alternate ==

Note: you cannot combine post__in and post__not_in in the same query. post__in and post__not_in are mutually exclusive.

$meta_query = array(
                'relation' => 'AND',
                'price' => array(
                    'key' => '_price',
                    'value' => 9,
                    'compare' => '<',
                    'type' => 'numeric'
                ),
                'stock_status' => array(
                    'key' => '_stock_status',
                    'value' => 'instock',
                    'compare' => '=',
                ),
            );
        
            $args = array(
                'post_type' => array('product', 'product_variation'),
                'posts_per_page' => 1000,
                'return' => 'ids',
                'post__in' => wc_get_product_ids_on_sale(),
                'meta_query' => $meta_query // this contains the price under X query
            );
            $total_products = wc_get_products($args);