fix product search condition and add warning in case no product is found