Limit Search Results To Model Number and Product Title

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.

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.

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']);

Very good. Very useful. Thank you:clap:

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: 
> ```php
$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

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.

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