Exact Match For Search

Store Builder Questions
1

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

2

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.

3

Please pay attention to our free Search Improvements addon

4

is there a way to have do search with special characters such as this example:

hp+120gb+6gb

If I do this now, search result shows nothing. Is their a way to adjust to search function to include special characters?

5

is there a way to have do search with special characters such as this example:

hp+120gb+6gb

If I do this now, search result shows nothing. Is their a way to adjust to search function to include special characters?

I do not know such addons

6

Also you can take a look at Suggestive Search addon.

7

Also you can take a look at Suggestive Search addon.

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?

8

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)