Cam
VP-CART Super User
Australia
361 Posts |
Posted - March 12 2004 : 08:26:26
|
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 ************************************* |
|
|