Have a couple of customers that are looking for a better search result
They say too many results come out with some searches.
say customer searches "shawn hill"
shaw hill shows up but also shawn hillegas.
Is there a way to get a exact search result.
Im using 4.3
Thanks in advance
Hello!
You need the fn_get_products function in app/functions/fn.catalog.php file. Have a look at the section that starts with
// Search string condition for SQL query
For example, for product name change this code
if ($params['pname'] == 'Y') {
$tmp .= db_quote(" OR descr1.product LIKE ?l", '%' . $piece . '%');
}
to this one:
if ($params['pname'] == 'Y') {
$tmp .= db_quote(" OR descr1.product = ?s", $piece);
}
But please think about it before you do because not all customers can enter the exact product name and with these changes they will not get any result. It might be useful to improve search by showing results while customers enter something, like Searchanise or some custom simple solution.
look at it but still you can't add the special characters on the search. I know google search, you can type special characters. That's what I'm looking for.
look at it but still you can't add the special characters on the search. I know google search, you can type special characters. That's what I'm looking for.
Anybody have an idea on how to do it?
It is required to rework fn_get_products function (app/functions/fn.catalog.php)