Sort order (for school products in different zip codes)

[milauskas]

Hi,

 

This is a new challenge. Not sure how to implement. I know I can associate a product with a manufacturer, but I need something a little different.

 

My friend sells school uniforms. He deals with a number of schools. What he wants is for the customer to come to the site and be able to sort by school, by city or by zip code.

 

Entering any of these (however these are chosen) would then display the items associated with each. If it's a school, all that school's items would be displayed. If it's city or zip, it would display the schools in those areas.

 

Is this possible with osc? I know I could replace manufacturers with schools, but what about searching by city and zip. Will the search function in osc accomplish what I need? Maybe I'm not thinking clearly and the solution is obvious. If so, let me know.

Thanks!

[ktshannon]

Hey Michael,

 

Yes, this is possible. With the stock oscommerce will not do exactly what you need, but you may be able to modify some contributions to help along. What you would have to do is add fields for each product allowing zip,city,state,school etc... and then have them be shown on the front end by the database choices.

 

Hope that helps.

[milauskas]

Hey Michael,

 

Yes, this is possible. With the stock oscommerce will not do exactly what you need, but you may be able to modify some contributions to help along. What you would have to do is add fields for each product allowing zip,city,state,school etc... and then have them be shown on the front end by the database choices.

 

Hope that helps.

 

That does help Do I need to go into MySQL to add the fields? I'm looking at a contrib called Advanced Search. It's got 3 pulldowns so I'm thinking I could search for school, city or zip (if those fields exist after modifying the database). Any thoughts? Have you done anything like this?

 

Has anyone else?

 

Thanks for the input!

[toneus]

I've done a similiar thing on my store. We sell UPS systems and need to be able to drill down, by power rating, manufacturer, configuration etc. Take a look at UPSMart Selection Tool.

 

Done exactly as ktshannon says. Add some fields to your 'products' table such as 'school_name', 'school_city', 'school_zip', then some simple php sql scripts can sort for you depending upon your needs. Not sure if this is how you want to go as you'll need to be able to programme in php and html, but thought I'd let you know in any case. [if you need some guidance with php/html/sql etc check out www.w3schools.com. This is an excellent resource.]