Looking for two Manufacturer Modifications...

[Rachael w.]

I am looking for two modifications for manufacturers and I cant seem to find them, I'm not actually sure they even exist.

 

First, I am looking for some type of modification so that manufacturers who have no products in the catalog will not show in the manufacturers drop down on the site. Something similar to the empty categories mod.

 

Second, I am looking for a modification to the manufacturers page where I can add information to the top of the manufacturers page similar to the categories description mod.

 

I searched the forums and the contribs section but didnt see anything similar, maybe I just missed it.

 

Thank you all in advance for your help.

[Rachael w.]

Well, just in case anyone else out there is looking for the same. Here's a fix for one of my questions above.

 

To prevent your manufacturers box from listing manufacturers who have no products associated with them (empty manufacturers) try this:

 

includes/boxes/manufacturers.php

 

Replace:

 $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");

 

With:

  $manufacturers_query = tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where m.manufacturers_id=p.manufacturers_id order by manufacturers_name");;

 

Now, I am still searching for some way to add manufacturers information to the top of the page (above the products). Something that will allow a lot of text and possibly html.

[Jack_mcs]

The Header Tags Controller contribution will do that for you.

 

Jack

[Rachael w.]

I guess I didnt explain that very well. :blush: I dont mean the very top of the page I mean in the top of manufacturers listing page something like this:

 

[Jack_mcs]

Yes, Header Tags will do that and let you do the same for your categories too.

 

Jack

[Rachael w.]

Really, hmm, have to look into that! I guess the title was deceiving. :)

 

Thanks so much for the reply!