Better product search in Oscommerce by assigning weighted relevance

In Progress

The default sorting of product searching in OsCommerce is terrible. We made a very crude and simple hack to the mysql fetch, but we would ideally like the products to be sorted by relevance by assigning weight to it. The prioritization of returned results should be ranked in this order:

1. Number of matching keywords in the product name.

2. Number of total matching keywords in both product name and description.

A relevance score method should be assigned, and an option to set the minimum relevance score to ignore/hide all results that don't meet the minimum relevance score.

We would also like to have slave products always shown always in order with the master products being returned in the search results, regardless if it is searched by master or slave keywords/catalog numbers. Currently, the slave products are treated as separate products from the master products, and this confuses customers who see them appear in random orders in the search results.

Note that we are using version 2.2MS. We also added Master-Slave products contrib, with a many extra hacks and additions.

Skills: Javascript, Linux, MySQL, OSCommerce, PHP

See more: sorting method, searching in c, name of product and description, relevance, mysql product search, name search number, fetch mysql, mysql fetch, random orders, fetch results, php mysql product search, php mysql product catalog, product description keywords, default search , assigning, oscommerce product sorting, keywords product description, mysql additions, product catalog php, product order php mysql, simple sorting php, search php mysql product catalog, oscommerce search orders products, search relevance, oscommerce search product name

Project ID: #5071940

Awarded to:


A proposal has not yet been provided

$150 USD in 14 days
(581 Reviews)

6 freelancers are bidding on average $222 for this job


Hello, We have a strong experience in developing & designing websites and developed lot of projects in this regard. We use core coding/designing standards & techniques in whole development process and provide 100% More

$360 USD in 7 days
(76 Reviews)

I have completed these osc projects with excellent reviews: ============================================ And also contributed many osc add-ons since 2006 More

$188 USD in 4 days
(45 Reviews)

Ready to start... give me a chance to work for you. THANK YOU.

$170 USD in 3 days
(1 Review)

Hello, I'm new to freelancer but I have 3+ experience in OsCommerce and I have done this kind of work before so i'm pretty much sure about this task. My work is based on 100% client satisfaction and stick to the More

$188 USD in 3 days
(1 Review)

Hello Sir/Mam, We provide the excellent web services which appeal to customers to ask and inquire about your products and services. We have professionally trained team of expert web designers which design user f More

$300 USD in 18 days
(1 Review)

i am ready and expert in Javascript, Linux, MySQL, OS Commerce, PHP and i have 3 year of experience and i can complete this project before a 3 days and i do the best of this project so ready and start now..

$166 USD in 3 days
(0 Reviews)