Request Restock Mod Thread

[yellow1912]

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

[alanpace]

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

[vivaraquel]

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

[vivaraquel]

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.

[yellow1912]

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

[vivaraquel]

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.

[yellow1912]

yup. Should work fine now.

[vivaraquel]

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?...products_id=18

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

[yellow1912]

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

[vivaraquel]

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.