Submitted by babyuniverse on Sun, 2008-08-17 11:50 in Price Tapestry
Hi There,
Any ideas on how to create a script that will search all products and return similare products, eg products that have 90% similar words, this would be used to merge products that are similar
Using the full text index, which sorts by relevance by default; this would basically amount to whatever appeared next in the search results for any particular product (if you search for it by name exactly).
Does that look suitable? In terms of matching 90% words; this could get complicated because of how to decide which 90% of the words are matched; in other words you could have 2 products that share 90% of their words with a 3rd product but not each other (I think!!), something may be possible along these lines however...
Hi Richard,
Using the full text index, which sorts by relevance by default; this would basically amount to whatever appeared next in the search results for any particular product (if you search for it by name exactly).
Does that look suitable? In terms of matching 90% words; this could get complicated because of how to decide which 90% of the words are matched; in other words you could have 2 products that share 90% of their words with a 3rd product but not each other (I think!!), something may be possible along these lines however...
Cheers,
David.