Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Exact Match For Search Rate Topic   - - - - -

 
  • mrmem
  • Member
  • Members
  • Join Date: 13-Jul 09
  • 90 posts

Posted 05 June 2018 - 01:38 AM #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



 
  • oleg.gorshkov
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3150 posts

Posted 05 June 2018 - 05:26 AM #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.


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Mega SEO Package - All you need for your SEO


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18498 posts

Posted 05 June 2018 - 05:54 AM #3

Please pay attention to our free Search Improvements addon


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 

Posted 14 June 2018 - 04:14 AM #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?



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18498 posts

Posted 14 June 2018 - 06:30 AM #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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • ThomH
  • Senior Member
  • Members
  • Join Date: 20-Nov 07
  • 1490 posts

Posted 14 June 2018 - 08:31 AM #6

Also you can take a look at Suggestive Search addon.


WebGraphiq offers a wide range of professionally developed, ready to use CS-Cart add-ons to provide additional functionality and boost your sales. The oldest active CS-Cart add-on development team. -- Since 2006 --


CS-CART ADD-ONS | FREE QUOTE | CS-CART DEVELOPMENT | @webgraphiq


 

Posted 18 June 2018 - 01:31 AM #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?



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18498 posts

Posted 18 June 2018 - 05:48 AM #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)


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.