This module will help the relevancy of the products returned on your zencart advanced search results. The stock search runs a LIKE query for each word in the query. There is no regard to the relevancy of the word for the product associated with it. When a user searches using a adjective like a color red, any product with “red” will be returned. Now make the search “red shoes”, and you will receive any product with red or shoes. You may get red shirts, black shoes, white shoes, or any other variation. As long as one of the words is in the name, model, description, or keywords it will be shown. Obvisously red shirts and white shoes are nothing like the users original query. This zencart advanced search module uses a natural language search function in MySQL which will return more accurate results for multi keyword search phrases. Each keyword searched, is scored for its relevancy for each product, and the results are ordered by this relevancy score. It will also try to pluralize words to expand the search. The module will create a configuration group in your admin panel for setting the weights for the product columns that are searched. The default values seem to be returning accurate results.
Only one original file is overwritten in /includes/modules/pages/advanced_search_result/header_php.php. Only a few lines where changed to modify the query being ran for the results. Installation is simple as uploading the zip file to your zencart installation. Login to your admin panel, and you will be prompted with a link to install the module. The installation link will install the proper database queries, and take you to the configuration page under Admin->Configuration->Reloaded Search.
An additional feature, is when only one product is returned in the search results, the product is displayed rather than the search result page.