Unable to set the CURRENCY variable on a Commission Junction tag of Advanced type

[sujani_koya]

Hi!

I have a Commission Junction tag of 'advanced'  Sale tag type configured on the Thankyoupage after purchase.  ITEM, QTY, AMT and DCNT are mapped to the respective variables in the Ecommerce extension.  The help docs for the tag said that not mapping the CURRENCY will set it to USD. Unfortunately that was not happening. The Currency was being set to the _ccurrency value of the Ecommerce Extension.  That value has been set to hold the local currency for example EUR.  I tried mapping the text 'USD' to the currency value using a SDV extension. This was however setting two instances of the currency variable to 2 values - one being USD and the other EUR.  

https://www.emjcd.com/u?CURRENCY=USD&CID=11111&OID=10884474859&TYPE=342268&CURRENCY=EUR&ITEM1=323700200&AMT1=249.99&QTY1=1&DCNT1=0.00&METHOD=IMG

How can I remove the CURRENCY=EUR from the tag?

Thanks a lot,

Sujani

[brian_kranson]

@sujani_koya I sent you a private message looking for a little more detail.  The path you are going down is correct, there is some detail along the way that is getting missied.  Once you send me more detail via private message I can look into it for you and see what got missed.

Brian

[sujani_koya · Accepted solution]

Hi  Brian,

A colleague helped me out with this.  My  earlier solution of overriding all currency codes to the value 'USD' worked but it seemed dangerous.  I was after all changing an E-Commerce variable!  So we decided to change the version template of the Commission Junction tag thus.

//c.push('CURRENCY='+(b._ccurrency!=""?b._ccurrency:"USD"));
c.push('CURRENCY=USD');

We commented out the first line and added the second.  Now the URL of the pixel is the way we want with minimum change.

Thank you,

Sujani

[brian_kranson]

@sujani_koya

We are happy to know you have found a solution.  However for anyone else that comes along and reads this thread, I would like to point out this is not a preferred soluiton.  The point of the template is that you just pass data into the template and then you don't have to write and/or modify JavaScript.  

In this case, b._ccurrency must have been empty for the template to pass USD as the value.  The better approach would have been to update currency (in most cases this will be order_currency in your UDO) before the E-Commerce Extension.  Then when the E-Commerce Extension runs, order_currency will become b._ccurrency.  However it should be noted that this change will change Currency for all of your Tags, not just Commission Junction.

If you only wanted change the currency for Commission Junction, you could use a Set Data Value Extension and make sure you scope the extension to Commission Junction.  Then you can Set b._ccurrency to USD just for this one tag.

In you want screenshots of how to do this, please let me know and I can provide them.