I wanted the ability/option to display or hide the dropdown that displays at the top of the NEW PRODUCTS listing, and ALL PRODUCTS listings, so I came up with this little solution that I found to be successful.

Edit includes/templates/[template_name]/templates/tpl_products_all_default.php
Locate (about line 14):
Code:
<h1 id="allProductsDefaultHeading"><?php echo HEADING_TITLE; ?></h1>

<?php
    require($template->get_template_dir('/tpl_modules_listing_display_order.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_listing_display_order.php');


?>
Change to:
Code:
<h1 id="allProductsDefaultHeading"><?php echo HEADING_TITLE; ?></h1>

<?php


 // Check Layout Settings "Show Product DropDown Order" -sf


 if(SHOW_PRODUCTS_DROPDOWN == '1'){
    require($template->get_template_dir('/tpl_modules_listing_display_order.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_listing_display_order.php');
    }
?>
APPLY SQL PATCH:
Code:
INSERT into configuration values("","Show Product Sort DropDown Order","SHOW_PRODUCT_ORDER_DROPDOWN","1",
"Show the product order dropdown on product listings?<br/>1=Show 0=Hide","18","71",NULL,NOW(),"",
"zen_cfg_select_option(array('0', '1'),",);
To make changes, simply go to Configuration->Product Info in the admin, and near the bottom of the list, you'll see the option for "Show Product Sort DropDown Order option to configure it for showing or hiding this nagging thing.

Done, and of course, good SQL backup practices are always encouraged before doing any changes to your database, but you don't need me to tell you that because you're a zen - guru.