Problem with "Product Date Available"

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/index.php?main_page=index&cPath=61_63_330_678

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? :unsure:

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.

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 ...

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');
}
?>

Could you now do a search on:
BUTTON_UPCOMING_PRODUCTS_TEXT

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

Sure thing!

In Catalog:
includes/functions/functions_general.php
Line #1141 : $return_button = BUTTON_UPCOMING_PRODUCTS_TEXT . zen_date_short($button_check->fields['products_date_available']);

includes/functions_general.php
Line #1141 : $return_button = BUTTON_UPCOMING_PRODUCTS_TEXT . zen_date_short($button_check->fields['products_date_available']);

The other results are the same as above, in language files.

Nothing in Admin files.

(thank you!)

This file appears to be in the wrong location:
includes/functions_general.php

The other file is the one controlling that out put could you post the full function from the file:
includes/functions/functions_general.php

that that line is in?

Here you go:

$button_check = $db->Execute("select product_is_call, products_quantity, products_date_available from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");
    // upcoming date not available to purchase
    $upcoming_date_check = time();
    $upcoming_date_check = date('Ymd', $upcoming_date_check);
    $zc_current_date = (int)str_replace('-','',substr($button_check->fields['products_date_available'],0,10)); 
    
    switch (true) {
	case ($zc_current_date > 0 && $zc_current_date >= $upcoming_date_check):
        $return_button = BUTTON_UPCOMING_PRODUCTS_TEXT . zen_date_short($button_check->fields['products_date_available']);
        break; 
// cannot be added to the cart
    case (zen_get_products_allow_add_to_cart($product_id) == 'N'):
      return $additional_link;
      break;
    case ($button_check->fields['product_is_call'] == '1'):
      $return_button = '<a href="' . zen_href_link(FILENAME_CONTACT_US) . '">' . TEXT_CALL_FOR_PRICE . '</a>';
      break;
    case ($button_check->fields['products_quantity'] <= 0 and SHOW_PRODUCTS_SOLD_OUT_IMAGE == '1'):
      if ($_GET['main_page'] == zen_get_info_page($product_id)) {
        $return_button = zen_image_button(BUTTON_IMAGE_SOLD_OUT, BUTTON_SOLD_OUT_ALT);
      } else {
        $return_button = zen_image_button(BUTTON_IMAGE_SOLD_OUT_SMALL, BUTTON_SOLD_OUT_SMALL_ALT);
      }
      break;
    default:
      $return_button = $link;
      break;
    }
    if ($return_button != $link and $additional_link != false) {
      return $additional_link . '<br />' . $return_button;
    } else {
      return $return_button;
    }
  }

Did you change the dates on your site or did you find something on this? :unsure:

:blink: I'm not sure what you mean?

Since we are October 1st now, the products are available for purchase. I could create a product for testing with today's date if you need.

But I did not change anything in the code, if that is your question.

Using the same Category, make 1 product September 30 and 1 product October 1 and one product October 2 ...

Then, before looking in the Catalog, go to phpMyAdmin and search the table:
products

for those products_id and see what date is in the field:
products_date_available

Then, let's go to the Catalog and see what shows ...

From what I can see you need to change this line:

    case ($zc_current_date > 0 && $zc_current_date >= $upcoming_date_check):

to read:

    case ($zc_current_date > 0 && $zc_current_date > $upcoming_date_check):

The way to test this is to go into phpMyAdmin and add the dates to the:
products_date_available

for:
2011-09-29 00:00:00
2011-09-30 00:00:00
2011-10-01 00:00:00
2011-10-02-00:00:00

What will happen now is only the 10-2 will be marked Available ...

Browsing in phpMyAdmin you will see the all of the dates ...

Edit the Product in the Admin and any that are old dates will blank out the Product Date Available on or after the expired date has happened ...

Hi!

Just wanted to let you know I changed the code, and now my products are now available on the release date.

Thank you!

Thanks for the update that this worked for you ... :smile:

did u know which add on was used - id love this on my site :)