X-Cart forums

[alinush]

Thank you ShishaPipeUK for posting this wonderful mod.

In case anybody else is interested in this, I got it installed on 4.1.8. There were a few problems:

1. I had to manually insert some of the records in the database (I don't know why it didn't work from the Patch section in X-Cart).

2. in product_modify.php, I had to replace:

x_load('backoffice','category','image','product');

with:

x_load('backoffice','category','image','product','mail');

3. Maybe this was related to my custom theme, but I had to remove:

<input type="hidden" name="desc" value="{$product.descr}">
<input type="hidden" name="fulldesc" value="{$product.fulldescr}">

from product.tpl, as the description was displaying 2 times on the product page.

That's it Thanks again.

[ShishaPipeUK]

Works OK on 4.1.9 as well, just some minor changes in the standard code but you can easy follow the instructions and find where to place the code.

You can see an example at http://www.shishapipe.net/shopcart/product.php?productid=16594&cat=296&page=1

This site uses menu tabs so I did not edit the skin1/customer/main/product.tpl code, but instead entered this into the tab code for my site.

I followed my own instructions for 4.1.3 and found there where no code changes for 4.1.9 but just a few changes in the look for code, but you can easy find the area the code needs to be placed without problems.

[inmotionmedia]

This mod sounds great! does the site owner also recieve a notification of which product is "requested"?

[ShishaPipeUK]

No that's not been implemented as when you add the stock back in it automatically emails the people who requested the stock notify, but does not email the admin, sorry.

Also the admin does not know who has requested the stock notify unless you look in the mysql data (xcart_email_for_changed_products), i did not make a back end admin section to look at what emails have requested the change in the product stock or details or price.

The table in the mysql you need to look for that stores the email and product details is:

 
CREATE TABLE xcart_email_for_changed_products (
productid int(11) NOT NULL default '0' ,
email varchar(128) NOT NULL default '' ,
descr text NOT NULL default '' ,
fulldescr text NOT NULL default '' ,
price decimal(12,2) NOT NULL default '0.00' ,
avail int(11) NOT NULL default '0' ,
PRIMARY KEY (productid,email)
) TYPE=MyISAM;

Here is an example of one of the entrys:

 
INSERT INTO xcart_email_for_changed_products VALUES (16296, 'someones_email@I have deleted.com', '<b>Syrian shisha pipe</b>, elegant in style, fully working shisha pipe.<br><br> Please allow 7 days for delivery on this product.', '<b>Syrian shisha pipe</b>, elegant in style, fully working shisha pipe.<br><br> Please allow 7 days for delivery on this product.', '120.00', 0);

And when you edit the product in admin, either the descr (Description), fulldescr (Full Description), price (The Price) or avail (Stock level from 0 to a greater number) a email will be sent out automatically.

It would not be hard to make a back end admin section to view the emails and products that have been requested for by email address (Look at the wish list code - php and tpl), but i just don't have the time to do this yet, sorry.

[TanyaG]

Not sure what I’m doing wrong but when I’m trying to unsubscribe getting an error message
“Notice: Undefined variable: mode in /var/www/vhosts/httpdocs/changed_product_notify.php on line 2
Notice: Undefined variable: mode in /var/www/vhosts/httpdocs/changed_product_notify.php on line 8
Notice: Undefined variable: login in /var/www/vhosts/httpdocs/changed_product_notify.php on line 16”
Is anybody know how to fix it.
Many thanks

[MBA]

Works on 4.1.10. I had to manually put in the dif. patching wouldn't work for some unknown reason. We've had this issue with other mods in 4.1.10 too so it may be a bug/change/error with the 4.1.10 patching system?

Either way, nice mod.

[TanyaG]

Thanks a lot for a great mod. Is anybody know how I can add a Confirmation Page (something like: “Thank you for submitting your email....”) and if email address is empty or doesn’t contained @ or . – page saying “Please get back and correct it...”.

Many thanks

[donavichi]

ShishaPipeUK,

This would be useful for a site i'm working on, but i have a question about it.

Because I have a high volume of products to alter when i do an update, too many for x-cart product imports, I insert product details directly into the mySQL database in bulk instead.

Would the mod work in this instance or will it only work if an x-cart induced product import is done?

Thanks in advance,

[ADDISON]

This is a great mod. Thanks for sharing.

I consider useful as a visitor only the following notifications:

- if the price decreases
- back in stock (initial stock 0 - out of stock, if it is changed to positive values - in stock)

[ADDISON]

I would like to ask if this mods allows to unsubscribe. Let's say I am an anonymous visitor and I would like to be informed about price decrease using this feature.