Added vendor search method, fixed product search SQL