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
Save Password
Forgot your Password?

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

Starting Member

United Kingdom
12 Posts

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

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.


VP-ASP Super User

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


Hope this helps,


Cam Flanigan
YourVirtualStore Sales
web: http://www.yourvirtualstore.net

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