Intelligent searching of products

[sheringham]

...the products' individual attributes (the ones you set up that appear in drop down menus)?

 

For example, I've got a football memorabelia shop, there are loads of different products, most have a drop down menu which lists what teams you can get each product in:

 

http://www.footballemporium.co.uk

 

I'd like the search facility to allow people to type in their team and bring up a list of products that we have for that team - but it doesn't pick up on the products attributes list.

 

Is there any way round this?

 

If not, how best can I prime each product for it to be included in a search by team name - is the only way to add each team name in the product description? Not ideal...

[♥Monika in Germany]

...the products' individual attributes (the ones you set up that appear in drop down menus)?

 

For example, I've got a football memorabelia shop, there are loads of different products, most have a drop down menu which lists what teams you can get each product in:

 

http://www.footballemporium.co.uk

 

I'd like the search facility to allow people to type in their team and bring up a list of products that we have for that team - but it doesn't pick up on the products attributes list.

 

Is there any way round this?

 

If not, how best can I prime each product for it to be included in a search by team name - is the only way to add each team name in the product description? Not ideal...

 

yes there is a way. use the table products attributes as a base, and fill all id's by joins to show the wording too ... add description ect using your language id ... then make your search in this "virtual table" and display distinct ids only.