Request Restock Mod Thread

yellow1912:

No, it's the newest

Are you sure that you uploaded all the files in the folder "email" to your corresponding folder on the server?

Great add-on! Everything works well except that I'm having the same email issue as the previous poster. The is no active link within the notice to the customer once the item has been re-stocked. I did confirm and re-loaded the file within the mods "email" folder. You say "all the files" but there is just the one: email_template_request_restock.html Is that an issue?

I'm running zen version 1.3.6

Thanks

Yes, it is the only file there. You upload it to the already existing 'email' folder which already has several other email templates right?

Also open the file admin/includes/functions/extra_functions/request_restock.php, check line 105, does it look like this:

$error = zen_mail($name, $email, $subject, $email_text, STORE_NAME, EMAIL_FROM, $html_msg, 'request_restock');

Ok, I found the problem, it happens when you send email as text, not html. I will look into it and try to fix this as soon as possible.

Regards.

yellow1912:

Yes, it is the only file there. You upload it to the already existing 'email' folder which already has several other email templates right?

Also open the file admin/includes/functions/extra_functions/request_restock.php, check line 105, does it look like this:

$error = zen_mail($name, $email, $subject, $email_text, STORE_NAME, EMAIL_FROM, $html_msg, 'request_restock');

Thanks for the quick response - Yes, that is the folder I uploaded to and yes, the request_restock.php codes do match exactly.

I'd like to thanks MeltDown for being very patient and helped me a lot to fix this. The hot fix:
Download:
File
https://svn.rubikintegration.com/zencart_mods/request_restock/admin/includes/functions/extra_functions/request_restock.php

Then upload it to your server, overwrite the old file.

This fix will be included in a new version later.

Great mod!!!
I've a little question.
Box for message is irregular:
http://www.100asa.it/sony-4-rulli-di-carta-13x18-per-updr150-p-1355.html?language=en
I've set it to 20, but nothing change.
And then in admin/catalog-->request in option dropdown I see no choose.
Question: email to customer when the stock back to >1 send automatically, or I send it to them?

for testing I have request restock for a product, and I've change the stock to 50, but I haven't receive the email notification to back in stock.

After changing it to 50, have you run the "Send notices to customers ...." in admin->catalog->request restock?

the problem is this: in admin->catalog->request restock I see the option dropdown blank! without no option!

Make sure you have all the files uploaded correctly. It'd be great if you can go to admin->catalog->request restock, then on that page right click to view source code, copy those and attach it here.

Regards.

<!-- header_eof //-->
  <table border="0" width="100%" cellspacing="0" cellpadding="0">
   <tr>
    <td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td>
   </tr>
   <tr>
    <td class="pageHeading">Request Restock Admin</td>
   </tr>
   <tr>

    <td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="15"></td>
   </tr>
  </table>
 
<div id="actionSelector">
<form name="request_restock" action="http://www.100asa.it/back100asa/request_restock.php" method="GET">	<fieldset id="actionSelectorForm">
		<label class="inputLabel" for="option" style="float:left; width: 7em;">Options</label>
		<input type="hidden" name="action" value="send" />
		<select rel="dropdown" name="option"><option value=""></option><option value=""></option><option value=""></option><option value=""></option><option value=""></option></select>	</fieldset>

<div><input type="submit" value="Go!" /></div>
</form>
</div>

  <table border="0" cellspacing="1" cellpadding="2" align="center">
   <tr>
    <td colspan="2">
		<span class="forward">
			Visualizzati da<strong>1</strong> a <strong>4</strong> (di <strong>4</strong> prodotti)Pagina 1 di 1		</span>

    </td>
   </tr>
   <tr class="dataTableHeadingRow">
    <td class="dataTableHeadingContent">Product Name</td>
    <td class="dataTableHeadingContent">Request Quantity</td>
    <!--<td class="dataTableHeadingContent"></td>-->
   </tr>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">

    <td class="dataTableContent">
		<a href="http://www.100asa.it/index.php?main_page=product_info&products_id=1504" target="_blank">SONY 2 rulli di carta 10x</a>...	</td>
    <td class="dataTableContent">
		20	</td>
    <!--<td class="dataTableContent">
			</td>-->
   </tr>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">

    <td class="dataTableContent">
		<a href="http://www.100asa.it/index.php?main_page=product_info&products_id=380" target="_blank">Zebra Ribbon wax 64x74</a>	</td>
    <td class="dataTableContent">
		40	</td>
    <!--<td class="dataTableContent">
			</td>-->
   </tr>
	<tr>

    <td colspan="2">
		<span class="forward">
			Visualizzati da<strong>1</strong> a <strong>4</strong> (di <strong>4</strong> prodotti)Pagina 1 di 1		</span>
	</td>

   </tr>
</table>

<!-- body_eof //-->
<!-- footer //-->
<div class="footer-area">
<table border="0" width="100%" cellspacing="8" cellpadding="8">
  <tr>
    <td align="center" class="smallText" height="100" valign="bottom">100asa.it © 2003 - 2006 <br />Versione <a href="http://www.100asa.it/back100asa/server_info.php">Zen Cart v1.3.5/v1.3.5</a></td>

  </tr>
</table>
</div>
<!-- footer_eof //-->
<br />
</body>
</html>

Download the latest version, reupload admin/request_restock.php

I've already installed the latest version alpha 3.3 !

Yes, but request_restock.php is not doing what it should do, that's why I ask you to re-download and the re-upload it.

Done! re-download, re-upload it.
The same! :-(

Yes, but request_restock.php is not doing what it should do, that's why I ask you to re-download and the re-upload it.

BTW, what is the version of your php?

PHP Version 4.4.7
it's strange, but I don't find solution!
another strange thing: the second request you see, I've write it for test, 20 quantity; why show me 40?
it's possible send automatic notification email when stock back to >1?

First thing first, we have to solve the mystery why the drop down list does not appear. So attach the content of that file(request_restock.php) on your server here

the file I use in admin, request_restock.php is the same of your mod, alpha 3.3

<?php
/**
 * Request Restock Alpha 3/2
 * By RubikIntegration team @ RubikIntegration.com
 * Made for ZC 1.3.7
 * Released under the GNU General Public License
 */

require('includes/application_top.php');

$options = array (0 => array(id => 1,
							 text => 'List total requested quantity per product'),
				  1 => array(id => 2,
							 text => 'List all requests sort by product'),
				  2 => array(id => 3,
							 text => 'Check and Update deleted products'),
				  3 => array(id => 4,
							 text => 'Send notices to customers'),
				  4 => array(id => 5,
							 text => 'Clean up requests')
						);

if (!isset($_GET['option']) || !is_numeric($_GET['option']) || (int)$_GET['option'] < 1 || $_GET['option'] > 5)
	$_GET['option'] = 1;

switch($_GET['option']){
	case 1:
		$products_query_raw = "select r.product_id, sum(r.request_quantity) as request_quantity, d.products_name from ".TABLE_PRODUCTS_REQUEST_RESTOCK_RECORDS." r,".TABLE_PRODUCTS_DESCRIPTION." d WHERE r.request_status = 0 and d.products_id = r.product_id group by r.product_id order by d.products_name asc";
		$products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
		$products_values = $db->Execute($products_query_raw);
	break;
	case 2:
		$requests_query_raw = "select c.name, c.email_address, r.request_quantity, r.request_message, r.product_id, d.products_name from ".TABLE_PRODUCTS_REQUEST_RESTOCK_RECORDS." r,".TABLE_PRODUCTS_REQUEST_RESTOCK_CUSTOMERS." c,".TABLE_PRODUCTS_DESCRIPTION." d WHERE r.request_status = 0 and d.products_id = r.product_id AND c.id = r.customer_id order by r.product_id asc";
		$requests_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $requests_query_raw, $requests_query_numrows);
		$requests_values = $db->Execute($requests_query_raw);
	break;
	case 3:
		update_requests();
	break;
	case 4:
		process_notices();
	break;
	case 5:
		clean_up_requests();		
	break;
}

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
<script language="javascript" src="includes/menu.js"></script>
<script language="javascript" src="includes/general.js"></script>
<script type="text/javascript">
  <!--
  function init()
  {
    cssjsmenu('navbar');
    if (document.getElementById)
    {
      var kill = document.getElementById('hoverJS');
      kill.disabled = true;
    }
  }
  // -->
</script>
</head>
<body onload="init()">

<div class="header_area">
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
</div>
<!-- header_eof //-->
  <table border="0" width="100%" cellspacing="0" cellpadding="0">
   <tr>
    <td><?php echo zen_draw_separator('pixel_trans.gif', '100%', '10');?></td>
   </tr>
   <tr>
    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
   </tr>
   <tr>
    <td><?php echo zen_draw_separator('pixel_trans.gif', '100%', '15');?></td>
   </tr>
  </table>
 
<div id="actionSelector">
<?php echo zen_draw_form('request_restock', FILENAME_REQUEST_RESTOCK, '', 'GET'); ?>
	<fieldset id="actionSelectorForm">
		<label class="inputLabel" for="option" style="float:left; width: 7em;"><?php echo OPTION_NAME; ?></label>
		<input type="hidden" name="action" value="send" />
		<?php echo zen_draw_pull_down_menu('option', $options, $_GET['option']); ?>
	</fieldset>
<div><input type="submit" value="Go!" /></div>
</form>
</div>

<?php if (isset($_GET['option']) and $_GET['option'] == 1){ ?>
  <table border="0" cellspacing="1" cellpadding="2" align="center">
   <tr>
    <td colspan="2">
		<span class="forward">
			<?php 
				echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS);
				echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
			?>
		</span>
    </td>
   </tr>
   <tr class="dataTableHeadingRow">
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_NAME;?></td>
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_REQUEST_QUANTITY;?></td>
    <!--<td class="dataTableHeadingContent"><?php //echo TABLE_HEADING_UPDATE_REQUEST;?></td>-->
   </tr>
<?php
while (!$products_values->EOF) {
?>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
    <td class="dataTableContent">
		<?php echo process_product_name($products_values->fields['products_name'],$products_values->fields['product_id']);?>
	</td>
    <td class="dataTableContent">
		<?php echo $products_values->fields['request_quantity'];?>
	</td>
    <!--<td class="dataTableContent">
		<?php //zen_draw_checkbox_field('selections[]', 1, 1); ?>
	</td>-->
   </tr>
<?php
	$products_values->MoveNext();
}
?>
	<tr>
    <td colspan="2">
		<span class="forward">
			<?php 
				echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS);
				echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
			?>
		</span>
	</td>
   </tr>
</table>
<?php } elseif(isset($_GET['option']) and $_GET['option'] == 2) { ?>
  <table border="0" cellspacing="1" cellpadding="2" align="center">
   <tr>
    <td colspan="5">
		<span class="forward">
			<?php 
				echo $requests_split->display_count($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_REQESTS);
				echo $requests_split->display_links($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
			?>
		</span>
   </td>
   </tr>
   <tr class="dataTableHeadingRow">
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_NAME;?></td>
	<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_REQUEST_QUANTITY;?></td>
	<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_NAME;?></td>
	<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_EMAIL;?></td>
	<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_REQUEST_MESSAGE;?></td>
    
    
   </tr>
<?php
while (!$requests_values->EOF) {
?>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
    <td class="dataTableContent">
		<?php echo process_product_name($requests_values->fields['products_name'],$requests_values->fields['product_id']);?>
	</td>
    <td class="dataTableContent">
		<?php echo $requests_values->fields['request_quantity'];?>
	</td>
    <td class="dataTableContent">
		<?php echo $requests_values->fields['name'];?>
	</td>
	<td class="dataTableContent">
		<?php echo $requests_values->fields['email_address'];?>
	</td>
	<td class="dataTableContent">
		<?php echo $requests_values->fields['request_message'];?>
	</td>
   </tr>
<?php
	$requests_values->MoveNext();
}
?>
	<tr>
    <td colspan="5">
		<span class="forward">
			<?php 
				echo $requests_split->display_count($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_REQESTS);
				echo $requests_split->display_links($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
			?>
		</span>
	</td>
   </tr>
</table>
<?php } ?>

<!-- body_eof //-->
<!-- footer //-->
<div class="footer-area">
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
</div>
<!-- footer_eof //-->
<br />
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

this is the source of the page in admin section:

This might not be the error, but I have noticed that you use a different language instead of english. There are several language files that needed to be uploaded to 'eng', but since you don't use english to have to upload them to your language folder.