joshnyberg Posted April 29, 2005 Share Posted April 29, 2005 (edited) Hi, I just contributed this and a few other modules which I thought should have been incorporated into oscommerce already, and which I hope will make it into the next release. Any suggestions are welcome. This contribution is located at: http://www.oscommerce.com/community/contributions,3152/ It will automatically tell a customer when a requested item comes into stock, and then delete the product and customer from the product_notifications table in the database. Thanks. Edited April 29, 2005 by joshnyberg Quote Link to comment Share on other sites More sharing options...
100asa Posted May 7, 2005 Share Posted May 7, 2005 Great contribution, Joshua! I've just update your contribution with Insomniac contrib, but I've this error when update products stock: 1054 - Unknown column 'pd.products_spec' in 'field list' select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_url, p.products_quantity, p.products_model, p.products_upc, p.products_image, p.products_pdfupload, p.products_image_pop, p.products_inventory_cost, p.products_retail_price, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_date_expire, p.products_status, p.manufacturers_id, p.minorder from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '566' [TEP STOP] Thank you for your support! and Insomniac support <_< Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
ukgoods Posted May 9, 2005 Share Posted May 9, 2005 I love this module!!!!! Can anyone tell me how to integrate it with the Quick Stock Updater module? Thanks, Donna Gordon UKGoods.com Quote Link to comment Share on other sites More sharing options...
ukgoods Posted May 9, 2005 Share Posted May 9, 2005 Great contribution, Joshua!I've just update your contribution with Insomniac contrib, but I've this error when update products stock: 1054 - Unknown column 'pd.products_spec' in 'field list' select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_url, p.products_quantity, p.products_model, p.products_upc, p.products_image, p.products_pdfupload, p.products_image_pop, p.products_inventory_cost, p.products_retail_price, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_date_expire, p.products_status, p.manufacturers_id, p.minorder from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '566' [TEP STOP] Thank you for your support! and Insomniac support <_< <{POST_SNAPBACK}> Change the $product_query_raw to this: $product_query_raw = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); The creator of the module had extra fields in his query. Regards, Donna Gordon UKGoods.com Quote Link to comment Share on other sites More sharing options...
100asa Posted May 9, 2005 Share Posted May 9, 2005 (edited) Thank you: with your suggestion all functions are ok. But, I'm trying with my account, but I don't receive email with update products! Edited May 9, 2005 by 100asa Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
100asa Posted May 9, 2005 Share Posted May 9, 2005 Sorry, it's all ok! Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
100asa Posted May 9, 2005 Share Posted May 9, 2005 The message format is in plain text, and I see the link like <a href="http://www.100asa.it/product_info.php?products_id=1423">Home adapter</a> How can I send stock update in html format? Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
ukgoods Posted May 24, 2005 Share Posted May 24, 2005 The message format is in plain text, and I see the link like <a href="http://www.100asa.it/product_info.php?products_id=1423">Home adapter</a> How can I send stock update in html format? <{POST_SNAPBACK}> Did you ever get this to work right? Thanks, Donna Quote Link to comment Share on other sites More sharing options...
Guest Posted November 10, 2005 Share Posted November 10, 2005 Does anyone know how to fix the html problem in the e-mail? The e-mails look really tacky and unprofessional with all of those tags and links showing. Andrea Quote Link to comment Share on other sites More sharing options...
Guest Posted November 11, 2005 Share Posted November 11, 2005 Finally, I figured this thing out; the problem of e-mail reading in text format as opposed to html. Change this in the contrib: $mimemessage = new email(array('X-Mailer: YoutStore Systems Mailer')); $mimemessage->add_text('Stock Update: ' . $product['products_name'] . ' To read this (just changing one little word) $mimemessage = new email(array('X-Mailer: YoutStore Systems Mailer')); $mimemessage->add_html('Stock Update: ' . $product['products_name'] . ' Works beautifully! Honestly, this is a really nice contrib, but...someone who has the authority to do so, needs to fix it and put up the one that works. The ones that are there now, as written, do not work. Not just a problem with the e-mails looking bad, but the contrib itself is filled with errors that were corrected in this thread. I think everyone would love to use this if they knew how cool it was. Andrea Quote Link to comment Share on other sites More sharing options...
merdice Posted January 4, 2006 Share Posted January 4, 2006 Hi, I'm using this contrib and it doesn't work 100%... :( When I have more than 1 user on the notification list of a product, every user on that list receive the same first name and last name of the first user. The first user name is ok, but all the rest users have also that name... Does this happend to anyone else?? Quote Link to comment Share on other sites More sharing options...
brightlaserlights Posted February 2, 2006 Share Posted February 2, 2006 Hi all, Does anyone have or can somebody please make this contrib multi language compatible? :blush: Many thanks in advance! B) Quote Link to comment Share on other sites More sharing options...
pmurdoch Posted February 1, 2007 Share Posted February 1, 2007 Hi Could anyone possibly tell me where this new code needs to go. Would probably help other newbies as well. Many Thanks Paul M Quote Link to comment Share on other sites More sharing options...
gillo Posted February 16, 2007 Share Posted February 16, 2007 Hi, I'm using this contrib and it doesn't work 100%... :( When I have more than 1 user on the notification list of a product, every user on that list receive the same first name and last name of the first user. The first user name is ok, but all the rest users have also that name... Does this happend to anyone else?? I have the same problem. All users have the same first- and lastname. have anyone a solution for this problem? Regards gillo Quote Link to comment Share on other sites More sharing options...
Guest Posted June 10, 2008 Share Posted June 10, 2008 Hi, I'm using this contrib and it doesn't work 100%... :( When I have more than 1 user on the notification list of a product, every user on that list receive the same first name and last name of the first user. The first user name is ok, but all the rest users have also that name... Does this happend to anyone else?? Anyone ever fix this. I did not realize about the problem until some customers emailed me. Or is there something else to use? Thanks. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 20, 2008 Share Posted June 20, 2008 Anyone ever fix this. I did not realize about the problem until some customers emailed me.Or is there something else to use? Thanks. Just noticed a update for this released version 2. Anyone tried it yet and does it work so that it sends to a list of people who wanted notification of the same product. But does not just use the first person names for everyone? Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.