Hi Dave
Got a quick question,
when i type a search in for say product PHILIPS X52 that search is not coming up properly, so I need to do a merchant search instead to get the right product coming up.
So now i search PHILIPS X52 in merchant : Pc world, and the right search result comes up.
My query is I have a line that automatically brings up the number of stores you can compare the prices in, but when i do it on a merchant search, it automatically tells users that the product is only available in 1 store, when its actually available in 3 stores
how would i correct this?
Hi Phil,
This is a by-product and therefore one of the limitations of using a Full Text index.
By default, and for performance reasons, MySQL only generates the full text index on words of at least 4 characters. Thus, when doing a normal search, the X52 is ignored and only "PHILIPS" is used in the search.
However, the full text index is not used in the merchant: search, which is why the exact product is found, but only of course in 1 record - the merchant being searched.
I would recommend testing for the merchant: search type, and perhaps use a "Search for more prices" link rather than "Compare prices at 1 store(s)" if you are on a merchant specific search result page.
Hope this helps;
David.