Put below code in functions.php
add_action( ‘woocommerce_product_query’, ‘aviweb_product_query’ );add_action( ‘woocommerce_product_query’, ‘aviweb_product_query’ );
function aviweb_product_query( $q_array ){
$product_ids_on_sale = array(); $product_ids_on_sale[] = 7076;
$q_array->set( ‘post__not_in’, $product_ids_on_sale );
}
post__in -> products within array
post__not_in -> products not in array