server delay double post -edited out
Printable View
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,
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.Quote:
Originally Posted by brushwoodnursery
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,
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.).Quote:
Originally Posted by jordisan10
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).
Anything I had to do here other than copying files across?Quote:
If that's not it then you mustn't have copied across the template modifications properly.
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
Hello Conor,Quote:
Originally Posted by 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
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.Quote:
Originally Posted by nagelkruid
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,
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!)Quote:
Originally Posted by nagelkruid
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.
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...).Quote:
Originally Posted by nagelkruid
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.Quote:
Originally Posted by nagelkruid
Glad you like the software!
All the best...
Conor
Ceon
It is excellent, thanks a lot, will check out the ship mod in a few as well, cheers.Quote:
Originally Posted by conor
hah, still very happy with this mod, people like to use it too...Quote:
Originally Posted by nagelkruid
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
Now it doesn't show the product notification sidebox when the product isn't on stock.Code: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 {
}
}
don't mean to spam your thread, thought it was related enough to make a note of it here.
Cheers,
Jeroen
Hi Jeroen,
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!Quote:
Originally Posted by nagelkruid
I do have a suggestion for your code. Instead of:
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):Quote:
Originally Posted by nagelkruid
Code:$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;
}
No problem.. thought I may as well make the code cleaner if it was going to be used by anyone else! :)Quote:
Originally Posted by nagelkruid
All the best...
Conor
Ceon
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)Quote:
Originally Posted by conor
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. (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 ;)
By the way..
I installed the mysql database now, and it didnt make a difference.
Ruth :)
Hi,
If some of the global files hadn't uploaded properly then errors in them could stop your shop showing.Quote:
Originally Posted by Ruth1970
You'll have to try re-uploading all the files.
After that if you are still having trouble you should enable the display of errors on your site so you can see what is failing.
I'm afraid I can't help you with that, please search the forum and you'll find out how to fix problems with "blank pages".
Good luck!
All the best..
Conor
Ceon
Hi,
As promised previously, a new version of the module has been created with a few small updates and a bugfix. It isn't an essential release but it is still advisable to upgrade.
From the Release History:
[UPDATED] Subscription form now displays for stock levels of zero or less (not just products which have a stock level of exactly zero!).
[BUGFIX] Subscription management link is now always displayed in the the account section, when the module is enabled, regardless of whether or not “Product Notifications” are enabled/disabled for the site.
[UPDATED] Installation documentation updated with information on adding the subscription pages to the index of pages which should not be indexed by search engines (web robots).
[UPDATED] Other minor documentation updates.
You can download the new version from our website:
Download Now!
It will also be available from the downloads area in a few days.
All the best...
Conor
Ceon
Hi Conor,
Thanks for this great mod, like your other ones it is very well written!!
I came across this little formatting error when & quot ; (I can't do it in the forum without spaces or it will be converted to ") or & amp ; are used in the product title. It displays like this:
Simply enter your details below and we will send you an e-mail when “Tycoon Hammered Cowbell, 3 1/4" Silver”
I have to have the html character code because the " and & will get stripped from the page title bar in the browser plus Google Base uses XML files and " and & are not valid XML.
How would I go about changing this so that the text will convert the html character code into " and &?
Thanks!!
Matt
Hi Matt,
The double quote gets stripped from the title bar here, but the ampersand doesn't, it is correctly converted toQuote:
Originally Posted by lankeeyankee
.Code:&
I'm afraid that's a problem with the Google Base code then.. it should convert these characters correctly.Quote:
Originally Posted by lankeeyankee
You can't. What you should do is use the quote character and ampersand character in the product's title change the output code for the title tag and Google Base to properly convert/quote the characters.Quote:
Originally Posted by lankeeyankee
I can't comment on any Google functionality as I don't know about it but I found the line that gets rid of the quote in the title in includes/modules/meta_tags:
ChangingPHP Code:define('META_TAG_TITLE', str_replace('"','',$meta_products_name . $meta_products_price . PRIMARY_SECTION . TITLE . TERTIARY_SECTION . NAVBAR_TITLE));
toCode:str_replace('"',''
might work.Code:str_replace('"','"'
By the way, to quote HTML entities, just use the "Code" button on this forum.
That should all be enough to get things done the right way! :clap:
All the best...
Conor
Ceon
Hi Conor,
Thanks for the advice!
I'm now trying to move the notify me button all of the way to the left instead all the way to the right but it appears that the div tag that I wrapped the button in is getting stripped by class.CeonXHTMLHiTemplate.php. What would I need to do to get the button to the left?
Thanks!
Matt
Hi Matt,
The template class strips the contents of any <ceon:variable> tags so don't place anything into those.
The template class strips the contents of any <ceon:if> tags if the content is not to be used (the variable is not set).
Also, your code must be inside one of the "template parts" or it won't be used.
If the problem's not cause by one of the above, I'm afraid I don't know what you are doing wrong!
All the best...
Conor
Ceon
:clap:I love it it works like a charm :clap::lamo: one thing i wasn't able to do is the run the test it show that =Send Output
There are no notifications to be sent at this time.
but i did a deferent test i subscribe on one item and it when good then i have the items back in stock and then send the Actually send notification e-mail for the subscribers and it works really nice.
But the only thing im not getting is the notification when a customer subscribe for the item that is out of stok, basicly i have to check manualy.:lamo:
thanks:flex:
typo
language file: back_in_stock_notifications_subscribe.php
Line: 31
"If, for any reason, you would like to unsubscribe from the Notification List for “%s” you can do so at any time my logging in to your Account and changing your Back In Stock Subscription Notification preferences."
"my" should be "by"
Is this supposed to take the user to the shopping cart once they submit?
Nevermind, something was screwed up on my tpl_product_info_display.php so it wasn't working right.Quote:
Originally Posted by pricediscrimination
Now for styling... I can't get the "Name" form to be as wide as the email forms. I went into to the provided html and changed the size/length to match the email forms but it still didnt work.
Is there an easy way to style this? I don't want it to look the same as my other "form" "legend" styling.
Hi,
Thanks, I'll get that typo fixed.
No, of course not. Does yours?Quote:
Originally Posted by pricediscrimination
If it does then you've messed up integrating the code into your tpl_product_info_display.php file.. the subscription form cannot be within the set of form tags which is used to add the product to the cart.
All the best...
Conor
Ceon
Hi,
I've just uploaded a new version to our site and the downloads area. From the Revision History:
[BUGFIX] SQL script updated to work with MySQL 5.
[BUGFIX] Typo fixed in back_in_stock_notifications_subscribe.php.
http://dev.ceon.net/web/zen-cart/bac...ions/downloads
All the best...
Conor
Ceon
any tips on styling?
Hi,
I'm guessing you're talking about the form textfields?Quote:
Originally Posted by pricediscrimination
You can set them to the same size by giving each of the textfields a class or an ID and setting up the appropriate CSS. E.g:
HTML Code:<input type="text" size="25" maxlength="64" name="name" value="{name}" class="MyClassToSetLengthOfTextfield" />
(adding .MyClassToSetLengthOfTextfield { length: 10em } or some similar CSS to your stylesheet).HTML Code:<input type="text" size="35" maxlength="96" name="email" value="{email}" class="MyClassToSetLengthOfTextfield" />
Or you can make the length of each field the same by changing the "size" attributes as desired.
If you're asking about the form labels, they all share the same class - inputLabel - so they should be the same length if the CSS for it is set to a particular length.
Because all of the template code is standard HTML with Ceon's template tags embedded, it's easy to update this. If you are having trouble please consult a designer, it shouldn't take more than a few minutes for someone with good HTML/CSS skills to sort this out! :)
Glad you like the module!
All the best...
Conor
Ceon
Hi Conor,
I was thinking about adding this to the product listing pages. Would there need to be a complete re-write or are there just a few lines here and there to alter to make it work? The reason why I would like to add it to the product listing page is that many people don't go further than that page when looking at products, and it would be very helpful to put the BISN on this page, too.
Thanks!
Matt
Hi Matt,
That's an interesting idea.. how do you imagine the BISN link should be displayed? As a text link to the Back In Stock Notification subscription page?Quote:
Originally Posted by lankeeyankee
All the best...
Conor
Ceon
Hi Conor,Quote:
Originally Posted by conor
I imagine the link being just like on the product info page, a text link under the out of stock image. And I think that it would be easiest if it was an anchor link like the product info page, so the form is at the bottom of the page, or even hidden in a div tag that would expand when the link was clicked and you're dropped down to the bottom of the page to fill in the form.
Thanks!
Matt
I have the installed and all seems to work well, get the email's but when i send the email from the test acc , that i use , i get all of this text at the top of the web site.
you can check it out at www.mikesrchobbies.com
go to canopies and the 1st one is out of stock.
i have it set up on my test server also and works fine . just replace the www with beta ,
any help would be great ,
thanks mike
Hi there,
I'm just wondering how to go about changing the font & font size of the text that is displayed on the page that appears after a user clicks the subscribe button?
Thanks
James
Subscription Successful!
You have been successfully subscribed to the Back In Stock Notification List for “” and will therefore receive an e-mail from us when it is back in stock!
For security reasons, an e-mail has been sent to you acknowledging your subscription. Please remember that this subscription will not result in you receiving any e-mail from us about anything other than the restocking of this item.
If, for any reason, you would like to unsubscribe from the Back In Stock Notification List for “” you will find details of how to do so in the e-mail that has just been sent to you.
---------------------------------------------------------------
i see Product empty, and not save number product in database.
Help me please.
Hi,
Not sure where you've gone wrong. Sorry.Quote:
Originally Posted by leoshell50
All the best...
Conor
Ceon
I'm also trying to move the NOTIFY ME button to the left. Any suggestions would be appreciated.Quote:
Originally Posted by lankeeyankee
GREAT mod!
Hi,
Just adjust the template file. Copy it to your template directory.Quote:
Originally Posted by Craft Magick
Copy the file from
includes/templates/template_default/templates/inc.html.back_in_stock_notifications.html
to
includes/templates/YOUR_TEMPLATE/templates/inc.html.back_in_stock_notifications.html
and modify the HTML as you wish.
You'll see most of the buttons are in tags like the following:
The:HTML Code:<div class="buttonRow forward"><ceon:variable name="continue_button"><input type="submit" /></ceon:variable></div>
part is what gets replaces with the button, so you just adjust the code around that to place the button wherever you want.HTML Code:<ceon:variable name="continue_button"><input type="submit" /></ceon:variable>
Thanks! ;)Quote:
Originally Posted by Craft Magick
Enjoy the rest of your weekend!
All the best...
Conor
Ceon
Copied file to my templates overrides directory as instructed above and added style="float:left;" to every instance of the inc.html.back_in_stock_notifications.html file as follows:Quote:
Originally Posted by conor
but the notify me button is still on the right... did I miss something?HTML Code:<ceon:variable name="submit_button"><input type="submit" style="float:left;" /></ceon:variable>
Hi,
Yes, you did the complete opposite of what I was saying! :)Quote:
Originally Posted by Craft Magick
You can't modify anything between the ceon:variable tags as they get replaces, you make your modifications outside of that, in this case thebit.HTML Code:<div class="buttonRow forward">
If you need any more help please read the documentation that comes with the module, it describes how the templates work.
Enjoy the rest of your weekend!
All the best...
Conor
Ceon
Thank you for your help. I've tried every combination of 'align' and 'float' that I know of as it relates to HTML in the
inc.html.back_in_stock_notifications.html file to try and get the 'notify me' button to float left instead of right but can't get it...
it's probably just my complete ignorance of 'Ceon:variable tags' and/or 'custom HTML templates' because even the changes I made to the text on the notification form don't ALL show up on the website either.... in the exact same files some of the text changes DO show up and some do NOT...
For anyone else that reads this post someday and to perhaps save you an entire afternoon of obsession here's what I tried that was unsuccessful:
andHTML Code:<div class="buttonRow back"><div align="left">
andHTML Code:<div class="buttonRow forward" align="left">
andHTML Code:<div align="left">
<div class="buttonRow back">
andHTML Code:<div style="float:left;">
<div class="buttonRow back">
and even looked at tpl_products_display.php but don't know enough about php to even know if anything can be done hereHTML Code:<div class="buttonRow back" style="float:left;">
PHP Code:$submit_button = zen_image_submit(BUTTON_IMAGE_NOTIFY_ME, BUTTON_NOTIFY_ME_ALT,
'name="notify_me"');
$back_in_stock_notification_form->setVariable('submit_button', $submit_button);
So after obsessing all afternoon on this and considering what a GREAT MOD this is I've decided to live with the existing text and layout since the trade off is definitely worth it.
If anyone someday reads this post and comes up with a solution to get the 'notify me' button to align to the left please post the solution here since I'm subscribed to this thread and it would be very helpful to know how to do it.
Anyway, thank you again for trying to help a novice and for such a wonderful mod.
Have a beautiful weekend.
Craft Magick..
To align the button left:
in the file inc.html.back_in_stock_notifications.html look for this part in the code..
within that section of code around line 92 adjust this bit:Code:<!-- ceon-begin-part PRODUCT_INFO_BACK_IN_STOCK_NOTIFICATION_FORM -->
toCode:<div class="buttonRow forward"><ceon:variable name="submit_button"><input type="submit" /></ceon:variable></div>
BTW.. I tried to Copy the file fromCode:<div class="buttonRow back"><ceon:variable name="submit_button"><input type="submit" /></ceon:variable></div>
includes/templates/template_default/templates/inc.html.back_in_stock_notifications.html
to
includes/templates/YOUR_TEMPLATE/templates/inc.html.back_in_stock_notifications.html
and it didn't work.. so I had to edit the file in the template_default
Hope this helps :)
Thanks for the great mod ceon... :clap:
Hi,
Oh dear.. I'm very sorry about this.
Changing it to
is all you needed to do.HTML Code:<div class="buttonRow back"><ceon:variable name="submit_button"><input type="submit" /></ceon:variable></div>
What went wrong was my initial advice about copying the file to your template directory.
I've just realised that the module loads the file from
includes/templates/template_default/templates/inc.html.back_in_stock_notifications.html
directly.. the module doesn't use the template override system!
So sorry about that.. I've wasted a lot of your time! :(
When I next upgrade the module I'll make it use the template override system.
Sorry once again.
At least now you'll be able to get it to work! Just apply your changes to the above file and not the override file I mistakenly told you to apply it to.
All the best...
Conor
Hi Conor,
First of all awesome application. I notice I had a little problem after installing this application. This is what I got when clicked on one of the manufacturers.
Would you please tell me what I did wrong.Quote:
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 '-0, 0' at line 7
in:
[select p.products_image, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m where p.products_status = 1 and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '2' order by p.products_sort_order, pd.products_name limit -0, 0]
Thank you in advance.
Dat
Thank you so very much, Conor. Worked like a charm... and the module override (or lack thereof) certainly explains why many of my attempted changes weren't appearing on the website!Quote:
Originally Posted by conor
Great mod and thanks again for all your help.
Zencart ROCKS :clap:
Hi,
I'm afraid that's nothing to do with this module. You've probably only noticed this problem after installing Back In Stock Notifications but the problem was there already.Quote:
Originally Posted by datvtran
BISN doesn't affect any manufacturer-related functionality of Zen Cart at all!
Try posting a new thread in the forum with a much more detailed explanation of what you are doing and what you expect to happen and hopefully someone can help you!
All the best...
Conor
Ceon
Hi Conor
Thank you for the quick reply. I will looking into this and see what I did wrong.
Thanks,
Dat
Can I have the back in stock notification option display in the shoping cart page instead? See, I don't use the zen-cart's products display page, but rather home made pages linked to zen-cart's shopping cart.
See here:
www.truerc.net/canada
-Hugo
Hi,
That would be possible but you'd have to have the functionality custom coded for your site, there are no plans to introduce such functionality into the shopping cart page.Quote:
Originally Posted by HugeOne
All the best...
Conor
Ceon
I use SEO URL, work this module with SEO?Quote:
Originally Posted by conor
Hi,
I don't see why not.Quote:
Originally Posted by leoshell50
I suppose it's possible that the SEO module is breaking the links, I just don't know as I didn't write that SEO module.Quote:
Originally Posted by conor
All the best...
Conor
Ceon
I installed your module, everything work, except that I get an 500 internal server error when clicking on the "notify me " button. Beside that everything work as it should. Emails are sent and notify list is filled.
Now I need to have it display in the shopping cart, look quite complicated...
Z-C: 1.3.7.1
Database: MySQL 4.1.22-max-log
HTTP Server: Apache
PHP Version: 4.3.11 (Zend: 1.3.0)
Server OS: Linux 2.4.21-53.ELsmp
www.truerc.net/canada
Hi leoshell,Quote:
Originally Posted by leoshell50
I'm using Simple SEO URL mod and the BIS notification mod works fine with it on my site. If you are having trouble with BIS and think it may be related to SEO URL then you may want to switch to Simple SEO. Just a thought...
BTW, I'm running zen version 1.3.8a
Best of luck to you...
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!
The latest version of the module compares against <= 0.Quote:
Originally Posted by brushwoodnursery
You'll find the line you want to change in
includes/classes/observers/class.back_in_stock_notificationsProductInfo.php
at line number 56:
Hope that helps! :)PHP Code:if ($products_quantity <= 0 && BACK_IN_STOCK_NOTIFICATION_ENABLED == 1) {
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?
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!Quote:
Originally Posted by chabbu
Hi,
That's what I was about to suggest! I don't there'll be any problems using latin1. :)Quote:
Originally Posted by chabbu
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,
I'm very pleased to tell you that this has been added to version 2.4.0 of the module.Quote:
Originally Posted by lankeeyankee
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
Hi Conor,Quote:
Originally Posted by 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,
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! :)Quote:
Originally Posted by lankeeyankee
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!Quote:
Originally Posted by lankeeyankee
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.p...ification_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,
I'm glad to hear that!Quote:
Originally Posted by soyabeane
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,
Not reading the documentation unfortunately! :)Quote:
Originally Posted by geng77
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:Quote:
Originally Posted by conor
Hi,
Glad you're up and running now!Quote:
Originally Posted by geng77
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,
So people can order items that are out of stock or else simply sign up to find out when they are back in stock?Quote:
Originally Posted by micmed
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
I have the same message displayed for custom items and out of stock items such as http://www.thecablestation.com/index...oducts_id=3403. So, I would like to have the BISN subscription form button appear near that message.
I would also like to figure out a way to have different messages for items that are BTO and simply out of stock. Any ideas?
Thanks
Ted
Hi,
That would definitely require custom coding. You'd probably have to add a flag to the product admin pages to mark particular products as BTO.Quote:
Originally Posted by micmed
You could then modify the BISN module to display the form even if a product is in stock if it is BTO.
All the best...
Conor
ceon
just installed it on 1.3.8a and works fine.
only 1 thing i want to change. by default it uses the owner's email address to send the email. can i specify a different email address to send the notification from?
Hi,
You'll have to modify the fileQuote:
Originally Posted by ams30gts
includes\modules\pages\back_in_stock_notification_subscribe\header_php.php
changing the EMAIL_FROM to something else in the e-mail commands.
All the best...
Conor
ceon
Hi everybody,
Great mod.
I'm looking for a combination of Back in stock with Product Notification:
I want to email clients when I change the PRICE of the item they have subscribed.
For example, when selling computers, the price changes very often, and I've added a "subscribe to be notified when price have changed".
But this is based on product notification, and there isn't an option to send email automatically.
Back in stock have all functionality, but will need to check the price not the stock.
Thx.
Marius
Hi Conor, I have been following this tread for a while and so far it has been good. Excellent module. I use Zencart 1.3.8 and will be launching my website soon. But I have a small problem. I am a bookseller and so I have a book add-on. The back-in-stock-notification worked until I installed your latest download -- ver 2.4.0. Actually, it still works except that the "click here" links (on both the listing and item pages) that are supposed to open the BISN subscription form do not work.
I remember an earlier modification you suggested for 'product books' in includes/classes/observers/class.back_in_stock_notificationsProductInfo.php: 'NOTIFY_MAIN_TEMPLATE_VARS_EXTRA_PRODUCT_BOOK_INFO', and that worked (although I had to delete the original event for the module to work -- otherwise I got a blank page). Do I need to do something similar for the current links to work?
BTW, I am new around here. How do I send you a donation?
Raman
Unfortunately, this isn't displaying correctly in the product listing page. All I see next to the sold out button is the message 'BACK_IN_STOCK_NOTIFICATION_TEXT_PRODUCT_LISTING_FORM_LINK'Quote:
Originally Posted by conor
Any ideas?
Hi,
You didn't need to quote the whole post to ask a question!Quote:
Originally Posted by chabbu
You have forgotten to upload the file:
includes\languages\english\extra_definitions\back_in_stock_notifications.php
Upload it and you should be fine.
All the best...
Conor
ceon
Sorry about that. The files is there, I copied across the whole lot as opposed to file by file. I'm running v1.3.7, i installed v2.2.4 of this mod before updating to v2.4.0
Hi,
Sorry, your english is very confusing. I don't know what you are trying to say here?Quote:
Originally Posted by chabbu
Are you saying that you have checked that the file is there and it is?
If so, please upload it again, you must be using the old verison.
All the best...
Conor
Yes, I have checked and the file is there. I've uploaded it again, and I am still seeing the same message.
Hi,
In that case, I'm afraid there's no other reason I can think of to explain that error, sorry!Quote:
Originally Posted by chabbu
All the best...
Conor
ceon
I would delete everything that deals with back in stock on your sever and re-upload it againQuote:
Originally Posted by chabbu
Just make sure your custom file structure is correct when installing. This should solve your problem.
Hi chabbu,
The only other thing that could be wrong is you have a language file override in place.
Check if the following file exists:
includes\languages\english\extra_definitions\YOUR_TEMPLATE\back_in_stock_notific ations.php
If it does then delete it or merge it with the new version of the file!
All the best...
Conor
ceon
Thank you, Conor. I don't know what the problem was, but I copied across all the files one by one as opposed to dragging the whole folder across and that seems to have worked.
Faz
Thanks for the advice, it's working now.Quote:
Originally Posted by countrycharm
Hi Faz,
I knew it had to be something like that.. bizarre mess-up by your FTP client! It might be worthwhile looking at alternatives. FireFTP for FireFox is decent (and free! :) ).Quote:
Originally Posted by chabbu
All the best...
Conor
ceon
Great stuff, I've installed it and it is so much better than what I was originally using. I've donated a little something via paypal (hope it went through as i received a 'page cannot be found' after completing the payment).Quote:
Originally Posted by conor
Thanks for this module, and for your help.
Faz (hubooks)
Hi,
I'm glad to hear that! :)Quote:
Originally Posted by chabbu
Thanks very much indeed, that was very good of you! :thumbsup:Quote:
Originally Posted by chabbu
I don't know why a page not found would come up, it's just PayPal's standard donations page. Maybe they were having a temporary problem. Either way, thanks once again!
I'm glad you like it and hope it gets you some extra sales (all reports seem to indicate that it does indeed! ;) ).Quote:
Originally Posted by chabbu
All the best...
Conor
ceon
I was planning on installing this module, but had a question. How does this work if the product goes inactive when it's out of stock? When inactive, it doesn't display, so customers won't know it's there.