Manipulate search results

It's a tricky business manipulating the order, since each search is different. The order is determined at present by various factors (the code itself is in the search stored procedured).

Boosting particular products for a particular search is largely down to having them better match the keywords and phrases that people might search for. You probably don't want to just boost particular products for any search (not that there is an easy way to do this at present), if it means them coming up higher in searches where they're not relevant.

What you will find is that the search ranks results higher that match the input phrase exactly over ones that contain all the words and ones which contain one of the words. So for example:

power drill

Will match results that contain 'power' and 'drill', but ones that contain the term 'power drill' earn extra points that tends to rank them higher

Words in the product name score more than words in other fields. This scoring is perhaps rather simplistic compared to something like Google. But since it is internal within a store, it's not really open to being gamed or abused in quite the same way, since all the content being searched is added by the store owner, so spamming up one product would be to the detriment of others of your own products (though if you want to shift something this might be worth doing).

Author	Message
TheCalicoTree	Posted Tue 29 Nov 2011
Supreme Being Group: Forum Members Last Active: Thu 18 Jun 2015 Posts: 98, Visits: 1,382 70,602	We need to be able to manipulate the order in which search results are displayed so that we can select which products display first. I m thinking of using the Strapline field to enter in multiple keywords and then use CSS to turn off the display of the strapline. Not ideal but am wondering if anyone has a better solution? Thanks Helen Tags search results order, search stored procedure
	REPLY QUOTE LIKE 373
Paul	Posted Wed 30 Nov 2011
große Käse Group: Administrators Last Active: Tue 10 Sep 2024 Posts: 807, Visits: 2,748 508,134	It's a tricky business manipulating the order, since each search is different. The order is determined at present by various factors (the code itself is in the search stored procedured). Boosting particular products for a particular search is largely down to having them better match the keywords and phrases that people might search for. You probably don't want to just boost particular products for any search (not that there is an easy way to do this at present), if it means them coming up higher in searches where they're not relevant. What you will find is that the search ranks results higher that match the input phrase exactly over ones that contain all the words and ones which contain one of the words. So for example: power drill Will match results that contain 'power' and 'drill', but ones that contain the term 'power drill' earn extra points that tends to rank them higher Words in the product name score more than words in other fields. This scoring is perhaps rather simplistic compared to something like Google. But since it is internal within a store, it's not really open to being gamed or abused in quite the same way, since all the content being searched is added by the store owner, so spamming up one product would be to the detriment of others of your own products (though if you want to shift something this might be worth doing). -- If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future. If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb Tags search
	REPLY QUOTE LIKE 384
TheCalicoTree	Posted Mon 5 Dec 2011
Supreme Being Group: Forum Members Last Active: Thu 18 Jun 2015 Posts: 98, Visits: 1,382 70,602	Thanks for the reply and the explanation. In our example we have 10 different types of soap. We would prefer our best sellers to appear at the top of the search results. As each product is limited to the number of times we can realistically mention the keyword soap we were thinking of using the strapline and then turning off the display of that field through CSS. Does the stored procedure search the strapline field?
	REPLY QUOTE LIKE 368
Mohammad	Posted Mon 5 Dec 2011
Kartris Expert Group: Administrators Last Active: Sun 27 Sep 2015 Posts: 115, Visits: 706 78,755	Product's strapline is not included in the search (by default), but you can add it as searchable field, to do that, simply find/replace "LE_FieldID IN (1,2)" in your search stored procedure by "LE_FieldID IN (1,2,7)" But if you want to change how the ranks given to results, its a tricky one!, you will need to study the search stored procedure in order to be able to play with the ranking formulas. Tags strapline search
	REPLY QUOTE LIKE 385
TheCalicoTree	Posted Tue 7 Feb 2012
Supreme Being Group: Forum Members Last Active: Thu 18 Jun 2015 Posts: 98, Visits: 1,382 70,602	I've been studying the search query and I think I have found a problem. We changed the query to use strapline which is working but it seemed that the description field was being overlooked. I have followed the code and interrogated data at various points and it seems to me as though tblKartrisLanguageElements is not being populated with description data. Indeed when I query the table SELECT count(*) FROM tblKartrisLanguageElements WHERE LE_FieldID = 2 the result is 1783. Only 514 of these records have LE_VALUE data. These all seem to be category descriptions. Forgive me if I've misunderstood the process but should there not be data in here? Could it be possible that the admin tool is not passing product description data through to this table? Tags data, database, search
	REPLY QUOTE LIKE 384

Manipulate search results

Manipulate search results

Similar Topics

Reading This Topic