How to add another manufacturer's drop-down?

[gammada]

I would like to know how may I add another field like the manufacturers drop-down to my store. Also, I want to make this field searchable.

 

Any ideas?

 

Thanks in advance.

[niknakgroup]

theres a contrib called manufacturers2 - it needs tweaking to your own requirements and isn't quite complete, but its a very good starting point - see my site for an example of how it works!

[gammada]

theres a contrib called manufacturers2 - it needs tweaking to your own requirements and isn't quite complete, but its a very good starting point - see my site for an example of how it works!

 

Thanks, I'm going to try it. BTW Where's your store?

[♥Monika in Germany]

Thanks, I'm going to try it. BTW Where's your store?

 

most members show a store in their profile under the home page heading ... as does Tony ;-). Click on his name!

[gammada]

most members show a store in their profile under the home page heading ... as does Tony ;-). Click on his name!

 

Hi Monika,

 

Thanks for the tip but the link displayed there is not an osCommerce installation.

[♥Monika in Germany]

Hi Monika,

 

Thanks for the tip but the link displayed there is not an osCommerce installation.

 

PM him! :thumbsup:

[DNA10101010]

Have searched and tried for 2 days, seriously need some help.

 

1. pick from pull-down menu in manufacturers2 info box

2. products listed correctly by manufacturers2

3. filter by pick from the pull down on the top-right

4. I get this

 

1109 - Unknown table 'm2' in where clause

select count(p.products_id) as total from products p, products_description pd, manufacturers2 m, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers2_id = m2.manufacturers2_id and m.manufacturers_id = '19' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '12'

 

Everything working fine. I got header, column, anf footer shown.

 

Thanks

[♥Monika in Germany]

Have searched and tried for 2 days, seriously need some help.

 

1. pick from pull-down menu in manufacturers2 info box

2. products listed correctly by manufacturers2

3. filter by pick from the pull down on the top-right

4. I get this

 

1109 - Unknown table 'm2' in where clause

select count(p.products_id) as total from products p, products_description pd, manufacturers2 m, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers2_id = m2.manufacturers2_id and m.manufacturers_id = '19' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '12'

 

Everything working fine. I got header, column, anf footer shown.

 

Thanks

 

 

 

you are using a wrong table alias ...

 

change this

p.manufacturers2_id = m2.manufacturers2_id

 

to this

p.manufacturers2_id = m.manufacturers2_id

 

and you should be set!

[DNA10101010]

you are using a wrong table alias ...

 

change this

p.manufacturers2_id = m2.manufacturers2_id

 

to this

p.manufacturers2_id = m.manufacturers2_id

 

and you should be set!

 

 

Thanks. It happened to have 2x m2 in the same line which I over looked the 2nd one.

 

After I finish my site, I'm gonna rewrite the instruction. The original instruction is missing stuff here and there. Took me a while to install it correctly.

 

Now, who would nice enough to share how to add manufacturers2 in search?