Request Restock Mod Thread

Glad we found the cause. Please let me know if there is still any error.

yellow1912:

Glad we found the cause. Please let me know if there is still any error.

Thank you very much for your help, yellow1912. I've tested all the functions and everything is working properly. :-)
Alan

Hi and thank you for this mod, I am hoping it will be good for my business.

I have just installed it, made sure I changed the TEST folders to my custom template name.

The link to RESTOCK REQUESTS is available in my admin area under the CATALOG tab. When I clicked it I got this error message:
1146 Table 'easybead_zc1.zen_products_restock_request_records' doesn't exist
in:
[select count(*) as total from zen_products_restock_request_records r,zen_products_description d WHERE r.request_status = 0 and d.products_id = r.product_id]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I then went to my PhP MyAdmin on my sever and there is no table named zen_products_restock_request_records. Do I have to create that myself?

Also, there is no REQUEST RESTOCK button visible at all in the product info page. See here: http://easybeading.com.au/index.php?main_page=product_info&cPath=1_2&products_id=18

I'm not sure if that is supposed to be turned on somewehre in admin or if it not curretnly available due to the error.

Thank you again.

Before anyone replies, and in case I am supposed to create my own table in PhP MyAdmin, what values do I enter for the table?

Thanks,
Raquel.

Did you run the sql patch that goes with the package?

No I didn't.

So to be sure before I do, I copy this from the new_install.sql file:
DROP TABLE IF EXISTS products_restock_request_customers;
CREATE TABLE products_restock_request_customers (
ID int(10) NOT NULL auto_increment,
name varchar (255) NOT NULL,
email_address varchar (255) NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS products_restock_request_records;
CREATE TABLE products_restock_request_records (
ID int(10) NOT NULL auto_increment,
customer_id int(10) unsigned NOT NULL,
product_id int(10) unsigned NOT NULL,
request_quantity int(10),
request_message text,
created_on int(10) NOT NULL default 0,
modified_on int(10) NOT NULL default 0,
request_status tinyint(1) NOT NULL default 0,
PRIMARY KEY (ID)
) ENGINE=MyISAM;

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Restock Requests';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Restock Requests', 'Set Restock Requests Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Restock Requests';

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Enable notification', 'RESTOCK_REQUESTS_NOTIFICATION_ENABLE', 'true', 'Enable/Disable sending restock notices. You only need to set this if you are using a cronjob to send out notices.', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'Limit number of emails', 'RESTOCK_REQUESTS_EMAIL_LIMIT', '0', 'Limit number of emails sent per time period set below. 0 means unlimited', @t4, 1, NOW(), NOW(), NULL, NULL),
('', 'Limit number of email based on', 'RESTOCK_REQUESTS_EMAIL_LIMIT_BASE', 'day', 'Only set this if you choose to limit number of emails sent out period', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''hour'', ''day''),'),
('', 'Admin Notification', 'RESTOCK_REQUESTS_ADMIN_NOTIFICATION', 'true', 'Send notice to admin each time a request is submitted', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

and paste it into admin/tools/Instal SQL Patches and that's it?

Thank you.

yup. Should work fine now.

Good, that did the trick and everything is still working.

However, there is no weher on my shop where customers can request sold out products. See here: http://easybeading.com.au/index.php?main_page=product_info&cPath=1_2&products_id=18

Am I supposed ti 'turn it on' somewhere in admin?

Did you edit the template file as instructed in readme file?

I've done that but it is very small and I'd like it to be moved to the right under the SOLD OUT image. How would I do that?

Thank you for your patience.

Replace:
includes/templates/EB/buttons/english/button_request_restock.gif
with a bigger image of your choice.

to place it right under the sold-out button, you may want to place the code inside the div "cartAdd".

Thank you, thats all good.

I have been trying to edit the email as it is coming up like this (see below) so I have no idea what product has been requested unless I log into admin.

VIEW CART | YOUR ACCOUNT | HELP
$EMAIL_GREETING

$EMAIL_WELCOME

Restock Summary:
Have any question? Please contact us
$PRODUCTS_DETAIL

Copyright (c) 2007 Zen Cart. Powered by Zen Cart
This email address was given to us by you or by one of our customers. If you feel that you have received this email in error, please send an email to [email protected]
This email is sent in accordance with the US CAN-SPAM Law in effect 01/01/2004. Removal requests can be sent to this address and will be honored and respected.

Also once the prodcut is back in stock and I send the customer a notification of it from the Restock requests tab, this is the email the customer receives"

We have restocked the products your requested. Check them out before they are out of stock again! EMAIL_GREETING

We have restocked the products your requested. Check them out before they are out of stock again! EMAIL_WELCOME

Restock Summary:
Have any question? Please contact us
We have restocked the products your requested. Check them out before they are out of stock again! PRODUCTS_DETAIL

We have restocked the products your requested. Check them out before they are out of stock again! EMAIL_FOOTER_COPYRIGHT
We have restocked the products your requested. Check them out before they are out of stock again! EMAIL_DISCLAIMER
We have restocked the products your requested. Check them out before they are out of stock again! EMAIL_SPAM_DISCLAIMER
We have restocked the products your requested. Check them out before they are out of stock again! EXTRA_INFO

And which file do I add code to to have the request restock button under the ...more info sold out image on the products list page?

Thank you again.

Your ZC version?

1.3.7.1

Hi yellow1912,

Great contribution - I've been looking for something like this to add to my site for a while now.

After installing the latest release everything works fine. However, I'm wondering if it's possible to automatically send out the 'back in stock' emails (instead of going to admin>catalog>request restock).

Thanks again for creating this contribution. :)

I think I wrote somewhere in the readme file that this is very possible to do so, and I even prepared a lock for that purpose.

Let me check.
Ok here it is:

While it's necessary to send out notices to customers once the products get restocked, we don't want to send 10 emails on the same day to just 1 customer if 10 of his requests are fulfilled on that day, do we? Normally, you can just update all your products quantity, then choose "Send notices to customers" (see Section II for more details), all the fulfilled requests of each customer will be combined into 1 email and sent to him/her.
However, if your site is hosted on a server that limit the number of emails can be sent per hour/day, you would have to repeat the action "Send notices to customers" several times, which is really irritating. This is when cronjob comes to save the day(I'm not gonna cover what cronjob is and how to use it in this document). However, what if you are in the middle of updating the products and cronjob kicks in and start sending out emails, it wouldn't be what we expect right? So this is the case when you need to turn off "Enable notification", then turn it on when you finish updating all your products.

You would need a php file with a few lines like this:

<?php
require('admin/includes/application_top.php'); 
require('admin/includes/functions/extra_functions/request_restock.php'); 
// depend on where you put this file, you need to change the pathsabove

process_notices(); // this function will process and send out emails
?>

Try it and let me know if it works.

@vivaraquel: sorry for the late reply, holidays _. Can you PM me with your site info?

Hi great mod!

I did a test on our test site and because most of our products have attributes (t-shirts and other clothing) and we use stock by attributes the module to keep stock take, this module really doesn't work the way we want it to as customers who need a large t-shirt cannot request a restock if all the other sizes are still in stock. Is there a way to integrate it into this module?

Can anyone help with making this mod compatible with stock by attributes so that a customer can request a restock of a certain attribute. This is very important for stores that use stock in accordance with attributes such as size and color. At the moment all of the products has to go out of stock thus the request for restock is not available until all stock is depleted, but it would be good if a customer could request a restock on a certain size or color when that stock level is available with the mod of stock by attributes.

Anyone???

Are there any plans to be able to export the restock request information to CSV?