Problem with "Product Date Available"

[josee225]

Hi,

I have products that need to be online prior to their release date. So we set them up with the planned release date, like today for instance.

But what I don't understand is that my product is still not available for purchase, even though we ARE the 30th, it still says
"Availability - 09/30/2011"

I want people to have the possibility to buy the product right now, is there any way I can fix this, short of saying my product is available on the 29th, which is absolutely not possible in our case.

URL: http://www.cartamagicastore.com/inde...=61_63_330_678

[Ajeh]

What is the Quantity set on the Product?

Do you have something customized or an add on to make the:
Availability - 09/30/2011

show on the listing and product _info page?

[josee225]

Hi Linda,

I have 12 cards available in each for product quantity, and since I took over the store, I have no clue if an add-on was used.

All I can tell you is that I can enter a date right below the Product Status, as shown in the attached file.

[Ajeh]

Go to your Tools ... Developers Tool Kit ... and do a search in the bottom input box for:
Availability

and see if you find either the define statement for that or the code that contains that word ...

If you find the define for that you can search on that define constant and see where it is used and that might help determine where this code is that manages that display ...

[josee225]

Ok looking for that word in Catalog, here is what I found:
english.php
Line #481 : define('BUTTON_UPCOMING_PRODUCTS_TEXT', 'Approximate availability - ');
english.php
Line #21 : define('BUTTON_UPCOMING_PRODUCTS_TEXT', 'Availability - ');

So I looked at the files in Modules, and found a file called upcoming_products.php... Apparently, there is an extra module for this!

Here is the code:

<?php
/**
 * upcoming_products module
 *
 * @package modules
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: upcoming_products.php 4162 2006-08-17 03:55:02Z ajeh $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}

$display_limit = zen_get_upcoming_date_range();
if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
/*
  $expected_query = "select p.products_id, pd.products_name, products_date_available as date_expected
                       from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                       where to_days(products_date_available) > to_days(now())
                       and p.products_id = pd.products_id
                       and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                       order by " . EXPECTED_PRODUCTS_FIELD . " " . EXPECTED_PRODUCTS_SORT . "
                       limit " . MAX_DISPLAY_UPCOMING_PRODUCTS;
*/
    $expected_query = "select p.products_id, pd.products_name, products_date_available as date_expected
                       from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                       where
                       p.products_id = pd.products_id
                       and p.products_status = 1
                       and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" .
                       $display_limit . "
                       order by " . EXPECTED_PRODUCTS_FIELD . " " . EXPECTED_PRODUCTS_SORT . "
                       limit " . MAX_DISPLAY_UPCOMING_PRODUCTS;

} else {
/*
  $expected_query = "select p.products_id, pd.products_name, products_date_available as date_expected
                       from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " .
  TABLE_CATEGORIES . " c
                       where p.products_id = p2c.products_id
                       and p2c.categories_id = c.categories_id
                       and c.parent_id = '" . (int)$new_products_category_id . "'
                       and to_days(products_date_available) > to_days(now())
                       and p.products_id = pd.products_id
                       and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                       order by " . EXPECTED_PRODUCTS_FIELD . " " . EXPECTED_PRODUCTS_SORT . "
                       limit " . MAX_DISPLAY_UPCOMING_PRODUCTS;
*/
    $expected_query = "select p.products_id, pd.products_name, products_date_available as date_expected
                       from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " .
                              TABLE_CATEGORIES . " c
                       where p.products_id = p2c.products_id
                       and p2c.categories_id = c.categories_id
                       and c.parent_id = '" . (int)$new_products_category_id . "'" .
                       $display_limit . "
                       and p.products_id = pd.products_id
                       and p.products_status = 1
                       and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                       order by " . EXPECTED_PRODUCTS_FIELD . " " . EXPECTED_PRODUCTS_SORT . "
                       limit " . MAX_DISPLAY_UPCOMING_PRODUCTS;

}

$expected = $db->Execute($expected_query);

if ($expected->RecordCount() > 0) {
  require($template->get_template_dir('tpl_modules_upcoming_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_upcoming_products.php');
}
?>

[Ajeh]

Could you now do a search on:
BUTTON_UPCOMING_PRODUCTS_TEXT

and see what files come up with that in it ...