filtering products by customer location?

[GIDMEISTER]

I want to show a customer different products depending on where the customer is from. If he is from Connecticut, I want him to see different products than a customer who is from California. How would this be done with OsCommerce?

 

More details: First the customer would login and give the state and zip code where he is from. I would use this information to somehow search for products that only apply to him.

 

Can this be done with OSCommerce? Would I use a 'sql statement' against the OSCommerce database?

 

Thanks,

GidMeister

[♥geoffreywalton]

You would have to tag products as only sell in "this area"

 

Then you would have to only display products depending on their location. If you are asking if you would use an sql statement this is probably (definitely) beyond your current level of expertise. You might start with the sql part of www.w3schools.com

 

You could use manufacturer to hold the product area.

 

Enjoy

[Guest]

I want to show a customer different products depending on where the customer is from. If he is from Connecticut, I want him to see different products than a customer who is from California. How would this be done with OsCommerce?

 

More details: First the customer would login and give the state and zip code where he is from. I would use this information to somehow search for products that only apply to him.

 

Can this be done with OSCommerce? Would I use a 'sql statement' against the OSCommerce database?

 

Thanks,

GidMeister

May be possible to do this with Javascript?

 

On my old site, I embedded a small javascript into my home page which automatically altered it's content based on the resolution on the vistitors monitor. For example, if the visitors monitor was running 800x600 or less, the homepage that visitor saw was primarily populated with products such as new graphics cards & new monitors.