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!

Quote:

---

Originally Posted by 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:

PHP Code:

---

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?

Quote:

---

Originally Posted by 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,

Quote:

---

Originally Posted by 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: 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%9...1%8F-n73-p-859
same in hebrew
Thanks!

Hi Matt,

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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: