Search order

Hi there,

I'm having a slight problem with searches on my website:

www.wslr.co.uk/index.php/resources-catalogue

Question 1

The search is returning partial words - for instance if I do a text search for our planet, anything with the "our" contained in it is shown - like your, tour, flour etc etc which means many hundreds of products are returned.

I have the text search looking in product code, product keywords, product name, and product description.

Is there a way to make the search only see whole words?

Question 2

I would like to return the products in order of priority and I've set up a custom field named "order" and this will be 1,2,3 or 4

I'd like all order 1 to come up first, then order 2, and so on.

I've set the Default parameters for products ordering field to "order" which is my cistom field, but it doesn't seem to work in the way I expected.

How can I set all searches to return the product in order 1,2,3,4 etc

Hope this makes sense,

ian

Thanks Nicolas,

For the search - I'll try changing the code as you suggest.

However, I was wondering if there could be another option?

If you include some words in commas in Google - like "our planet" it would find matching whole words. Is there a way to make this happen in HikaShop? This would also solve my problem.

Yours,

ian

Hi Nicolas,

thank you for your help.

I applied the more complex condition and it seems to work.

I'll let you know how I get on with it.

You are a genius!!

Thanks

Ian

Hi Nicolas,

Many thanks for helping with the search in filters.

I've added the code you suggested and it has made a big difference:

$list[]=' (b.'.$column.' LIKE \'% '.hikashop_getEscaped($term, true).' %\' OR b.'.$column.' LIKE \''.hikashop_getEscaped($term, true).' %\' OR b.'.$column.' LIKE \'% '.hikashop_getEscaped($term, true).',%\' OR b.'.$column.' LIKE \'% '.hikashop_getEscaped($term, true).'.%\')';
but it's still not perfect...

It's not working quite as expected. If the product has a single word - no space before or after, it still doesnt show up in the search.

if i search for "dragonslayer" for instance which is the only word in the title - doesnt come up.

or if I search for it's product code "FD0810" it doesn't come up

product link is here:

www.wslr.co.uk/index.php/resources-catal...ow/1789-dragonslayer

Search page is here:

www.wslr.co.uk/index.php/resources-catalogue

do you have any suggestions?

Hi Nicolas,

Ah, I see.

I just tried adding that code but it broke the shop (shop wouldn't load), so i must have added it to the wrong place.

Please could you clarify where the 2 bits of code go?

I replaced this:

$list[]=' b.'.$column.' LIKE \'%'.hikashop_getEscaped($term, true).'%\' ';

with this:

$list[]=' (b.'.$column.' LIKE \'% '.hikashop_getEscaped($term, true).' %\' OR b.'.$column.' LIKE \''.hikashop_getEscaped($term, true).' %\' OR b.'.$column.' LIKE \'% '.hikashop_getEscaped($term, true).',%\' OR b.'.$column.' LIKE \'% '.hikashop_getEscaped($term, true).'.%\')';

and added this to it:

$searchEscaped = hikashop_getEscaped($term, true);
$list[]=' (b.'.$column.' LIKE \'% '.$searchEscaped.' %\' OR b.'.$column.' LIKE \''.$searchEscaped.' %\' OR b.'.$column.' LIKE \'% '.$searchEscaped.',%\' OR b.'.$column.' LIKE \'% '.$searchEscaped.'.%\' OR b.'.$column LIKE \''.$searchEscaped.'\')';

Appreciate your help,

Ian