Back In Stock Notifications

Hey, Conor. I think you may have addressed this in the past. Please forgive my laziness in not looking back through all of the posts but can you please tell me where I might find the place where it determines quantity in stock=0 and shows the notification box.
When I manually add products to an order in the admin using a mod, the quantity goes negative. The notification box disappears! I'd like to sub <-99 in place of =0.

Ridiculously long explanation:
There are a few products I wish to stop carrying but I want the residual search traffic to remain. In the description I will explain why we don't carry the product and will point to a better choice. If I set the quantity for that product as a very negative number, the box will disappear. Meanwhile, for those few orders' products I adjust manually from admin, the box will remain available even when the quantity in stock goes below zero.

Hi Dan,

How are you?

Hope you're having a good Easter break!

brushwoodnursery:

When I manually add products to an order in the admin using a mod, the quantity goes negative. The notification box disappears! I'd like to sub <-99 in place of =0.

The latest version of the module compares against <= 0.

You'll find the line you want to change in

includes/classes/observers/class.back_in_stock_notificationsProductInfo.php

at line number 56:

if ($products_quantity <= 0 && BACK_IN_STOCK_NOTIFICATION_ENABLED == 1) {

Hope that helps! :)

All the best...

Conor
Ceon

That's perfect, Conor. Cheers!

Installed on v1.3.7, all works well apart from when the customer logs into their accoutn to unsubscribe to notifications. The following error is displayed:

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
in:
[ SELECT bisns.id, bisns.product_id, pd.products_name, bisns.date_subscribed FROM back_in_stock_notification_subscriptions bisns LEFT JOIN products_description pd ON bisns.product_id = pd.products_id LEFT JOIN customers c ON c.customers_id = bisns.customer_id WHERE (bisns.customer_id = '2' OR c.customers_email_address = bisns.email_address) AND pd.language_id = '1';]

Mean anything to anyone?

chabbu:

Installed on v1.3.7, all works well apart from when the customer logs into their accoutn to unsubscribe to notifications. The following error is displayed:

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
in:
[ SELECT bisns.id, bisns.product_id, pd.products_name, bisns.date_subscribed FROM back_in_stock_notification_subscriptions bisns LEFT JOIN products_description pd ON bisns.product_id = pd.products_id LEFT JOIN customers c ON c.customers_id = bisns.customer_id WHERE (bisns.customer_id = '2' OR c.customers_email_address = bisns.email_address) AND pd.language_id = '1';]

Mean anything to anyone?

Don't worry, managed to fix it. It was due to differences in table and field collations. Changed them to latin1 general, just hope it doesn't have any adverse affects!

Hi,

chabbu:

Don't worry, managed to fix it. It was due to differences in table and field collations. Changed them to latin1 general, just hope it doesn't have any adverse affects!

That's what I was about to suggest! I don't there'll be any problems using latin1. :)

All the best...

Conor
Ceon

Hello Ceon,
Thank you for this mod!
please tell me how I can fix this issue:
I have a multilanguage site: https://www.usim.co.il and in english pages all works ok, but in russian and hebrew ( UTF-8) instead product name I have : “Ð�окиÑ� N73” (instead "нокиа N73")
link : http://www.usim.co.il/ru/nokia/%D0%9D%D0%BE%D0%BA%D0%B8%D1%8F-n73-p-859
same in hebrew
Thanks!

Hi Matt,

lankeeyankee:

I imagine the link being just like on the product info page, a text link under the out of stock image.

I'm very pleased to tell you that this has been added to version 2.4.0 of the module.

This should significantly increase the number of subscriptions and therefore sales on the site! (You're welcome! ;) ).

All the best...

Conor
Ceon

Hi,

I'm very pleased to release a new version of the module!

A great new feature is that it now adds links to the Back In Stock Notification subscription form for a product on every product listing page (categories listing, featured products listing etc.).

This should significantly increase the number of subscriptions/sign ups and therefore sales when the product is back in stock!
**
Instructions on how to modify the look of this link are included in the configuration documentation.**

Another change is that the template file can now be overridden by placing it in the templates folder for the template being used by the site.

From the Revision History:

[ADDED] Back In Stock Notification subscription form links are now displayed for sold out products on Product Listing pages (category listings, featured product listings etc). This should encourage a lot more customers to sign up to notification lists as it doesn't require them to click through to the product's page to see the subscription information!
[UPDATED] The template file can now be overridden by creating a copy and placing this copy in the templates folder for the template the store is using.
[BUGFIX] Only ISO-8859-1 characters were being correctly encoded for display. Module updated to use the current character set (UTF-8 etc.) when generating HTML entities.
[ADDED] Documentation added to the configuration about copying the template file to the store's template directory so that it can be modified.

Download the new version now!

(The new version of the module should also be available in the downloads area soon, just have to get a few seconds to repackage it).

Don't forget to read the upgrading documentation, it's easy enough to do but you must follow the upgrading documentation as this version requires a change to a core file (previous versions did not). Any questions about the link not appearing in product listing pages will be ignored.

Enjoy your increased sales!

All the best...

Conor
Ceon

conor:

Hi Matt,

I'm very pleased to tell you that this has been added to version 2.4.0 of the module.

This should significantly increase the number of subscriptions and therefore sales on the site! (You're welcome! ;) ).

All the best...

Conor
Ceon

Hi Conor,

How are you? I hope that all is well! I am sorry I haven't gotten back to you sooner, I have been incredibly busy.

Thank you thank you thank you thank you!!!!!! This is exactly what I was looking for and I am 100% confident that this is going to boost sales since everyone that signs up for the BIN wants to purchase the item.

I have sent you a thank you donation through Paypal and I would encourage all that can say thanks to do the same.:cool::yes::bigups:

Hi,

lankeeyankee:

How are you? I hope that all is well! I am sorry I haven't gotten back to you sooner, I have been incredibly busy.

I'm very well indeed, thanks, especially since you sent a donation, my first one in quite a while, thanks very much indeed for that! :)

lankeeyankee:

Thank you thank you thank you thank you!!!!!! This is exactly what I was looking for and I am 100% confident that this is going to boost sales since everyone that signs up for the BIN wants to purchase the item.

I thought you'd be pleased! I'm glad I could help you improve your store and once again am grateful that you have showed your appreciation by donating!

Enjoy the rest of your weekend! :)

All the best...

Conor

Hi Conor,

Thanks so much for creating this wonderful add-on :)

I've got a problem which I can't seem to fix.
Kindly refer to http://www.dermoglo.com/shop/index.php?main_page=product_info&cPath=1&products_id=8#back_in_stock_notification_form

I have set DUNE to be out of stock for testing purposes. If you look at the "notify me when back in stock" section at the bottom, it overlaps with the Sold Out button and another link that does the same job.

Please advise what I should do.

Also, is it possible to incorporate the Sold Out button into the box where customers fill out their details?

Thanks a bunch in advance!

I managed to fix it. :D

Hi,

soyabeane:

I managed to fix it. :D

I'm glad to hear that!

I'm sure it was just a small HTML/CSS customisation which was easy enough to do using the template?

All the best...

Conor

My subscription notification seems to be working but when I put the product back instock, it doesn't send out notification.

What am I doing wrong?

note i just change the stock number to 0 instead of changing the product status to out of stock. could this be the problem? because if i check products status to "out of stock" the product will not be listed on my website.

Hi,

geng77:

What am I doing wrong?

Not reading the documentation unfortunately! :)

The notifications aren't automatic. You have to use the notification section in the admin to manually send out notifications for any products which are Back In Stock.

You do indeed want to just set the stock level to zero and not have the product disabled, the module only shows the subscription notices/form for products that are enabled.

All the best...

Conor
Ceon

conor:

Hi,

Not reading the documentation unfortunately! :)

The notifications aren't automatic. You have to use the notification section in the admin to manually send out notifications for any products which are Back In Stock.

You do indeed want to just set the stock level to zero and not have the product disabled, the module only shows the subscription notices/form for products that are enabled.

All the best...

Conor
Ceon

LOL.. that was funny and you are right. :oops:

Hi,

geng77:

LOL.. that was funny and you are right. :oops:

Glad you're up and running now!

All the best...

Conor
Ceon

Hello Conor, This looks like it would be a useful mod for us. Is there a way to have the "Buy it Now" button and the “be notified when this product is back in stock...” buttons both available? We have regularly stocked items and items that are built to order. We would like to give the option of being notified or still be able to place an order for the item.

Hi,

micmed:

Hello Conor, This looks like it would be a useful mod for us. Is there a way to have the "Buy it Now" button and the “be notified when this product is back in stock...” buttons both available? We have regularly stocked items and items that are built to order. We would like to give the option of being notified or still be able to place an order for the item.

So people can order items that are out of stock or else simply sign up to find out when they are back in stock?

That would be possible but would require custom coding to have Zen Cart not display the sold out sign on your site yet still bring up the BISN subscription form.

Hope that helps!

All the best...

Conor
ceon