"Specials" category which automatically has specials

Is is possible to have a "specials" category (called "Sale") which automatically lists any items which are on special? At the moment I'm using the Multiple Categories Link Manager and it's very time consuming.

I can see in tpl_categories.php is says SHOW_CATEGORIES_BOX_SPECIALS == 'true'

but I can't see where to turn this on in the admin. Thanks!

The handy dandy Developers Tool Kit is your friend ... :cool:

Go to the Tools ... Developers Tool Kit ... and in the top input box put in the constant you are looking for that is stored in the configuration table:
SHOW_CATEGORIES_BOX_SPECIALS

Now, select NONE from the dropdown and click SEARCH ...

It will show you what is found and provide an EDIT button to get you there ... :smile:

NOTE: Specials and Sales are not the same thing so this link only shows if you have Specials that are active in the specials table and have it turned on ...

Thank you. And how do I create this as a category (so when you click "Sale" it shows all the Specials)?

I am not following you ...

You have a link to the Specials in the Category Sidebox ...

Why are you needing a Category for them? :unsure:

The site doesn't use siteboxes - have a look at https://www.iamhappie.com - I just want a link in the right hand side which automatically shows all Specials. At the moment I have a Sale manual category.

That sure looks like the Categories sidebox on your site ...

But if you cannot use sideboxes, edit the original categories tpl file and you will see the code:

    if (SHOW_CATEGORIES_BOX_SPECIALS == 'true') {
      $show_this = $db->Execute("select s.products_id from " . TABLE_SPECIALS . " s where s.status= 1 limit 1");
      if ($show_this->RecordCount() > 0) {
        $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_SPECIALS) . '">' . CATEGORIES_BOX_HEADING_SPECIALS . '</a>' . '<br />' . "\n";
      }
    }

Adapt that to where you need the link ...

Thanks! I found the answer to my question (which I perhaps didn't ask very clearly).

To turn on a "Sale" category which automatically lists your Specials do the following:

Configuration -> Layout Settings

Choose "Categories Box - Show Specials Link" to true

Thanks for the update that you found the switch to turn that on ... :smile: