VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 tmp_customeremail.htm - I need another field
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tyrone
Starting Member

United Kingdom
12 Posts

Posted - March 05 2004 :  05:04:33  Show Profile  Visit tyrone's Homepage  Reply with Quote
Hi,

refers to: www1.cdos.com (you can place an order to test if you like)

I want to add another field to the email that is generated and sent to the customer.

The new field I need is the total value of the order before tax.

I know that value after tax is: [formatcurrency orderamount]

Can anyone help.

Cheers
Tyrone

Cam
VP-ASP Super User

Australia
361 Posts

Posted - March 12 2004 :  08:26:26  Show Profile  Visit Cam's Homepage  Reply with Quote
You need to add a new field to the order table called osubtotal.

To do this create a new file called convertsubtotal.txt and insert the following, save and upload to your server.

alter table orders add column osubtotal currency NULL;

Run this in your convert500.asp file or use convertsql.asp if using version 4.5 or earlier.

Then open shop$db.asp and locate the following around line 1750:

updatefield "orderamount", getsess("ordertotal")
updatefield "olastname",strlastname

Change to:

updatefield "orderamount", getsess("ordertotal")
'======================================
'add osubtotal to orders table
'12/03/2004
'======================================
updatefield "osubtotal", GetSess("OrderProductTotal")
'======================================
updatefield "olastname",strlastname

Save and close.

In the tmp_customeremail.htm file add the following where you want the sub total displayed:

<strong>Order SubTotal</strong>: [formatcurrency osubtotal]<br>

Set in the config to use the html email template and for emailing to use html.

To see a sample of this working go to our site and download the free rotating banner. You will get an email back with the sub total displaying in the page. It is at the bottom of this page.

http://www.yourvirtualstore.net/rocksalt_v.5/shopdisplayproducts.asp?id=13&cat=Paid+Add%2Dons

Hope this helps,

Cheers,
Cam

*************************************
Cam Flanigan
YourVirtualStore Sales
e-mail:
http://www.vpasp.com/sales/shopcustcontact.asp
web: http://www.yourvirtualstore.net

Build you own YourVirtualStore!!!
www.yourvirtualstore.net
*************************************
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000