Netquotevar:actinicordertotal

[lee.harris]

Hi All

Probably dead easy if you do Java. Unfortunately, I don't

I need to convert NETQUOTEVAR:ACTINICORDERTOTAL in Order4.html into pounds and pence without the currency symbol, i.e. change the base currency unit from pence to pounds, e.g.

if ACTINICORDERTOTAL = 16999

I want a variable that is 169.99 for passing to our affiliate tracking.

Can anyone give me a steer?

Cheers

Lee.

[pinbrook_nick]

Try this:

<script language="JavaScript1.2">
  <!--

  var act_price = "NETQUOTEVAR:ACTINICORDERTOTAL"
  var pounds = act_price.slice(0,-3) 
  var pennies = act_price.substr(-2,2)

  document.write(pounds + "." + pennies)

  //-->
</script>

[lee.harris]

Thanks very much Nick.

How could this be used in a function to pass to an affiliate scheme as in the AUG:

<IMG SRC="httpS://www.server.com/log.cgi?amount=NETQUOTEVAR:ACTINICORDERTOTAL&orderid=NETQUOTEVAR:THEORDERNUMBER">

???

TIA

Lee.

[pinbrook_nick]

Have a go with this:

<script language="JavaScript1.2">
  <!--

  var act_price = "NETQUOTEVAR:ACTINICORDERTOTAL"
  var pounds = act_price.slice(0,-3) 
  var pennies = act_price.substr(-2,2)
  var affiliate_total = pounds + "." + pennies
  document.write("<IMG SRC='httpS://www.server.com/log.cgi?amount=" + affiliate_total + "&orderid=NETQUOTEVAR:THEORDERNUMBER'>")

  //-->
</script>

[lee.harris]

Thanks Nick. I was hoping that by presenting what I want to do in the context of the AUG that it would be useful for others. It hopefully is but it's not for me

Our affiliate operator takes this code:

<script language="javascript">

merchantID = MERCHANT_SITE_ID
payoutCodes = ""
offlineCode = ""

orderValue = ORDER_VALUE
orderRef = ORDER_REFERENCE

AFProcessSaleV2(merchantID, orderValue, orderRef, payoutCodes, offlineCode)

ORDER_REFERENCE can just be replaced by NETQUOTEVAR:THEORDERNUMBER but I'm struggling to replace ORDER_VALUE with anything meaningful. I simply want to have

orderValue = NETQUOTEVAR:ACTINICORDERTOTAL / 10 but unfortunately, I don't do Java.

I sense that I'm *so* close to this......

[pinbrook_nick]

This is the correct syntax (which you already have!) to divide by 100. (I think it is 100 that you want to divide by, and not 10?)

orderValue = NETQUOTEVAR:ACTINICORDERTOTAL / 100

[lee.harris]

Hi Nick

Spot on on the 10 vs 100.

I tried exactly this (I knew my old Computer Science degree was good for something) yet when I view source on the receipt page, I have:

orderValue = 13999 / 100
orderRef = 17369160000116

for an order with a value of £139.99.

In this section of Act_Order04.html, I have:

orderValue = NETQUOTEVAR:ACTINICORDERTOTAL / 100
orderRef = NETQUOTEVAR:THEORDERNUMBER

I'm well confused.

L.

[NormanRouxel]

Just merge Nick's earlier reply with what your merchant needs:-

<script language="javascript"> 

// nicks bit
  var act_price = "NETQUOTEVAR:ACTINICORDERTOTAL";
  var pounds = act_price.slice(0,-3);
  var pennies = act_price.substr(-2,2);

// now make into a number
  orderValue = (pounds + "." + pennies) - 0;

// and the merchant bit
merchantID = MERCHANT_SITE_ID 
payoutCodes = "" 
offlineCode = "" 
orderRef = NETQUOTEVAR:THEORDERNUMBER 

AFProcessSaleV2(merchantID, orderValue, orderRef, payoutCodes, offlineCode)

Norman

[lee.harris]

Now up & running. The solution was the NETQUOTEVAR:ACTINICORDERVALUE/100 but I was just confusing myself looking at the source.

Thanks for all your help Nick & Norman.

You should consider selling these scripts to Actinic