Morning David
We have recently imported a couple of jewellery product feeds (which all imported fine) but discovered that searching for the word "gold" kept producing zero results even though other four letter words like "ruby" etc produced results. Is this because the stopwords contains the words "go" and "old" and the script looks for the partial word within a word? If thats the case can we make it an exact match only or do we have a problem elswhere.
Chris
Hi Chris,
Stopwords apply to whole words only; but what you're noticing is more likely to be the other caveat of full text indexing which is that words considered too common (e.g. present in a certain percentage of indexed values) are not included, so that is most likely what is happening in the case of a jewellery feed with numerous "gold" products.
I normally recommend disabling full text indexing for niche sites or where this could be an issue; which you can do by changing line 8 of config.advanced.php as follows;
$config_useFullText = FALSE;Results should then return as expected.
Cheers,
David.
--
PriceTapestry.com