Hi David,
Is there away of listing featured merchants first from product listings or list merchants with the lowest product prices first from the database.
I seem to be getting a lot of one merchant for two to tree pages first of porducts and they are not the lowest price.
also i have been reading into full text search software which also can plugin into mysql or use as standalone full text search it is supose to be better than mysql and return results in half the time with better returned results it cann index text from mysql i am doing test run in the next couple of weeks just wondering if you have ever seen the software here is the link it is open source looks very promising.
Sphinx Free open-source SQL full-text search engine:
http://www.sphinxsearch.com/
all the best
Darren
hi david,
don' mean to be a pain but did manage to work out how I can get my merchants list first form the database.
all the best
darren
Hi Darren,
If you could send me a link to a page of search results that demonstrate what you want to do something about that will help. I'm afraid I'm not quite sure from your original post what it is you want to change...
Cheers,
David.
Hi Darren,
Do you mean that you would like to give certain merchants priority in search results? By default, search result are ordered by relevance to the query, so it would be normal for them to be out of price order. Apologies if i've misunderstood the scenario... if so could you perhaps email me some links to search results on your site that demonstrate this situation - that would help work out if there is an SQL modification that would improve results specific to your merchants and price ranges etc... Reply to your reg code or forum registration email is the easiest way to get me...
Regarding external search - have a look at the following thread which discusses SQL changes to use Boolean mode which may improve results in some situations (but not all!)...
http://www.pricetapestry.com/node/420
Cheers,
David.