Tracking order total before VAT and shipping on receipt page?!?!

[paulbeckett]

Hi all

We are trying to work with a number of affiliates (including Webgains and Twenga) but need to provide their tracking systems with a value of the order total before VAT and shipping.

We have liaised with Actinic Support who indicated the following variable should be used on this variable:

track.totalHT = <Actinic:Variable Name="SubTotal"/>

.

However when we do a test transaction this fails!

Here is an extract of the code on the reciept page in Actinic v10:

track.totalHT = <Actinic:Variable Name="SubTotal"/>
track.currency = "GBP";
track.totalTTC = <Actinic:Variable Name="NumericOrderTotalCgi"/>

and here is an extract of the source code on the web following a test transaction.

track.totalHT = NETQUOTEVAR:SUBTOTAL
track.currency = "GBP";
track.totalTTC = 3%2e40

Note the order total (track.totalTTC) works correct (£3.40) but the subtotal (track.totalHT) brings up an error (NETQUOTEVAR:SUBTOTAL)!?!?

We suspect that the pearl scripts do not pass the "sub total" value through to reciept page but so far Actinic Support have been unable to confirm what is going on.

Does anyone have any experience with the subtotal value on the receipt page?

[paulbeckett]

This is some of my "theory" information that I have sent to Actinic Support in order to help them find a resolution...

I'm not sure if the SubTotal variable exists in the Reciept page according to Actinic help files...

I think the the SubTotal variable only exists in the Shopping Cart (according the Variable Reference Guide)! For instance, if you go to Actinic v10 > Help > Variable Reference Guide > Variables By Product Area > Shopping Cart > SubTotal.

Likewise, a previous post indicated pearlscript need to be modified to track sales with the subtotal...

2. The following post (http://community.actinic.com/showthread.php?t=35166) states the "need to build a order total variable that doesn’t include either shipping or tax (as you don’t want to pay commission on these). To do this the post gives the following instructions:

1. In the site folder find OrderScript.pl
2. Right click and select Open With > Notepad
3. Find -
$::s_VariableTable{$::VARPREFIX.'ACTINICORDERTOTAL'} = $nTotal;
4. Add this code on the following line.
$::s_VariableTable{$::VARPREFIX.'NUMERICSUBTOTAL'} = (($nTotal-$nShipping)-$nTax1)/100;
#get at the coupon code

However Actinic Support seem to be indicating the subtotal value does exist on the receipt page???

Thanks in advance!