Affliliate tracking code - please help

[Donna Kempster]

I am trying to set up an affilaite scheme and have used netquotevar:actinicordertotal but this gives the amount in pence not in £ and pence and our affiliate network need the code to show the amount with a decimal point in it. How to I get the code to change so that it shows with the decimal point in it.

Really need help as I've tried searching and used things people have suggested but this hasn't worked - can anyone help me?? Donna

[Kermy]

Hi Donna

Assuming your tracking code is javascript based (e.g. Google adwords) it will look something like

var realprice=NETQUOTEVAR:ACTINICORDERTOTAL;

All you should have to do is divide this total by 100 to get £.

var realprice=(NETQUOTEVAR:ACTINICORDERTOTAL/100);

[Donna Kempster]

<img src="https://www.emjcd.com/u?AMOUNT=(NETQUOTEVAR:ACTINICORDERTOTAL/100)&CID=ouridno&OID=NETQUOTEVAR:THEORDERNUMBER&TYPE=307633&CURRENCY=GPB&METHOD=IMG"height="1"width="20">

Hi This is my code. When it is populating the pixel it simply populates the total ie 200 with the /100 so the affiliate network see's amount=200/100

I'm obviously missing something can anyone please let me know what I've done wrong. Thanks in advance D

[Bruce]

Donna,

You would be best off using NETQUOTEVAR:NUMERICORDERTOTALCGI - the order total partially formatted in the appropriate currency and encoded for CGI. This value include decimal and thousand separators, but leaves off the currency symbol.

Kind regards.

[Donna Kempster]

Bruce I did do that but it just gave them % and random numbers it didn't give them what they needed? Donna

[Kermy]

What about

<script type="text/javascript">

amount=NETQUOTEVAR:ACTINICORDERTOTAL/100;
onum='NETQUOTEVAR:THEORDERNUMBER';

document.write('<img src="https://www.emjcd.com/u?AMOUNT='+amount+'&CID=ouridno&OID='+onum+'&TYPE=307633&CURRENCY=GPB&METHOD=IMG" height="1"width="20">');

</script>

This should perform the p -> £ conversion properly now.

[Donna Kempster]

Thanks very much Kermy I'll try it out. Cheers D