Search Enhancements - For MS1 and later
1) Automatic logging of all search terms used on your site.
2) Processing of logged search terms into total counts, with sorting by totals or by name.
3) Admin page provides a Google type facility whereby you can add words or phrases and their suggested replacements to a database table, once you've added data to this table if for example a customer searches for 'wheal' a line is added to the top of the search results page saying: 'you could also try: wheel'. This line is a clickable link that automatically re-searches on the replacement words. For this feature to work you must have made an entry via the admin page for the particular word/phrase used as well as the suggested replacement, obviously this data will take a little time to build up, this is the reason for the keyword logging, so as you can periodically check to see what needs adding to the replacements table.
4) Words/phrases and their suggested replacements can be added/edited/deleted at any time via the admin section.
5) Improved layout of Search results page if no results are found, providing the user with some tips on better searching.
6) Complete admin section to view and process logged search results.
7) When searching, any keywords entered as a plural will automatically have the final 's' stripped from the keyword, this should help if you have your products named/described in the singular form. A benefit of this is that even if there *should* be an 's' on the end of the keyword the correct results will be brought up due to the in-built partial matching of the osC search facility.
Legend: 
Download

Report
Checkbox for "Search in Product Description" is not working
URL shows search_in_description=on
<br>
example <br>
http://www.abundalife.com/catalog/advanced_search_result.php?keywords=glutamine&search_in_description=on&x=57&y=15&categories_id=&inc_subcat=1&manufacturers_id=&pfrom=&pto=&dfrom=&dto=
<br><br>
thus line 330 in page advanced_search_result.php needs to be changed to this: <br><br>
if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == 'on'))
Tom Stickel
Abundalife.com
Fixes the search completely now and corrects one more place the 's' was missing.
UPGRADERS from 1.x:
Just overwrite the old code in advanced_search_result.php and english/advanced_search.php
Fixes the search completely now and corrects one more place the 's' was missing.
UPGRADERS from 1.x:
Just overwrite the old code in advanced_search_result.php and english/advanced_search.php
- Update to fix bug where if you had one term in admin keywords and it's exact opposite listed it would give you the same search term back. For example if I had dog = cat and then cat = dog in my backend and I search for dog I would get dog again. Now this has been fixed.
- Update to modify the text displayed after a search and to add back the 's' for the customer to see if it was taken off for the search. (cosmetic only, it still searches for terms without the 's')
TO UPDATE:
Just overwrite the old code in advanced_search_result.php and english/advanced_search.php
FORUM:
http://forums.oscommerce.com/index.php?showtopic=59309
Tested on osCommerce 2.2 Milestone 2 Update 051113
A few bugs in the readme file have been corrected
This is an updated version of the Search Enhancements Module for MS2. No other changes are made to the module
All credit for this contribution goes to the original author: Paul Whiter, who wrote this contribution
Please post any questions/comments for this update in osc forum: http://forums.oscommerce.com/index.php?showtopic=59309
Search Enhancements - For MS1 and later
1) Automatic logging of all search terms used on your site.
2) Processing of logged search terms into total counts, with sorting by totals or by name.
3) Admin page provides a Google type facility whereby you can add words or phrases and their suggested replacements to a database table, once you've added data to this table if for example a customer searches for 'wheal' a line is added to the top of the search results page saying: 'you could also try: wheel'. This line is a clickable link that automatically re-searches on the replacement words. For this feature to work you must have made an entry via the admin page for the particular word/phrase used as well as the suggested replacement, obviously this data will take a little time to build up, this is the reason for the keyword logging, so as you can periodically check to see what needs adding to the replacements table.
4) Words/phrases and their suggested replacements can be added/edited/deleted at any time via the admin section.
5) Improved layout of Search results page if no results are found, providing the user with some tips on better searching.
6) Complete admin section to view and process logged search results.
7) When searching, any keywords entered as a plural will automatically have the final 's' stripped from the keyword, this should help if you have your products named/described in the singular form. A benefit of this is that even if there *should* be an 's' on the end of the keyword the correct results will be brought up due to the in-built partial matching of the osC search facility.