Back In Stock Notifications

server delay double post -edited out

Conor,
Could your batch script be used to execute only x emails and stop? Would it clean them out properly or would it wipe the entire table clean after the first batch?
I wouldn't mind hanging out with the admin panel for an hour hitting the button 40 times if it meant saving myself from spam purgatory with the likes of aol and others.

Hi,

brushwoodnursery:

So, i ran the test with the batch size at 10 and the sleep at 20 seconds. Goes to blank page in just over 1 minute.
maybe it's my database connection?

Hmm, something's definitely timing out. It could be the DB connection. I'm afraid I don't know enough about this area. If it is the DB connection though then the function would have to be changed to store all of the results and then send the e-mail batches.

I'll try to look at it in the future when I've some time on my hands!

Sorry I can't give a better response than that! :(

All the best...

Conor

OK, you have until August before I begin pestering you again!

Thanks for trying!

Conor

I just downloaded your addon and installed it, but I don't see the notification/subscription link next to the product in the product info page. Is there something I need to turn on in the admin tool? Thanks.

Hi,

jordisan10:

I don't see the notification/subscription link next to the product in the product info page.

Is the product out of stock with a quantity in stock of zero? It won't show if the stock is at a negative level. A new version of the module will be out shortly that supports negative stock levels (-1, -2 etc.).

If that's not it then you mustn't have copied across the template modifications properly.

Hope that helps!

All the best...

Conor

Yes, product quantity is set to 0, but the radio button in the edit product page is set to in stock (if I check out of stock, the product becomes not available and is not visible to customers).

If that's not it then you mustn't have copied across the template modifications properly.

Anything I had to do here other than copying files across?

Thank you.

Works like a charm. Thanks dude!

I'll check out your shipping add-ons too.

Hi,

No problem. :)

Look out for a new version sometime next week with e-mail throttling! :)

All the best...

Conor
Ceon

Hello Conor,
This mod looks like an excellent add-on for our shop and i can't wait to put it live, however, during test i ran into an issue i'ld like to share.

When i subscribe from an existing account all goes well, but i can't find the unsubscribe option in the account details.
Can you give me a pointer where i should look and find out why the unsubscribe is not available in the account details?

i do run a shop that is only available in the dutch language and english is not active, maybe that's related somehow?

Cheers,
Jeroen

Hi Jeroen,

It sounds like you haven't installed the module properly. You must copy the updated template fiels for the account section to the templates directory for your site, or modify any existing template files, adding in the code requierd for the Back In Stock Notification Subscriptions section to appear in the My Account section.

Hope that helps.

All the best...

Conor

conor:

Hi Jeroen,

It sounds like you haven't installed the module properly. You must copy the updated template fiels for the account section to the templates directory for your site, or modify any existing template files, adding in the code requierd for the Back In Stock Notification Subscriptions section to appear in the My Account section.
Conor
Hello Conor,

Thanks, i just figured out that it could only be in the tpl_account_deault and then i read your post :smile:
The file is there, it is modified properly, and it is in my includes\templates\MY_TEMPLATE\templates but somehow this template simply isn't picked up by zen-cart. (the unsubscribe from newsletter is in the file as well, but not showing either) I have seen that before and i am probably going to solve it by putting it in the core unfortunately.

Anyway, not related to your mod i guess, thanks anyway,
Jeroen

nagelkruid:

Hello Conor,
This mod looks like an excellent add-on for our shop and i can't wait to put it live, however, during test i ran into an issue i'ld like to share.

When i subscribe from an existing account all goes well, but i can't find the unsubscribe option in the account details.
Can you give me a pointer where i should look and find out why the unsubscribe is not available in the account details?

i do run a shop that is only available in the dutch language and english is not active, maybe that's related somehow?

Cheers,
Jeroen
Ok, those options depend on the "display newsletter unsubscribe option" which i have disabled because i don't want the link in the sidebox. However, disabling in the sitebox means also disabling these options under the account settings which -off course- is not my intent.

Just wanted to add that info if anyone else comes accross it.

I am ready to "go live", thanks! :D

2 more remarks that may help or not

• maybe you should consider to advice in the readme to include account_back_in_stock_notifications to the ROBOTS_PAGES_TO_SKIP in the file meta_tags.php so robots are advised not to index this page.

• i encountered an error during subscribing as a customer that the email_template couldn't be found in my_path/email/nl/email_template....

I created an nl folder and copied the templates in there so pretty easy to solve, i was just surprised as i never had that before.
(also surprised that i could read my whole path(!) in there as a customer, mmm)

Maybe those are worth looking at next time you are looking at the module.

Cheers,
Jeroen

Hi Jereon,

nagelkruid:

Ok, those options depend on the "display newsletter unsubscribe option" which i have disabled because i don't want the link in the sidebox. However, disabling in the sitebox means also disabling these options under the account settings which -off course- is not my intent.

Ahh. I should have anticipated that some people might choose some "bizarre" options (running the BISN module but not availing of Zen Cart's product notifications!)

I'll adapt the code to always display the back in stock notifications unsubscription section, regardless of whether or not the product notification subscriptions and newsletter subscription sections are being displayed.

nagelkruid:

maybe you should consider to advice in the readme to include account_back_in_stock_notifications to the ROBOTS_PAGES_TO_SKIP in the file meta_tags.php so robots are advised not to index this page.

I'm guessing you meant the subscription page and unsubscription page? Obviously robots can't access anywhere in the account section as you have log in first. I think I'll add advice about adding the two subscription handling pages to the meta tags file. (More and more features to add to the module...).

nagelkruid:

encountered an error during subscribing as a customer that the email_template couldn't be found in my_path/email/nl/email_template....

That's a Zen Cart issue and nothing to do with the module itself. So rather than document standard Zen Cart features I feel that there's no need to add extraneous information to the docs.

Glad you like the software!

All the best...

Conor
Ceon

conor:

Glad you like the software!

Ceon
It is excellent, thanks a lot, will check out the ship mod in a few as well, cheers.

nagelkruid:

It is excellent, thanks a lot, will check out the ship mod in a few as well, cheers.
hah, still very happy with this mod, people like to use it too...

i just looked at re-enabling product notifications as well but when those are enabled i actually want to disable the checkbox when it isn't on stock for the product notification so people don't get confused.

I did this by adding code to includes/modules/sideboxes/product_notifications.php right under the first check

if ($show_product_notifications == true) {
$check_query = "select count(*) as count
                      from " . TABLE_PRODUCTS . "
                      where products_id = '" . (int)$_GET['products_id'] . "'
                      and products_quantity != 0";
       $check = $db->Execute($check_query);
       if ($check->fields['count'] <= 0) {
        $show_product_notifications= false;
       }
    else {
        }            
}

Now it doesn't show the product notification sidebox when the product isn't on stock.

don't mean to spam your thread, thought it was related enough to make a note of it here.

Cheers,
Jeroen

Hi Jeroen,

nagelkruid:

hah, still very happy with this mod, people like to use it too...

Yes, I'm hearing that it seems to make a real difference to sales, which is nice to hear! Still working on a new version with a few modifications, will have a release sometime this month!

I do have a suggestion for your code. Instead of:

nagelkruid:

$check_query = "select count(*) as count
from " . TABLE_PRODUCTS . "
where products_id = '" . (int)$_GET['products_id'] . "'
and products_quantity != 0";
$check = $db->Execute($check_query);
if ($check->fields['count'] <= 0) {
$show_product_notifications= false;
}

You could use the following, as it is a little "cleaner" and copes with products that have a negative stock level (which does happen and is one of the main changes in the forthcoming version of the module):

$check_query = "SELECT products_quantity
FROM " . TABLE_PRODUCTS . "
WHERE products_id = '" . (int) $_GET['products_id'] . "';";

   $check = $db->Execute($check_query);
   
   if ($check->fields['products_quantity'] <= 0) {
    $show_product_notifications= false;
   }

>
> don't mean to spam your thread, thought it was related enough to make a note of it here.

No problem.. thought I may as well make the code cleaner if it was going to be used by anyone else! :)

All the best...

Conor
[Ceon](http://dev.ceon.net)

conor:

No problem.. thought I may as well make the code cleaner if it was going to be used by anyone else! :)

Hah! I started out with that statement but i couldn't get it to work, don't remember the exact error but after a few hours i gave up and came up with the count (which i knew was second best)

Now i pasted your code in and it works like a charm.
Something tells me my php learning curve has just started :smartalec:

thanks for the input.
Jeroen

DISSAPPEARING WEBSHOP!..

Hi,

Im very pleased that you took the time to make this very useful add-on. I have installed it according to instructions (I have yet to install the database) and hope someone can help me out?
After I installed it my webshop dissappeared... Not good.. I do have a Norwegian override template on it, could that be the problem? I have not yet installed the database, could this explain why my entire webshop have disapperaed? I dont get any errormessages, just a white page. (https://www.fjellanger.net/webshop).
Im a newbie with too little knowledge of php, html etc, so its hard for me to figure out what could have gone wrong. Looking at the names of the files that I have installed (uploaded), it doesnt seem to be any that should warrant my entire site to not show?

Also - I see the add-on comes with pictures, but it doesnt say anywhere in the installation instruction to put them on the server? Should they simply just be put in the image folder in the zen-cart installation?

Thanks a million in advance for any help that can make my website show up again!

Ruth ;)