Show Number Of Products In Category?

[Guest SweetNightshade]

My employer wants me to figure out how to show the number of items in each category on the category side-bar. URL is www.sheetmusicstorehouse.com Any suggestions?

[bsmither]

The category admin section shows these values, so we just need to copy the query.

In the file \includes\boxes\categories.inc.php, find the line that has:

$results = $db->select("SELECT cat_name, cat_id FROM

and change it to:

$results = $db->select("SELECT cat_name, cat_id, noProducts FROM

Now we need to tweak the template. Find the file \skins\YOUR_SKIN\styleTemplates\boxes\categories.tpl, find the line that has:

{DATA.cat_name}

and change it to:

{DATA.cat_name} ({DATA.noProducts})

See how that flies.

[Guest SweetNightshade]

The category admin section shows these values, so we just need to copy the query.

In the file \includes\boxes\categories.inc.php, find the line that has:

$results = $db->select("SELECT cat_name, cat_id FROM

and change it to:

$results = $db->select("SELECT cat_name, cat_id, noProducts FROM

Now we need to tweak the template. Find the file \skins\YOUR_SKIN\styleTemplates\boxes\categories.tpl, find the line that has:

{DATA.cat_name}

and change it to:

{DATA.cat_name} ({DATA.noProducts})

See how that flies.

You are awesome, worked like a charm. Thanks.