Back In Stock Notifications

conor:

Hi,
The only situation in which this could possibly happen is if the customer subscribed to the notification has deleted their account, in which case after the notification is sent out the e-mail to them should fail and the record be deleted.

All the best..

Conor
ceon
Hi Conor,

I think that's exactly what happened as the name that was left is one that i use for testing a lot and that is about the only account that gets deleted once in a while.

However, the record doesn't get deleted, it results in the error described previously. No problem tough, shouldn't happen in any "normal" situation.

Thanks!
Jeroen

Hi Conner, I have exactly the same error. All mail functions work fine, except sending the actuall notification that the product is back in stock :( I have a complete new/fresh zencart installation.

I will try a fresh install tonight and let you know.

In reference to the above post#475

I found that the solution for full language dependence in email templates was by replacing...What EXACTLY was not working?

I have duplicated the templates into the /es folder below the /email root and in my testing all emails are sent in the same language as that selected at the moment of use, correctly.

(The only changes I have made have been to replace the hard-coded "Dear" and "Link" with defines, otherwise it has worked correctly.)

Hopefully useful -

We briefly used "Product Notifications" before realizing "Back In Stock Notifications" existed.

After installation we wanted to add the 2,500 customers who signed up for under Product Notifications into the BISN table. Here is the SQL I used- hopefully it is of use to anyone else needing to do the same. (no warrantees, guarantees, etc).

Note that we use zen_ before table names- remove that if you don't. It is assumed that all Product Notification customers have a customer_id (login) since they aren't allowed to signup otherwise...

INSERT into zen_back_in_stock_notification_subscriptions
(
product_id,
customer_id,
name,
email_address,
date_subscribed
)
SELECT products_id, pn.customers_id, CONCAT(customers_firstname,' ',customers_lastname), customers_email_address, date_added
FROM zen_products_notifications pn, zen_customers c
where pn.customers_id = c.customers_id

If there is anything wrong with my SQL, or doing this was a Bad Thing to have done, do please let me know!

edit: Just realized you don't actually need the email for registered customers- it is null for rows with a customer_id, so you could delete that part...

Hi,

jgreene:

If there is anything wrong with my SQL, or doing this was a Bad Thing to have done, do please let me know!

No, that's a good idea, and it looks like it (has) will work just fine.

Working on a small update to the module today, hopefully release it soon, so look out for that.

All the best...

Conor
ceon

Hi,

I'm very happy to say that (at long last) the new version of the software has been released.

This thread is officially closed as the issues discussed here have been fixed in the new version.

Please use the new thread for any support queries.

Enjoy the new version! We hope it continues to bring success to your stores!

All the best..

Conor
ceon

I am running version 1.3.9h so Back In Stock Notification was installed simultaneously.
My question is...Can the subscriber be notified EACH and every time the product becomes Back In Stock?
It is imperative because I happen to have many on the Waiting List and can make available only a few plants each time.
It seems the customers who do not respond immediately are never again notified the next time I offer the plant.

Please advise if there is anything I can do or add on to make this change.
Thanks so much!
Joni

I am running version 1.3.9h so Back In Stock Notification was installed simultaneously.
Eh? BISN is an add-on.

Please advise if there is anything I can do or add on to make this change.

..reading post #489 would be your best step.

SRQHoyas:

I am running version 1.3.9h so Back In Stock Notification was installed simultaneously.
My question is...Can the subscriber be notified EACH and every time the product becomes Back In Stock?
It is imperative because I happen to have many on the Waiting List and can make available only a few plants each time.
It seems the customers who do not respond immediately are never again notified the next time I offer the plant.

Please advise if there is anything I can do or add on to make this change.
Thanks so much!
Joni

Your best bet is ask the question over in the new thread for Ceon Back In Stock Notifications 3.0.0
This is the thread for the old version.

Hello!
I would like to install this, but it said in the plugin thread that it changes the buy now, with notify when back in stock. On my page people can still buy products that is out of stock, and they will be first in line when the items are back in stock. Is there an option that there is just the box beneath the product description that customers can be mailed when they are back in stock, and other can still buy things that is not in stock?

-Kjetil Hansen

Hi,

kjetilhansen:

I would like to install this, but it said in the plugin thread that it changes the buy now, with notify when back in stock. On my page people can still buy products that is out of stock, and they will be first in line when the items are back in stock. Is there an option that there is just the box beneath the product description that customers can be mailed when they are back in stock, and other can still buy things that is not in stock?

I'm answering this in the correct thread for the latest version.

All the best...

Conor
ceon

On the admin side on the list of Products with Subscriptions, is it possible to add a column showing the model number? This would definitely help when I'm reordering products. I am using Zen 1.5. Thanks.

Hello,

I am trying to send out back in stock notifications and it comes up with an error basically stating it cannot send to customer x.
When I list all subscriptions I can see the products and the one that customer x wants to know about but it appears they didn't enter their email address - so that field is blank.

How can I remove this entry so that the other 100 odd notifications can go out?

Phil
https://www.colourpatch.com.au

I regret to inform you that Conor unexpectedly passed away. Please see http://www.zen-cart.com/showthread.php?202939
Of course, do post your message as others may be able to help you with this module.

Hello,

I am using this module(Ceon back in stock notification) but it doesn't seems to be working.

Firstly is is not showing on front end and also in admin end it is not present in configuration section.

In admin section it is under catalog section where we can send email and pending notifications.

Thanks
Beenu

testingclient:

Hello,

I am using this module(Ceon back in stock notification) but it doesn't seems to be working.

Firstly is is not showing on front end and also in admin end it is not present in configuration section.

In admin section it is under catalog section where we can send email and pending notifications.

Thanks
Beenu

If you are using zen cart v1.3.9h go back and make sure you installed the module right. Sounds like you didn't install it right. It is very well documented so read the doc again.

Your best bet is ask the question over in the new thread for Ceon Back In Stock Notifications 3.0.0
This is the thread for the old version. If you ask in the other thread it will be the same answer check you insulation again.

Conor Kerr Ceon passed away from a brain tumor last week. He will be missed in the Zen Cart community, I am sure!

Our back in stock module seems to have stopped working.
Normally it is because someone has subscribed to a product and forgets to add their email address and I have to run an sql patch to remove the product from the list which fixes the issues.

This time however when I do a test run of emails there is one entry that shows the customers name but no email address and no product indicated - and so nothing will mail out.
Can anyone advise how to remove a 'phantom' entry???
Until this is done no back in stock emails will go out.

Phil

Found the answer.
Post this into the SQL functions area.
The XXX is the product ID for the item you want to remove the listing for.

delete from back_in_stock_notification_subscriptions where product_id = XXX;

Noticed a small bug in 3.2.0 that gives users a broken link to the product page from their subscriptions list under "My Account"

To fix, just need to edit the includes/templates/template_default/templates/tpl_account_back_in_stock_notifications_default.php file:

Line 166: change from:

$product_page = zen_get_info_page($subscribed_notification_lists[$i]['id']);

to:

$product_page = zen_get_info_page($subscribed_notification_lists[$i]['product_id']);

... and line 169 change from:

'products_id=' . $subscribed_notification_lists[$i]['id'], $request_type);

to:

'products_id=' . $subscribed_notification_lists[$i]['product_id'], $request_type);