X-Cart forums - if a product is outstock, notify when in stock

Page 2 of 3

Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - if a product is outstock, notify when in stock - preorder (https://forum.x-cart.com/showthread.php?t=2471)

shishapipe

01-06-2005 08:51 AM

i have look at the site but cant find the module for this to buy please give me the link

maxking

shishapipe

01-15-2005 07:03 AM

Quote:

Originally Posted by funkydunk

http://www.prodynamix.co.uk/customer/product.php?productid=14&cat=20&page=1

It is available for purchase and download online.

I cant find this Stock Notify mod there, i have the old 3.4 Mod i think and i am trying to convert it to X-Cart 4.09., a friend of mine gave me this MOD to play with. Anyway i would prefer to buy this Mod for X-cart 4.09 as this is taking a lot of my time in trying to sort it out.

I have managed to get somewhere with this modification, but problem now on the email side.

I have changed the directory position of some of the files, for example notify.php is not in shopcart/customer/notify.php as per instructions its is now in shopcart/notify.php

Also the shopcart/skin1/main/product_modify.tpl as per instructions for X-Cart 3.4 was not changed but i inserted the code into shopcart/skin1/main/product_details.tpl for X-Cart 4.09 as i beleive this is the right place for it. (Open to suggestions :) )

Code:

<?

# START - FROM SHOPCART/PRODUCT.PHP CODE X-CART 4.09 

require "./auth.php";



#

# Put all product info into $product array

#



$product_info = func_select_product($productid, @$user_account['membership']);

if (intval($cat) == 0) {

        $cat = $product_info["categoryid"];

}



$main = "product";

$smarty->assign("main",$main);



include $xcart_dir.DIR_CUSTOMER."/send_to_friend.php";



if(!empty($active_modules["Product_Configurator"]))

        include $xcart_dir."/modules/Product_Configurator/pconf_customer_product.php";



if(!empty($active_modules["Detailed_Product_Images"]))

        include $xcart_dir."/modules/Detailed_Product_Images/product_images.php";



if(!empty($active_modules["Product_Options"]))

        include $xcart_dir."/modules/Product_Options/customer_options.php";



if(!empty($active_modules["Upselling_Products"]))

        include $xcart_dir."/modules/Upselling_Products/related_products.php";



if(!empty($active_modules["Advanced_Statistics"]))

    include $xcart_dir."/modules/Advanced_Statistics/prod_viewed.php";



if($active_modules["Manufacturers"])

        include $xcart_dir."/modules/Manufacturers/customer_manufacturers.php";

# END - FROM SHOPCART/PRODUCT.PHP CODE X-CART 4.09

require $xcart_dir."/include/categories.php";



# NOW WE START WITH THE CHANGED FUNKYDUNKS CODE

if(($login)&& ($product_info != "") && ($active_modules["stock_notify"])) {



// ie they are looged in and have selected a product

// echo "logged and ready to roll";

 $userinfo = func_userinfo($login,$login_type);

# $userinfo = func_userinfo($login, $current_area, true);

// echo $userinfo['email'];

// deletes their email if they are already watching this product

db_query("delete from `xcart_notify` where email='" . $userinfo['email'] . "' and productid = $productid");

// add them to the notify table

db_query("INSERT INTO `xcart_notify` ( `email` , `productid` ) VALUES ('" . $userinfo['email'] . "', '$productid')");

}

else {



if (($guestemail) && ($product_info != "") && ($active_modules["stock_notify"])){

// deletes their email if they are already watching this product

db_query("delete from `xcart_notify` where email='" . $guestemail . "' and productid = $productid");

// add them to the notify table

db_query("INSERT INTO `xcart_notify` ( `email` , `productid` ) VALUES ('" . $guestemail . "', '$productid')");

$smarty->assign("guestlogged","true");

        }

        else{

        if ($guest!="true"){

                header("Location: error_message.php?access_denied");

                exit();

                }

        }

}

$smarty->assign("productid", $productid);

$smarty->assign("userinfo", $userinfo);

$smarty->assign("product",$product_info);

$smarty->assign("main","notify");



# END OF THE CHANGED FUNKYDUNKS CODE



# START - FROM SHOPCART/PRODUCT.PHP CODE X-CART 4.09 AT THE END

# Assign the current location line

$smarty->assign("location", $location);

func_display("customer/home.tpl",$smarty);

# END - FROM SHOPCART/PRODUCT.PHP CODE X-CART 4.09 AT THE END

?>

Any help will be appriciated or a place where i can buy the complete version for X-cart 4.09 as this is a very good mod for x-cart.

CC	01-15-2005 07:10 AM

Hi there

Good work so far.

I also have the old code which I am working on altering to 4.0.x as yet I havent got far, too much time spent on other things, but this is a vital mod for businesses with a number of competitors who need to grab customers as soon as new products arrive in stock.

I am going to look over this code now, as soon as I get somewhere with it I will let you know, and we can compare it to get this working.

Keep in mind when posting code, this code is someone elses intellectual property, so FD might not be too happy with it being posted about.
But I guess he will have to answer that one.

shishapipe

01-15-2005 08:06 AM

Quote:

Originally Posted by CC

Keep in mind when posting code, this code is someone elses intellectual property

Yes i agree with you and really need FD's permision for this. As you know all the information for this product has not posted as there are more files. I have changed the shopcart/notify.php from the standard one that FD did, and have changed the begining to the same as shopcart/product.php which came with x-cart 4.09.

funkydunk

01-15-2005 08:52 AM

modify away..... :)

i am still eternally suprised that xcart have not adopted this as a core feature of xcart. 8O

shishapipe

01-15-2005 10:37 AM

Quote:

Originally Posted by funkydunk

modify away..... :)

Ok because Funkydunk has allowed me to modify the product, i have been sucessful on some of the code in X-cart 4.09

This is the shopcart/notify.php file for X-Cart 4.09

Code:

<?php

#

# $Id: notify.php, X-Cart 4.09 2005/01/18 Maxking Exp $

#

require "./auth.php";

#

# Put all product info into $product array

#

$product_info = func_select_product($productid, @$user_account['membership']);

if (intval($cat) == 0) {

        $cat = $product_info["categoryid"];

}

$main = "product";

$smarty->assign("main",$main);



include $xcart_dir.DIR_CUSTOMER."/send_to_friend.php";



if(!empty($active_modules["Product_Configurator"]))

        include $xcart_dir."/modules/Product_Configurator/pconf_customer_product.php";



if(!empty($active_modules["Detailed_Product_Images"]))

        include $xcart_dir."/modules/Detailed_Product_Images/product_images.php";



if(!empty($active_modules["Product_Options"]))

        include $xcart_dir."/modules/Product_Options/customer_options.php";



if(!empty($active_modules["Upselling_Products"]))

        include $xcart_dir."/modules/Upselling_Products/related_products.php";



if(!empty($active_modules["Advanced_Statistics"]))

    include $xcart_dir."/modules/Advanced_Statistics/prod_viewed.php";



if($active_modules["Manufacturers"])

        include $xcart_dir."/modules/Manufacturers/customer_manufacturers.php";

        

require $xcart_dir."/include/categories.php";        

# NOW WE START WITH THE CHANGED FUNKYDUNKS CODE

if(($login)&& ($product_info != "") && ($active_modules["stock_notify"])) {

// ie they are logged in and have selected a product

// echo "logged and ready to roll";

if (!empty($login))

        $userinfo = func_userinfo($login,$login_type);

// echo $userinfo['email'];

// deletes their email if they are already watching this product

db_query("DELETE FROM `xcart_notify` WHERE email='".$userinfo['email']."' AND productid= '$productid'");

// add them to the notify table

db_query("INSERT INTO `xcart_notify` ( `email` , `productid` ) VALUES ('".$userinfo['email']."','$productid')");

}

else {

if (($guestemail) && ($product_info != "") && ($active_modules["stock_notify"])){

// ie they are NOT logged in and have selected a product

// echo "NOT LOGGED and ready to roll";

// echo $guestemail

// deletes their email if they are already watching this product



db_query("DELETE FROM `xcart_notify` WHERE email='".$guestemail."' AND productid='$productid'");

// add them to the notify table

db_query("INSERT INTO `xcart_notify` ( `email` , `productid` ) VALUES ('".$guestemail."','$productid')");

// 

$smarty->assign("guestlogged","true");

}

        else{

        if ($guest!="true"){

                header("Location: error_message.php?access_denied");

                exit();

                }

        }

}

# END OF THE CHANGED FUNKYDUNKS CODE

$smarty->assign("productid", $productid);

$smarty->assign("userinfo", $userinfo);

$smarty->assign("product",$product_info);

$smarty->assign("main","notify");

# Assign the current location line

$smarty->assign("location", $location);



func_display("customer/home.tpl",$smarty);

?>

If you go to
http://www.shisha.co.uk/shopcart/notify.php?productid=16246&guest=true

You will now see it works for guests and members, but not checked email side yet.

You need to add the below to the SQL database.

shishapipe

01-16-2005 07:41 AM

I have added to the SQL database the below code and it seems to work ok, just need to sort out the emails. The above code works ok with a login user or a guest user now after adding the following SQL files.
I added these manualy in the Language section for text, email and Lables.
You just need to do one language and it replicates for the other 3 languages. (SE, FR and DE)

Code:

INSERT INTO xcart_languages VALUES ('DE', 'Notify Me', 'txt_addme_notify', 'Please enter your email in the box provided and we will notify you when stock arrives in.', 'Text');

INSERT INTO xcart_languages VALUES ('FR', 'Notify Me', 'txt_addme_notify', 'Please enter your email in the box provided and we will notify you when stock arrives in.', 'Text');

INSERT INTO xcart_languages VALUES ('SE', 'Notify Me', 'txt_addme_notify', 'Please enter your email in the box provided and we will notify you when stock arrives in.', 'Text');

INSERT INTO xcart_languages VALUES ('US', 'Notify Me', 'txt_addme_notify', 'Please enter your email in the box provided and we will notify you when stock arrives in.', 'Text');

INSERT INTO xcart_languages VALUES ('US', 'Stock Notify', 'txt_added_stock_notify', 'Thanks you will be sent a email when stock arrives back.', 'Text');

INSERT INTO xcart_languages VALUES ('SE', 'Stock Notify', 'txt_added_stock_notify', 'Thanks you will be sent a email when stock arrives back.', 'Text');

INSERT INTO xcart_languages VALUES ('FR', 'Stock Notify', 'txt_added_stock_notify', 'Thanks you will be sent a email when stock arrives back.', 'Text');

INSERT INTO xcart_languages VALUES ('DE', 'Stock Notify', 'txt_added_stock_notify', 'Thanks you will be sent a email when stock arrives back.', 'Text');

INSERT INTO xcart_languages VALUES ('DE', 'Stock Notify', 'lbl_stock_notify', 'Stock Notify', 'Labels');

INSERT INTO xcart_languages VALUES ('FR', 'Stock Notify', 'lbl_stock_notify', 'Stock Notify', 'Labels');

INSERT INTO xcart_languages VALUES ('SE', 'Stock Notify', 'lbl_stock_notify', 'Stock Notify', 'Labels');

INSERT INTO xcart_languages VALUES ('US', 'Stock Notify', 'lbl_stock_notify', 'Stock Notify', 'Labels');

INSERT INTO xcart_languages VALUES ('DE', 'Keep me updated', 'lbl_stock_notify_button', 'Keep me updated', 'Labels');

INSERT INTO xcart_languages VALUES ('FR', 'Keep me updated', 'lbl_stock_notify_button', 'Keep me updated', 'Labels');

INSERT INTO xcart_languages VALUES ('SE', 'Keep me updated', 'lbl_stock_notify_button', 'Keep me updated', 'Labels');

INSERT INTO xcart_languages VALUES ('US', 'Keep me updated', 'lbl_stock_notify_button', 'Keep me updated', 'Labels');

INSERT INTO xcart_languages VALUES ('DE', 'The following product is now back in stock and can be ordered by clicking on the link below', 'eml_stock_notification', 'The following product is now back in stock and can be ordered by clicking on the link below', 'E-Mail');

INSERT INTO xcart_languages VALUES ('FR', 'The following product is now back in stock and can be ordered by clicking on the link below', 'eml_stock_notification', 'The following product is now back in stock and can be ordered by clicking on the link below', 'E-Mail');

INSERT INTO xcart_languages VALUES ('SE', 'The following product is now back in stock and can be ordered by clicking on the link below', 'eml_stock_notification', 'The following product is now back in stock and can be ordered by clicking on the link below', 'E-Mail');

INSERT INTO xcart_languages VALUES ('US', 'The following product is now back in stock and can be ordered by clicking on the link below', 'eml_stock_notification', 'The following product is now back in stock and can be ordered by clicking on the link below', 'E-Mail');

Also added to SQL the following:

INSERT INTO xcart_modules VALUES (2,'stock_notify','Allows registered users to ask to be notified when a product is back in stock','Y');

Code:

CREATE TABLE xcart_notify (

  email char(128) NOT NULL ,

  productid int(11) NOT NULL ,

  KEY email_proudct (email, productid),

) TYPE=MyISAM;

CC	01-16-2005 07:47 AM

Hehe I see you have been buzzing on this. :D

I havent even looked at it in detail yet.
I get the feeling you will be done before I get started.

I am copying all these notes for when I look into it, if you have it working already by then I will at least look to see if we can add to it in anyway.

CC	01-16-2005 07:57 AM

Quote:

Originally Posted by funkydunk

modify away..... :)

i am still eternally suprised that xcart have not adopted this as a core feature of xcart. 8O

They are probably saving it for one of their $99.95 addons when they hope we have all forgotten about this thread. :lol:

shishapipe

01-16-2005 07:57 AM

The new template files you need are:
skin1/modules/stock_notify/addedtolist.tpl

Code:

{* addedtolist.tpl funkydunk.net 2003 *}

{$lng.txt_added_stock_notify}

skin1/modules/stock_notify/stocknotify.tpl

Code:

{* stocknotify.tpl funkydunk.net 2003 - changed by Maxking *}

{capture name=dialog}

{if ($login ne "") or ($guestlogged ne "")}

{include file="modules/stock_notify/addedtolist.tpl"}

{else}

{include file="check_email_script.tpl"}

{include file="check_required_fields_js.tpl"}

{$lng.txt_addme_notify}

<SCRIPT type="text/javascript" language="JavaScript 1.2"> 

var requiredFields = new Array(); 

requiredFields[0] = new Array('guestemail', "{$lng.lbl_send_your_email|strip_tags|replace:'"':'\"'}", false); 

</SCRIPT> 

<TABLE border="0"> 

<FORM action="notify.php" method="post" name="notify"> 

<INPUT type="hidden" name="mode" value="notify"> 

<INPUT type="hidden" name="productid" value="{$productid}"> 

<TR><TD class="FormButton">{$lng.lbl_send_your_email}:</TD> 

<TD><FONT class="Star">*</FONT></TD> 

<TD><INPUT value"Enter Your Email" id="guestemail" type="text" size="45" name="guestemail" onchange="javascript: checkEmailAddress(this);"></TD> 

</TR> 

<TR>

<TD>






{include file="buttons/submit.tpl" style="button" button_title=$lng.lbl_stock_notify_button href="javascript: if(checkRequired('')) document.notify.submit();"}</TD> 

</TR> 

{/if}

</FORM> 

</TABLE> 

{/capture} 

{include file="dialog.tpl" title=$lng.lbl_stock_notify content=$smarty.capture.dialog extra="width=100%"}

skin1/modules/stock_notify/notifyme.tpl

Code:

{* notifyme.tpl funkydunk.net 2003 *}

{if $login ne ""}

{include file="buttons/notifyme.tpl"}

{else}

{include file="buttons/notifyme.tpl"}

{/if}

skin1/buttons/notifyme.tpl

Code:

<font class=FormButton>{$lng.lbl_stock_notify_button} [img]{$ImagesDir}/notifyme.gif[/img]</font>

skin1/mail/stock_notify.tpl

Code:

{* $Id: signin_admin_notification.tpl,v 1.4.2.1 2003/02/11 09:03:02 svowl Exp $ *}

{$lng.lbl_hello} {$userinfo.firstname},



{$lng.eml_stock_notification}:



{$product.product}

===========================================

{$product.descr}



{$lng.eml_please_click_link}:



 {$http_location}/customer/product.php?productid={$product.productid}



{include file="mail/signature.tpl"}

skin1/mail/html/stock_notify.tpl

Code:

{* $Id: Stock Notify (html) - Maxking Exp $ *} 

{config_load file="$skin_config"} 

{include file="mail/html/mail_header.tpl"} 



 



 

{$lng.lbl_hello} {$userinfo.firstname},



 

{$lng.eml_stock_notification}:




{$lng.eml_please_click_link}:






{$http_location}/customer/product.php?productid={$product.productid}






{$lng.eml_please_click_link}











{include file="mail/html/signature.tpl"}

skin1/mail/stock_notify_subj.tpl

Code:

{config_load file="$skin_config"}{ $config.Company.company_name }: Product back in stock !!

shishapipe

01-16-2005 08:00 AM

Quote:

They are probably saving it for one of their $99.95 addons when they hope we have all forgotten about this thread. :lol:

The thing is, i would pay for this, its cost me in time more money to try and work it out and i am not good with PHP, HTML yes, but PHP not my subject and i need this addon so bad.

shishapipe

01-16-2005 08:15 AM

Now there are 3 amended template files, these are:
skin1/customer/main/product.tpl - Just ADD between the {* funkydunk notify mod *} and {* end of funkydunk notify mod *} The rest of the code is to show you where i have placed it the skin1/customer/main/product.tpl

Code:

<TR><TD height="25" width="30%">{$lng.lbl_quantity}{if $product.min_amount gt 1}

<FONT class="ProductDetailsTitle">{$lng.txt_need_min_amount} {$product.min_amount} {$lng.lbl_items}</FONT>{/if}</TD>

<TD>

{if $config.General.unlimited_products eq "N" and ($product.avail le 0 or $product.avail lt $product.min_amount) and $variants eq ''}

<SCRIPT type="text/javascript" language="JavaScript 1.2">

var min_avail = 1;

var avail = 0;

var product_avail = 0;

</SCRIPT>

{$lng.txt_out_of_stock}



{* funkydunk notify mod *}

{if $active_modules.stock_notify ne "0"}






{ include file="modules/stock_notify/notifyme.tpl" product=$product}

{/if}

{* end of funkydunk notify mod *}



{else}

{if $config.General.unlimited_products eq "Y"}

{math equation="x+1" assign="mq" x=$config.Appearance.max_select_quantity}

{else}

{math equation="x/y" x=$config.Appearance.max_select_quantity y=$product.min_amount assign="tmp"}

{if $tmp<2}

{assign var="minamount" value=$product.min_amount}

{else}

skin1/customer/home_main.tpl - Again just add the code between {* funkydunk notify mod *} and {* end of funkydunk mod *} in the skin1/customer/home_main.tpl

Code:

{* funkydunk notify mod *}

{elseif $main eq "notify"}

{include file="modules/stock_notify/stocknotify.tpl"}

{* end of funkydunk mod *}



{include file="customer/main/welcome.tpl" f_products=$f_products newproducts=$newproducts}



{else}

{include file="common_templates.tpl"}

{/if}

skin1/main/product_details.tpl - Again just add the code between {* start funkydunk notify mod and the {* end of funkydunk notify mod

Code:

<TD class="FormButton" nowrap>{$lng.lbl_quantity_in_stock}</TD>

  <TD class="ProductDetails"> 

    <INPUT type="text" name="avail" size="18" value="{if $product.productid eq ""}1000{else}{ $product.avail }{/if}">

        {if $product.is_variant eq 'Y'} readonly{/if}

{if $top_message.fillerror ne "" and $product.avail eq ""}<FONT class="Star">&lt;&lt;</FONT>{/if}

{if $product.is_variant eq 'Y'}

{$lng.lbl_note}: {$lng.txt_pvariant_avail_note}{/if}

</TD>

</TR>



{* start funkydunk notify mod inserted into shopcart/skin1/main/product_details.tpl NOT shopcart/skin1/main/product_modify.tpl as per instructions for X-Cart 3.4 *}

{if $active_modules.stock_notify ne "" and $product.avail eq 0 and $product.productid ne ""}

<input type="hidden" name="oldavail" value="0">

<input type="hidden" name="notify" value="true">

{/if}

{* end of funkydunk notify mod inserted into shopcart/skin1/main/product_details.tpl NOT shopcart/skin1/main/product_modify.tpl as per instructions for X-Cart 3.4 *}





<TR> 

{if $productids ne ''}<TD width="15" class="TableSubHead"><INPUT type="checkbox" value="Y" name="fields[low_avail_limit]"></TD>{/if}

  <TD class="FormButton" nowrap>{$lng.lbl_lowlimit_in_stock}</TD>

  <TD class="ProductDetails"> 

    <INPUT type="text" name="low_avail_limit" size="18" value="{if $product.productid eq ""}10{else}{ $product.low_avail_limit }{/if}">

{if $top_message.fillerror ne "" and $product.low_avail_limit le 0}<FONT class="Star">&lt;&lt;</FONT>{/if}

  </TD>

</TR>

shishapipe

01-16-2005 08:31 AM

Now you need to amend 2 php files, these are:
include/product_modify.php - Only add the files between // funkydunk added code for notify when back in stock and // end of code added by funkydunk for notify when back in stock.

Code:

# Update the default price

                        db_query("UPDATE $sql_tbl[pricing] SET price='$price' WHERE productid='$productid' AND quantity='1' AND membership='' AND $sql_tbl[pricing].variantid = 0");

                        

                        if($fields['price'] == 'Y' && $productids)

                                db_query("UPDATE $sql_tbl[pricing] SET price='$price' WHERE quantity='1' AND $sql_tbl[pricing].variantid = 0 AND membership=''".$products_condition);





// funkydunk added code for notify when back in stock

                if ($notify){

                        if ($avail > $oldavail){

// send the email to all registered product watchers

                        $mailproduct= func_query_first("SELECT * FROM `xcart_products` WHERE productid = '$productid'");

                        $watchers = db_query("SELECT email FROM `xcart_notify` WHERE productid = '$productid'");

// echo "SELECT * from `xcart_notify` WHERE productid = '$productid'";

                        $mail_smarty->assign ("product", $mailproduct); // put in to assign product info to smarty

                        $mail_smarty->assign ("userinfo", $userinfo);        

                                while ($row = db_fetch_array($watchers)){

// echo $row['email'];

                                        $email = $row['email'];

                                        func_send_mail($email, "mail/".$prefix."stock_notify_subj.tpl", "mail/".$prefix."stock_notify.tpl", $config["Company"]["orders_department"], false);

// delete watchers from table

                                        db_query("DELETE FROM `xcart_notify` WHERE email='" . $email . "' and productid = $productid");

                                }

                        

                        }

                }

// end of code added by funkydunk for notify when back in stock





                        # If image was posted

include/process_product.php - Only add between // funkydunk added code for notify when back in stock (shopcart/includes/process_product.php) and // end of code added by funkydunk for notify when back in stock (shopcart/includes/process_product.php)

Code:

                                # Include 'avail' field into the updating list

                                if (isset($v["avail"]) and is_numeric($v["avail"]))

                                        $update[] = "avail='".intval($v["avail"])."'";



// funkydunk added code for notify when back in stock (shopcart/includes/process_product.php) - Modify by Maxking

                        $watchers = db_query("SELECT email FROM `xcart_notify` WHERE productid = '$k'");

                        $mailproduct = func_query_first("SELECT * FROM `xcart_notify` WHERE productid = '$k'");

                        $oldavail = intval($product['avail']);

                        if ($value > $oldavail){                        

                                $mail_smarty->assign ("product", $mailproduct); // put in to assign product info to smarty

                                        while ($row = db_fetch_array($watchers)){

                                                $email = $row['email'];

                                                func_send_mail($email, "mail/".$prefix."stock_notify_subj.tpl", "mail/".$prefix."stock_notify.tpl", $config["Company"]["orders_department"], false);

db_query("DELETE FROM `xcart_notify` WHERE email='" . $email . "' AND productid= '$k'");

                                        }

                                $watchers = "";

                        }

// end of code added by funkydunk for notify when back in stock (shopcart/includes/process_product.php) - Modify by Maxking

                        

                        # Perform SQL query to update products

                                if (!empty($update))

                                        db_query("UPDATE $sql_tbl[products] SET ".implode(",", $update)." WHERE productid='$k'");

shishapipe

01-16-2005 08:35 AM

Here is the full list that you should have:
// Notify when back in stock mod
// copyright funkydunk.net 2003
// designed to allow customers to sign up to recieve an automatic email notifying them of when the product is back in stock

new template files:
shopcart/skin1/modules/stock_notify/addedtolist.tpl
shopcart/skin1/modules/stock_notify/stocknotify.tpl
shopcart/skin1/modules/stock_notify/notifyme.tpl
shopcart/skin1/buttons/notifyme.tpl
shopcart/skin1/mail/stock_notify.tpl
shopcart/skin1/mail/stock_notify_subj.tpl

shopcart/new php files:
shopcart/notify.php

amended template files:
shopcart/skin1/customer/main/product.tpl
shopcart/skin1/customer/home_main.tpl
shopcart/skin1/main/product_details.tpl

amended php files:
shopcart/include/product_modify.php
shopcart/include/process_product.php

You must add the extra items to the SQL that i posted. MAKE SURE YOU DO A SQL BACKUP FIRST. And also backup your PHP and template files so if it does not work you can revert back to your original settings.

shishapipe

01-16-2005 08:43 AM

I have checked my SQL and i get in the database:

Code:

CREATE TABLE xcart_notify (

  email varchar(100) NOT NULL ,

  productid int(11) NOT NULL 

);



INSERT INTO xcart_notify VALUES ('TEST@shishapipe.net', 16246);

INSERT INTO xcart_notify VALUES ('TEST@shishapipe.net', 16247);

So that seems to be working OK with people who have logged in, but NOT guests :(

DogByteMan

01-16-2005 09:18 AM

This mod never did work but with signed in customers, I know because I was the one who originally paid the 'dunk to do it.

shishapipe

01-16-2005 01:23 PM

DELETED AS IT WAS WRONG.

DONT USE THIS ONE, USE THE ONE IN THE FOLLOWING THREADS

shishapipe

01-17-2005 07:50 AM

Also placed this code into shopcart/skin1/customer/main/buy_now.tpl
So it shows in normal mode without going to the details section.
Just add the code between {* funkydunk notify mod *} and {* end of funkydunk notify mod *}

Code:

<TD width="20%" nowrap>

{if $config.General.unlimited_products ne "Y" and ($product.avail le 0 or $product.avail lt $product.min_amount)}

{$lng.txt_out_of_stock}



{* funkydunk notify mod *} 

{if $active_modules.stock_notify ne "0"} 



 

{ include file="modules/stock_notify/notifyme.tpl" product=$product} 

{/if} 

{* end of funkydunk notify mod *} 



{else}

{if $config.General.unlimited_products eq "Y"}

{math equation="x+1" assign="mq" x=$config.Appearance.max_select_quantity}

{else}

shishapipe

01-17-2005 03:07 PM

Here is the NEW X-Cart 4.09 shopcart/skin1/modules/stock_notify/stocknotify.tpl file
This sends a responce (addtolist.tpl - {$lng.txt_added_stock_notify}) to a guest once the email address has been entered correctly and also a responce (addtolist.tpl - {$lng.txt_added_stock_notify}) to a login user.

stocknotify.tpl

Code:

{* stocknotify.tpl funkydunk.net 2003 - changed by Maxking *}

{capture name=dialog}

{* OK CUSTOMER IS LOGGED IN, JUST GO TO THE STOCK NOTIFY TEXT *}

{if ($login ne "") or ($guestlogged ne "")}

{include file="modules/stock_notify/addedtolist.tpl"}

{else}

{* OK NOT LOGGED IN, SO GET THERE EMAIL ADDRESS *}

{include file="check_email_script.tpl"}

{include file="check_required_fields_js.tpl"}

{$lng.txt_addme_notify}

<SCRIPT type="text/javascript" language="JavaScript 1.2"> 

var requiredFields = new Array(); 

requiredFields[0] = new Array('guestemail', "{$lng.lbl_send_your_email|strip_tags|replace:'"':'\"'}", false); 

</SCRIPT> 

<TABLE border="0"> 

<FORM action="notify.php" method="post" name="notify"> 

<INPUT type="hidden" name="mode" value="notify"> 

<INPUT type="hidden" name="productid" value="{$productid}"> 

<TR><TD class="FormButton">{$lng.lbl_send_your_email}:</TD> 

<TD><FONT class="Star">*</FONT></TD> 

<TD><INPUT value"Enter Your Email" id="guestemail" type="text" size="45" name="guestemail" onchange="javascript: checkEmailAddress(this);"></TD> 

</TR> 

<TR><TD colspan="3">




{include file="buttons/submit.tpl" style="button" button_title=$lng.lbl_stock_notify_button href="javascript: if(checkRequired('')) document.notify.submit();"}</TD> 

</TR> 

{/if}

</FORM> 

</TABLE> 

{/capture} 

{include file="dialog.tpl" title=$lng.lbl_stock_notify content=$smarty.capture.dialog extra="width=100%"}

shishapipe

01-17-2005 03:23 PM

Well, a guest now can request stock when it arrives back, this is the dump of my SQL after testing the notify.php script thats posted above.

Code:

INSERT INTO xcart_notify VALUES ('TEST@shishapipe.net', 16246);

INSERT INTO xcart_notify VALUES ('paul@lamari.net', 16246);

INSERT INTO xcart_notify VALUES ('triaya74@hotmail.com', 16209);

INSERT INTO xcart_notify VALUES ('triaya74@hotmail.com', 16212);

INSERT INTO xcart_notify VALUES ('triaya74@hotmail.com', 16227);

INSERT INTO xcart_notify VALUES ('triaya74@hotmail.com', 16188);

INSERT INTO xcart_notify VALUES ('triaya74@hotmail.com', 16241);

INSERT INTO xcart_notify VALUES ('triaya74@hotmail.com', 16242);

INSERT INTO xcart_notify VALUES ('TEST@shishapipe.net', 16146);

INSERT INTO xcart_notify VALUES ('guest@dontknow.com', 16246);

INSERT INTO xcart_notify VALUES ('guest@whocares.com', 16246);

INSERT INTO xcart_notify VALUES ('whocares@whocares.com', 16246);

INSERT INTO xcart_notify VALUES ('testingguess@shishapipe.net', 16247);

So its just the email that needs to be sorted now, will look at this later.

But for X-Cart 4.09 if you follow the above posts Notify will work for a guest and a reg user :)

shishapipe

01-18-2005 03:17 PM

ITS FINISHED AND WORKING ON X-CART 4.09 :)

I have amended the above posts to the correct codes and scripts.

It allows guests and logins to request a stock notify when back in stock.
It does not duplicate stock notify items with emails
It deletes the emails once stock is back in after sending email to users.

All you need to do is edit the txt and html mail scripts for your own prefrence.

If anyone can make the code better then please post it here.

Dont forget you need to change the xcart_notify code for sql to this:

Code:

CREATE TABLE xcart_notify (

  email char(128) NOT NULL ,

  productid int(11) NOT NULL ,

  KEY email_proudct (email, productid),

) TYPE=MyISAM;

If you dont know how to do this, just go to your admin area, go to patches and in the bottom sql box type in:

Code:

DROP TABLE if exists xcart_notify;

This will remove the table for xcart_notify, then you have to install the table again using this code in your sql box:

Code:

CREATE TABLE xcart_notify (

  email char(128) NOT NULL ,

  productid int(11) NOT NULL ,

  KEY email_proudct (email, productid),

) TYPE=MyISAM;

I have one small problem and thats when you have clicked on stock notify and either entered the email or you are already log on, the following screen that accepts the command is ok, but the right hand cat coloum does not display right, it moves to the top right of the page, any ideas anyone ?

redback

01-28-2005 04:28 PM

Hi,
I was wanting a quote to create a mod. Please email or PM.

When items are out of stock, I would like to have a link "Email when item is back in stock" This would appear automatically when I sell out of an item.

Customer enters email address and clicks send (maybe a popup js window?).

I would also like a CC of the email to be sent to me as reference with product details and customers email address.

When I get the 'new' product in and enter inventory, an email would automatically be sent to my customer tell them the item is back on stock. The email to the customer would have the image of the product, it's back in stock and option to buy now ...etc.

Maybe an additional item (an after thought) If they don't buy after 10 days, then a second email would be sent out as a one special price less 10% to entice the buyer.

I have screen shots of what I was wanting, so please email if interested.

Thank you

markwhoo

01-28-2005 05:15 PM

Quote:

Originally Posted by redback

Hi,
I was wanting a quote to create a mod. Please email or PM.

Actually, you will get a better responce if you post this type of request in the professional services request area (which you have I see). I noticed Balinor sent you to this link, but if it is custom other that what is showing unless it is minor changes you are trying to implement the other area will yield better responce. This area is for custom mods and templates that have been either donated by people that have created them and wish to share with others, or people that have made changes or modifications to existing mods that were already created.

Most people here in this specific topic will only respond on this specific mod.

Also, it is nice to know not only what version of xcart, but server info or purchased mods and add ons from scart you are running, so people will even know if they CAN help you or not. Good Luck :wink:

jeeya

01-29-2005 03:35 AM

Can Any One tell me if this will work in 3.4.0 version.

Thanks.

CC	01-29-2005 03:58 AM

Quote:

Originally Posted by raxitpatel

Can Any One tell me if this will work in 3.4.0 version.

Thanks.

You need the earlier code.

groovico

01-29-2005 04:25 AM

For those that are missing the stock modify mod once available from funkydunk, http://www.firetanksoftware.com will be re-releasing it upgraded for all versions of x-cart over the next few weeks.

CC	01-29-2005 04:35 AM

Sorry to ask, but are you going to be charging for that based on the code left here by shishapipe?

Or is it going to be a modified version?

Also, sorry to go off topic, but have you looked into offering the ability to INCLUDE tax in the froogle feed in MMPro?

We cant use yours right now, as UK Froogle you can only display the inclusive price of a product, or they reject the feed. Your mod only provides ex tax pricing.
Along side this, you need to add the ability ot provide the feed name as well as the login details. MMPro names the feed the same as our login, but our feed name is not the same as our login, so we cant upload our feed from your mod either. We need the ability to rename the feed to something other than our login name.

groovico

01-29-2005 11:28 AM

Quote:

Originally Posted by CC

Sorry to ask, but are you going to be charging for that based on the code left here by shishapipe?

It's not related to do with the modification posted here, this is the original "stock notification mod" developed and originally sold by funkydunk through funkydunk.net. Due to funkydunk leaving the x-cart scene he closed his store several months ago so the modificaiton hasn't been available for months.

We're taking over the funkydunk catalog of x-cart mods under agreement with duncan graham.

With regards to MM's froogle export,

Renaming issue: The froogle export has two modes, it lets you FTP directly but also lets you save a file to your machine. The file you can save you can rename to get around the login name issue.

With regards to the Tax, this is determined by how your site is set up, at present if you use "prices include vat" then it works. However if your base products don't have that and your letting the cart add on it instead of work it out then it won't. We've got UK froogle users actively using the feed methods successfully.

Both the login and tax features will be included in a future release.

CC	01-29-2005 02:53 PM

I know about the downloading of the feed which is what we do now, but our store displayes ex vat, and then our own mod also displays the inc VAT price, as should be done by EU stores who are VAT registered.
So we do not have display with tax included on in our store.
Just the option to chose would be nice.
Although the built in function is nice, the function to select is better.

For the ftp, downloading and renaming is fine, but then we cant use the direct uploading feature on our store which is easier and less time consuming.
Why buy a dog and bark yourself?

The ability to name the feed before uploading would be better.

CC	01-29-2005 02:58 PM

Sorry, forgot to say, this updated code by shishapipe is duncan's code updated for 4.0.x...

I appreciate it was his original code, but then he did give permission to alter it and display it on the forums, I can only presume that once this thread is forgotten it will not effect your sales.

I can only feel a little hesitant to this as we have a mod of yours we purchased through carrie which isnt yet working without error, let alone thinking about the release of one where the code is now freely available...

groovico

01-30-2005 11:10 AM

Quote:

Originally Posted by CC

Please forward any error requests through our site at firetanksoftware.com.

Please note there is a difference between errors and features that are not implemented yet.

I'm happy to say we've got a very good track record for bug/fix ratios, alongside this the majority of customer features requests are also implemented in major releases so it's worthwhile posting your features/wants directly to us.

As mentioned the froogle issues aren't bugs, the froogle export was designed to work with the US version and hasn't been altered since. It does work with the UK version but is dependant on how your store VAT is set up. Both login name and tax features will be built in the next revision.

With regards to funkydunks scripts they will be modified, enhanced and supported before release via firetanksoftware, we specialise in creating x-cart solutions that have the least amount of impact on your store and upgrade procedures so wherever possible modficiations will me changed to operate differently.

Customers have always had the option between using freely avialable code and using commercial modfications, it's purely down to what you feel happier using from a business perspective.

The onus is on us to create something worth paying for over and above what is available freely, this comes in the form of enhancement and robustness based on our experience with all x-cart versions.

shishapipe

02-01-2005 11:26 AM

Quote:

Can anyone help with the above problem !!!!
You can see what i mean if you go to the web site www.shishapipe.net/shopcart/home.php and select a product out of stock, then click notify, then enter your email address, and once completed you will see the right hand catagory display wrong.

CC	02-01-2005 11:33 AM

rearrange the cells and tables.

If you look in the code you can see you have one too many:

</td>
</tr>
</table>

Removing it should sort the problem.

shishapipe

02-02-2005 09:37 AM

Thanks for that CC, yes you was right :)

Here is the revised file that works great now.
shopcart/skin1/modules/stock_notify/stocknotify.tpl

Code:

{* stocknotify.tpl funkydunk.net 2003 - changed by Maxking *}

{capture name=dialog}

{if ($login ne "") or ($guestlogged ne "")}

{include file="modules/stock_notify/addedtolist.tpl"}

{else}

{include file="check_email_script.tpl"}

{include file="check_required_fields_js.tpl"}

{$lng.txt_addme_notify}

<SCRIPT type="text/javascript" language="JavaScript 1.2"> 

var requiredFields = new Array(); 

requiredFields[0] = new Array('guestemail', "{$lng.lbl_send_your_email|strip_tags|replace:'"':'\"'}", false); 

</SCRIPT> 

<TABLE border="0"> 

<FORM action="notify.php" method="post" name="notify"> 

<INPUT type="hidden" name="mode" value="notify"> 

<INPUT type="hidden" name="productid" value="{$productid}"> 

<TR>

<TD class="FormButton">{$lng.lbl_send_your_email}:</TD> 

<TD><FONT class="Star">*</FONT></TD> 

<TD><INPUT value"Enter Your Email" id="guestemail" type="text" size="45" name="guestemail" onchange="javascript: checkEmailAddress(this);"></TD>

</TR> 

</FORM> 

</TABLE> 

{include file="buttons/submit.tpl" style="button" button_title=$lng.lbl_stock_notify_button href="javascript: if(checkRequired('')) document.notify.submit();"}

{/if}

{/capture} 

{include file="dialog.tpl" title=$lng.lbl_stock_notify content=$smarty.capture.dialog extra="width=100%"}

wallachee

03-03-2005 04:48 PM

I bought this Mod back when it was available for 3.5 ... The mod works great, but it only works if you go to the product page to update the quantity in stock. We mostly update our inventory by going to product modify, searching for the product, and then just updating it from that page.

Can anyone tell me what I have to do to get this mod to work by adding inventory from the product modify page?

Thanks,
Bradley

clubsrefinished

05-04-2005 05:22 AM

shishapipe,

I have recreated your excellent instructions for all of the templates & php amendments however the final thing I had to do was to add

CREATE TABLE xcart_notify (
email char(128) NOT NULL ,
productid int(11) NOT NULL ,
KEY email_proudct (email, productid),
) TYPE=MyISAM;

via the patches section of the admin section. When I attempt to do this I get the following error

INVALID SQL: 1064 : You have an error in your SQL syntax near ') TYPE=MyISAM' at line 5
SQL QUERY FAILURE: CREATE TABLE xcart_notify ( email char(128) NOT NULL , productid int(11) NOT NULL , KEY email_proudct (email, productid), ) TYPE=MyISAM

Any idea as to what may be causing this.

Hope to hear from somebody soon as I can't wait to try out this mod :wink:

the counselor

05-04-2005 01:35 PM

Hello,

Is this MOD still Available?

Has it been standardized in xcart?

Regards,
The C

CC	05-04-2005 04:34 PM

Yes, it is available via this thread, read back.
No it is not part of XC.

clubsrefinished

05-05-2005 12:02 AM

Hi,

I have sorted out what the problem was. The original post had an extra comma in the code that was causing the problem therefore

Code:

CREATE TABLE xcart_notify ( 

email char(128) NOT NULL , 

productid int(11) NOT NULL , 

KEY email_proudct (email, productid), 

) TYPE=MyISAM;

should read

Code:

CREATE TABLE xcart_notify ( 

email char(128) NOT NULL , 

productid int(11) NOT NULL , 

KEY email_proudct (email, productid)

) TYPE=MyISAM;

I can confirm that I followed all of the instructions listed in this thread and this mod works great for me.

A huge token of thanks needs to go to shisapipe for updating funkydunk's original code so well. :D

CC	05-05-2005 03:52 AM

You should also note the word "product" is not spelt correctly in this line:

Code:

KEY email_proudct (email, productid)

All times are GMT -8. The time now is 04:29 AM.

Page 2 of 3

Show 40 posts from this thread on one page