Posted - December 10 2006 : 20:25:35
This requires a modification to paypalgateway.asp.
You will need to replace the paypalGetDatabaseFields sub routine with the following:
Dim Dbc, myname, amount, shippingamount
OpenOrderdb dbc ' Open the database
strsql = "select * from orders where orderid=" & oid
Set Orders = dbc.execute(strsql)
If Not Orders.eof then
amount=orders("orderamount") 'this may need to be amount=orders("producttotal")
If CommaAsDecimal="Yes" then
paypaldofield "amount", amount
paypaldofield "shipping", shippingamount
debugwrite "Cannot find order"
Please note that this may need to be slightly modified in each individual case depending on whether the value of ordertotal in your
orders table already accounts for shipping and handling.
As this code may need to be modified depending on each individual's situation, we cannot provide support for it - it is provided simply as a guide to assist those who wish to display their shipping amount separately at Paypal.