Limit Search Results To Model Number and Product Title

[CoolCarPartsOnline]

I need to limit the search results on one of my websites to the Product Title and model number. The reason being is that if a customer search for a car make and model the search result will render results that are irrelevant just because the content has the same keywords. The way I have my product setup is that the car make and model are listed in the title so if a customer search for a car they will see a relevant result. Plus I am using the model number to display the part number so most customers are going to either search by the car make and model or by the part number.

[kuroi]

I believe that searches already include name and model by default. Therefore you would need to remove the other fields from the advanced_search template. To do a thorough job your would probably removes them from the search algorithm in the includes/modules/pages/advanced_search_result/header_php.php file too.

[CoolCarPartsOnline]

I thought I would post the solution that I found, alter the following lines (around line 323) in the module/pages/advanced_search_results/header.php

$where_str = $db->bindVars($where_str, ':keywords', $search_keywords[$i], 'noquotestring'); 

To:

$where_str = $db->bindVars($where_str, ':keywords', $search_keywords[$i], 'noquotestring');
                unset($_GET['search_in_description']); 

[roooot]

Very good. Very useful. Thank you

[ellivir]

I thought I would post the solution that I found, alter the following lines (around line 323) in the module/pages/advanced_search_results/header.php

$where_str = $db->bindVars($where_str, ':keywords', $search_keywords[$i], 'noquotestring'); 

To:

$where_str = $db->bindVars($where_str, ':keywords', $search_keywords[$i], 'noquotestring');
                unset($_GET['search_in_description']); 

I would need TWO search boxes and limit both of them:
- the first one only to give results of the PRODUCT MODEL
- the second one only to give results of the PRODUCT NAME / TITLE

I think it could be somehow lead out of this solution above... It would be nice if anybody can help.

Elli

[Sushigal]

I've used this bit of code also but changed it to 'search_in_title' however, when I search for 'pen' it still brings up irrelevant products that dont have the word 'pen' in their title. Does anyone know how I can sort this?

Thanks.

[Sushigal]

sorry, 'search_in_name' which works, however when I search 'pen' a load of hip flasks are still coming up and I cannot see the word pen in their product name at all.

my site is at http://www.thegreatgiftshop.co.uk