Request Restock Mod Thread

I'm working on a new version that allows you to set that.

yellow1912:

I'm working on a new version that allows you to set that.

Coool, Thank you :)

A new version, alpha 3.6 is now available on svn:
https://svn.rubikintegration.com/zencart_mods/request_restock/

This version includes a new feature:

Allow store owners to set the email format:

1. Always sent out in html form
2. Always sent out in text form
3. Always sent out in text form to unregistered customers (for registered customers, it depends on their references)
4. Always sent out in html form to unregistered customers (for registered customers, it depends on their references)

This version is NOT fully tested. It will NOT be uploaded to the download section until I have the time to test it or someone can download, test it for me and let me know if it works.

I've just import, from old version of mysql, my zencart database on new mysql version 5.0.45, but the problem always remain:
no dropdown in admin.

I've just upload all the file of latest version: all work well!
yellow1912 is a great person!
He has follow me to solve the problem, and finally the problem has solved!
I wish to yellow1912 the best way to success!

Well I've been using this for some time now and can't say how much of a help it's been.

A couple features that I think would bring it to the next level would be as follows.

1. Ability to generate a print friendly report.
2. Ability to sort items by quantity requested.
3. Being able to easily change how many items to display per page.

I'm not sure how easy or hard this would be but think these few thing would add a great deal of functionality to the mod.

I have been using the data generated by this to figure out where i need to focus my inventory purchases when budget is an issue and we are starting to see good results.

Thanks again for all your work on this.

Mike

HELP NEEDED!

ive installed the mod version 'alpha3.5' but having problems :(
the admin side seems to work and can be viewed properly (so-far) but i cant seem to see the customer side? :dontgetit
im basically not seeing any of the restock options, could this be anything to do with the sold out logo and stuff?

PLEASE HELP :D

:oops:

MY BAD! copied some of the code in wrong :blush:
No need for help now :) (except mental lol)

:oops:

Hi!
was wondering if any of you guys could help me?

im wanting to replace the 'SOLD OUT' icon with a restock one (i know just replace the picture lol) but with the added extra of this GR8 mod linking from the pic?

in english the sold out icon changed to a resock one which when clicked links to this GR8 mod?

PLEASE HELP? :D

How can I change the "Request Restock" text?
Please, answer, it's urgent :blush:

to change the text:
edit: includes/languages/english/your_template/request_restock.php

thanks:blush::clap:

I installed Request Restock alpha 3.5 about two weeks ago. The drop down menu on the admin/request_restock.php page was and continues to be blank... none of the option values are displayed. It appears that my symptoms are the same as those reported above by 100asa, which appear to have been solved in his case. The screen shot that he posted shows the same problem I'm describing.

After installing the mod, I upgraded both PHP and MySQL from 4 to 5. I'm now running MySQL 5.0.45-community and PHP 5.2.4. After the upgrade, the drop down menu still didn't appear in the admin. I've completely re-installed this mod twice... uploading all the files and dropping/recreating the database tables. The "front end" works fine. The automatic emails are sent when customers request a restock, and their requests are saved in the database. I just don't have a functional admin page. I've tried every suggestion posted in this forum. Unlike asa100, my store is in English. I'd appreciate any suggestions.
Thanks,
Alan

For those having such problem, please try this file:
upload it to admin/request_restock.php, overwrite the old file when asked.

Problem solved.
Thanks!
Alan

alanpace:

Problem solved.
Thanks!
Alan

I spoke to soon. Using the file you attached, the options are now shown in my drop down menu, but I get this SQL error when I choose the "Send notices to customers" option:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address]
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.

Do you know what might cause this?
Thanks,
Alan

Try this in your phpmyadmin, let me know if you get the same error:

update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address)

PS: If you have prefix for your zen table, you may have to use this:

update zen_products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from zen_customers c where c.customers_email_address = r.email_address)

// Replace zen_ by your prefix name (if you use a different one)

yellow1912:

Try this in your phpmyadmin, let me know if you get the same error:

update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address)

PS: If you have prefix for your zen table, you may have to use this:

update zen_products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from zen_customers c where c.customers_email_address = r.email_address)

// Replace zen_ by your prefix name (if you use a different one)

I used the first query you suggested since I don't have a table prefix, and got this error:

Unknown column 'r.zen_customers_id' in 'field list' 

I then removed the zen_ prefix from zen_customers_id in the query, tried it again and got this error:

#1054 - Unknown column 'r.customers_id' in 'field list' 

I checked my products_restock_request_customers table, and there's no customers_id field in the table, although it does have an ID field. I then changed r.customers_id to r.ID and ran the query without an error.

Should the products_restock_request_customers table have a customers_id field? Here's the code from the "new install" SQL packaged with alpha 3.5:

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;

Thanks,
Alan

Im looking at the sql query closely this time, there is something weird here:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address]
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.
Where did you download this version? Did you download it from download section here?
Because I re-downloaded this version from download section and can not find this line of code anywhere.

yellow1912:

Im looking at the sql query closely this time, there is something weird here:

Where did you download this version? Did you download it from download section here?
Because I re-downloaded this version from download section and can not find this line of code anywhere.

Thank you for getting back to me so fast... I was already typing a message to tell you to ignore that last post. I re-uploaded all the files and I'm not getting the error anymore. Over the last week or so, I've tried every hot fix and code update posted in this forum, so I managed to revert some of the code back to where it was at the time the fix was posted... and then I forgot I'd made the changes. Hopefully I've got it working now...
Thanks,
Alan