Hide Product info on upcoming items

Would there be a quick and easy way to hide or not allow the cart to put in the information on products that are waiting to go in the store.

I.E.

Product 1234 "Our New Product" is 0 Status

You cannot select it from any listing, but if you go to the top and add the 1234 to the url (like the following)
http://mystore.com/index.php?main_page=product_info&products_id=1234
...the customer can see the product name next to the category name and in the page title of the browser bar

Home :: "Our New Product"
Sorry, the product was not found.

and

Browser Bar Title = Name, Model, Price :: Store Name

We don't want customers to guess subsequent numbers and see upcoming stock.

Looking for an easy solution... anyone have one?

I have already tried changing the product number on the products table, but tha t messes up the auto increment.

/includes/modules/pages/product_info/header_php.php

around line 15 you have this:require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));add this right after it:```
$sql = "select count(*) as total
from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_status = '1'
and p.products_id = '" . (int)$_GET['products_id'] . "'
and pd.products_id = p.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
$res = $db->Execute($sql);
if ( $res->fields['total'] < 1 ) {
unset($_GET['products_id']);
}

AWESOME!! It takes the info out of the browser title bar.

Now, is there a way to remove it from the product info page? It shows in the category bar at the top of the product info display.

Example:

Home :: Name of Product

Sorry, the product was not found.

DrByte:

/includes/modules/pages/product_info/header_php.php

around line 15 you have this:require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));add this right after it:```
$sql = "select count(*) as total
from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_status = '1'
and p.products_id = '" . (int)$_GET['products_id'] . "'
and pd.products_id = p.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
$res = $db->Execute($sql);
if ( $res->fields['total'] < 1 ) {
unset($_GET['products_id']);
}

One way to do it would be to add this minor addition:```
if ( $res->fields['total'] < 1 ) {
unset($_GET['products_id']);
[B] unset($breadcrumb->_trail[sizeof($breadcrumb->_trail)-1]['title']);[/B]
}

Doing the DrByte TOTALLY ROCKS Dance!!!!!

YOU so totally rock!!!!

Thanks!!! :)

DrByte:

/includes/modules/pages/product_info/header_php.php

around line 15 you have this:require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));add this right after it:```
$sql = "select count(*) as total
from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_status = '1'
and p.products_id = '" . (int)$_GET['products_id'] . "'
and pd.products_id = p.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
$res = $db->Execute($sql);
if ( $res->fields['total'] < 1 ) {
unset($_GET['products_id']);
}

> **DrByte:**
>
> One way to do it would be to add this minor addition:```
  if ( $res->fields['total'] < 1 ) {
    unset($_GET['products_id']);
[B]    unset($breadcrumb->_trail[sizeof($breadcrumb->_trail)-1]['title']);[/B]
  }