added more predicates to the whereclause of the product search query
(product/search page).
Now the user can search by supplier's product name, supplier's product
model no, supplier's name, supplier's code name