6 Column Product Filter For Table In SQL Database - OSCommerce Shop

6 Level Filter For Table In SQL Database - OSCommerce

Hi I need a filter function for an OSC site V2.2 RC2

It needs to filter 6 columns in the "product description" table

Method is with drop down boxes.

Each box must be able to sort individually of each other.

Shop has around 350,000 products and growing

I will set up the columns and supply the name of the columns

The 6 drop down boxes to be arranged vertically

With a "Search" button at the bottom when the user has filtered to their requirements

When a filter is selected in any of the drop downs, only products with this selection are included in the remaining drop down menus if that makes sense?

Search results will bring up all products meeting filter criteria using the "product listing" layout.

If any product has one empty field in any of the columns it should be excluded from the filter process completely

Where a field is not filtered it should bring up all products with an entry in that column. ie default value is "Any"

Results should be limited to 100. If customer search finds more than 100 it should say "Too Many Results, Please Narrow Your Search Criteria"

No admin interface required

No involvement of categories required.

I will populate the columns myself

I am looking for code which I can copy and paste into the relevant "info box"

Results must be fast, close to instant. 2-3 seconds max

If you have an example of a site using something similar that would be great

These are the main points, please let me know what other information you require.

I am looking for a ball park figure to start with.

Skills: OSCommerce, PHP, Software Architecture, SQL

See more: what is selection criteria, table customer, name of product and description, fast shop, customer table, product listing a, filter sort, column, table sort filter, product points, copy paste product shop shop, product table, product selection drop, oscommerce product sort, layout column, populate table using, php filter column, php sql filter, database entry level, populate product, sort table, start product description, populate database site search, instant search table php

About the Employer:
( 2 reviews ) Cairo, Egypt

Project ID: #4213907

16 freelancers are bidding on average $461 for this job


pls chk pmb

$435 USD in 5 days
(518 Reviews)

Professional PHP/MYSQL coder here and got much experiance in oscommerce work.Had seen europarts site and know what you need. Check PMB for what i did before for another site.

$500 USD in 10 days
(269 Reviews)

Hello, I have 6+ experience years in web development. Ecommerce, blogging, price comparison, classifieds sites, Web services. PHP, MySQL, JavaScript, AJAX, HTML, CSS. Please check pm for details.

$300 USD in 7 days
(38 Reviews)

Hi, We have gone through your requirement and assure you the product of your choice with excellent quality, please check your inbox for more detail.Thanks!

$650 USD in 20 days
(52 Reviews)

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$417 USD in 21 days
(41 Reviews)

Hello Dave, Greetings from Osiz Technologies. Kindly refer our PMB for a detailed Proposal. Regards, Nagendra Prabhu Project Manager.

$700 USD in 27 days
(13 Reviews)

Please see my private message.

$250 USD in 5 days
(49 Reviews)

I have excellent team of programmers and designers to work on your project efficiently and complete job in time. Please let me know when you are available to talk further on this so we can start the work asap. Thanks S More

$600 USD in 20 days
(18 Reviews)

I have throughly read your requirements. I am very well familiar with oscommerce. I can get this done for you. Best Regards,

$500 USD in 10 days
(14 Reviews)

Hi, I can do this .. lets start it.

$280 USD in 5 days
(11 Reviews)

hi i am ready to start work untill your 100% satisfaction

$700 USD in 21 days
(9 Reviews)

Hello sir please check pmb for more details

$350 USD in 10 days
(11 Reviews)

Hi, Thanks for sharing this job opportunity. I can surely develop the product drop down filters. I have same experience. Please review my private message for reference.

$300 USD in 3 days
(1 Review)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and t More

$700 USD in 25 days
(2 Reviews)

Hi, I have thoroughly read your requirements and believe that I can deliver exceptional results. I hope you will consider using My services. Best Regards, Mohit

$400 USD in 5 days
(0 Reviews)

I'm interested in doing this proj.

$750 USD in 7 days
(0 Reviews)

I can do it

$250 USD in 5 days
(0 Reviews)