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

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)

Quote:

Originally Posted by CC

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

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.

Quote:

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 ?

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.

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.

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%"}

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

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:

Hello,

Is this MOD still Available?

Has it been standardized in xcart?

Regards,
The C

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

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

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

Code:

KEY email_proudct (email, productid)