automatic customer stock notification update

[joshnyberg 0]

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

[100asa 0]

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 <_<

[ukgoods 0]

I love this module!!!!!

 

Can anyone tell me how to integrate it with the Quick Stock Updater module?

 

Thanks,

 

Donna Gordon

UKGoods.com

[ukgoods 0]

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

[100asa 0]

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

[100asa 0]

Sorry, it's all ok!

[100asa 0]

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?

[ukgoods 0]

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

[Guest]

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

[Guest]

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

[merdice 0]

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??

[brightlaserlights 0]

Hi all,

 

Does anyone have or can somebody please make this contrib multi language compatible? :blush: Many thanks in advance! B)

[pmurdoch 0]

Hi

Could anyone possibly tell me where this new code needs to go. Would probably help other newbies as well.

Many Thanks

Paul M

[gillo 0]

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

[Guest]

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.

[Guest]

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