We already have a search function in the header of our oscommerce max website. We need it modified so that --
One can search by model number, by Store and keywords in each store. We have multiple oscommerce stores, we would like the search function to search through.
Please take a look at musicdispatch.com. Type in guitar fake book
The results are what we wish our results to look like with the only exception being that results are listed by store.
Also if there are over 200 results one must refine their search with more specific keywords.
The search would need to do so --
Takes off the first two digits of our model numbers (as we use the first two digits to signify our suppliers.) So, for instance if a customer searches for AB-66 and our product number in the databse is MUAB-66, the search results will still display results AB-66.
We have over 200,000 products so if it disables any part of a customers shopping ability ie increases load time to a more than 5 seconds than it already is, it is up to you to optimize the search page, the results page and the database part of the search so that this is a completely functional search.
Must be in php, mysql, oscommerce, run super fast. You must be able to begin this project the day you bid, finish the next day and allow us one day to test and give feedback if neccessary before we release escrow payment.
Please ask any questions or make any clarifications, thoughts and ideas before you bid.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
oscommerce
mysql
php