// WP_Query arguments $args = array( 'post_type' => array( 'product' ), 'nopaging' => true, 'meta_query' => array( 'relation' => 'AND', array( 'key' => '_sku', 'value' => '899 %', 'compare' => 'LIKE', ), array( 'key' => '_stock_status', 'value' => 'instock', 'compare' => '=', ), ), ); // The Query $data = new WP_Query( $args ); // The Loop if ( $data->have_posts() ) { while ( $data->have_posts() ) { $data->the_post(); // do something } } else { // no posts found } // Restore original Post Data wp_reset_postdata();