OpenCart Community

My opencart version is 1.4, and I will pay $10 for your help.

I need help setting up adwords & Adcenter Conversion Tracking script properly.

1) I want to track the "total amount" from each order rather than a constant revenue amount from each sale conversion. i.e so some customer will buy $10.27, some will buy $25.88, etc etc etc.

-What would I put in the adwords conversion tracking: "Revenue for your conversion"

var google_conversion_value = 0;
if (XXXXX) {
google_conversion_value = XXXXX;
}

2) In ADCENTER, I put a variable amount to track instead of constant value, it then just give me the tracking script. What do I need to change/edit this script to make it track my variable "total amount" revenue for opencart.

<script type="text/javascript"> if (!window.mstag) mstag = {loadTag : function(){},time : (new Date()).getTime()};</script> <script id="mstag_tops" type="text/javascript" src="//flex.atdmt.com/mstag/site/775d5597-8684-4d34-b084-ac36adec2b11/mstag.js"></script> <script type="text/javascript"> mstag.loadTag("analytics", {dedup:"1",domainId:"161299",type:"1",revenue:"",actionid:"31226"})</script> <noscript> <iframe src="//flex.atdmt.com/mstag/tag/775d5597-8684-4d34-b084-ac36adec2b11/analytics.html?dedup=1&domainId=161299&type=1&revenue=&actionid=31226" frameborder="0" scrolling="no" width="1" height="1" style="visibility:hidden;display:none"> </iframe> </noscript>

3) Now where do I put the adwords & adcenter conversion tracking script to properly track my conversions after checkout success for opencart.

You can PM me how to do this, or post it here. I will pay $10 for the 1st person to help me with this. Thank you.

BTW my version is 1.4 . Let me know if you require any other info. Thank you for looking

Nobody's got an idea how to do "total revenue" conversion tracking? I can pay more if it requires more time to figure this out. Thanks

LOL? $10? Are you joking man... Even u offer $100 i guess people may not consider about it..

I am also interested in the answer to this question. Is it possible to dynamically include sales amount to the Adwords tracking code so that conversion ROI may be accurately tracked?

I will also toss in another $10 to solve this problem. ;-)

This is a common problem that many people faces, anyone willing to help?

Just found this thread - perhaps I will be rich.
I've written a vqmod that inserts the Google Adwords Conversion tracking code and passes the total value of the sale to Google.
The limited testing I've done suggests this works. You can't just drop the vqmod in as you will need to alter the tracking information from google to be for your site.

I'm using 1.5.1.1 and haven't tested in other versions.
Default template.
Based on original files.

I think it will be obvious from looking at the VQMOD where you need to put in your google data, but if not just let me know.

NB this isn't for google analytics tracking, its for google adwords tracking.

Please PM me for my paypal address for all those $10's, $100's etc...

Hi Teratyke thank you for your usefull post.. I need more help.. can you tell me where to put the "get_total_to_success.xml" file ? or do I have to paste the code inside success.tpl?

Thank you for help
Supernoa

teratyke wrote:Just found this thread - perhaps I will be rich.
I've written a vqmod that inserts the Google Adwords Conversion tracking code and passes the total value of the sale to Google.
The limited testing I've done suggests this works. You can't just drop the vqmod in as you will need to alter the tracking information from google to be for your site.

I'm using 1.5.1.1 and haven't tested in other versions.
Default template.
Based on original files.

I think it will be obvious from looking at the VQMOD where you need to put in your google data, but if not just let me know.

NB this isn't for google analytics tracking, its for google adwords tracking.

Please PM me for my paypal address for all those $10's, $100's etc...

Hi
I just pm'd you, however the best thing to do is to install vqmod...
http://forum.opencart.com/viewtopic.php?f=23&t=24529
or failing that open the xml file and read it, it makes good sense, well it does to me..
there are only three changes - I'll talk you through them (but really vqmod is best)
in before insert then in after insert (you will need to edit the following to match your google generated code - the important bit is the line starting google_conversion_value.) then in after insert I think that's it. Default template and version 1.5.1.1 although SIMILAR changes seem to work with other versions. I can't say thisis a perfect solution or not, but it seems to work and as yet hasn't broken anything...

Thanks
Rob

Thank you Rob for your help with vqmod.

I have install everythings vqmod and set up get_total_to succes.xml (i place it in xml folder)

But conversion is not working... instead I get this error in http://www.mywebsite.com/store/index.ph ... ut/success:

Notice: Undefined index: ADtotal in /home/......web/public_html/MYSITE.com/store/vqmod/vqcache/vq-catalog_controller_checkout_success.php on line 4

I don't know how to manage this... I check ADtotal and value is =1

Note: I don't use default template but leonardo-white template but the problem seems to be before the code of template

Thank you for your Help
David

Can you post (or pm) me the code from the three cached files (in your vqmod cache)?
The files are...
vq-catalog_controller_checkout_confirm.php
vq-catalog_controller_checkout_success.php
vq-catalog_view_theme_YOURTEMPLATE_template_common_success.tpl
Also, what version are you using, the changes are a little different for 1.4.x
THanks
Rob

NB - I think the problem might be in catalog/controller/checkout/confirm.php

I modified this code to make it work with my affiliate partner, for tracking affiliate sales. It works great, but does somebody know how to seperate the freight from the total? I dont pay affiliates for the freight, just the products.
I cant find the parameter for the freight.

Something like:
$Affiliatetotal = $ADtotal-$Freight;

And does somebody know how to always get the value in a specific currency.
I sell to different countries, but the affiliate value should always be in swedish kronor.

Thank you
/Stefan

we are trying to apply this vqmod but are running
version 1.4.9.1

i see it was previously mentioned there are some changes needed, Any advise as dont really knwo where to start?

Excellent! Just what I needed and even in a convenient vqmod. Even works for iDeal.

Thanks a million!

This is the version I am using for 1.5.4.1. I wrote it ages ago and I think it fixed a bug or two that left warnings in the error log (it works just the same).
Change the xxxxx bits to be your google data.

Sorry I can't offer support for this. But it does work on my 'near' vanilla install of 1.5.4.1 (pretty sure I've been using it since 1.5.1).

Thanks
Rob

gosulove wrote:LOL? $10? Are you joking man... Even u offer $100 i guess people may not consider about it..

True! Even "simple" issues like this often take more time to fix than you think, as you can see from the posts above.

I know this is an old thread, but I was wondering about what to put in the conversion value field when going through the steps to create the code. Per the instructions, I'm supposed to use (<? echo $totalValue ?>) for dynamic tracking, but I don't see that in the xml file that is attached. Do I still use this value, or something else?

Thanks in advance!

I think you need to use $ADtotal

paulfeakins wrote:

gosulove wrote:LOL? $10? Are you joking man... Even u offer $100 i guess people may not consider about it..

True! Even "simple" issues like this often take more time to fix than you think, as you can see from the posts above.

Totally agree!

DL

themannn wrote:I modified this code to make it work with my affiliate partner, for tracking affiliate sales. It works great, but does somebody know how to seperate the freight from the total? I dont pay affiliates for the freight, just the products.
I cant find the parameter for the freight.

Something like:
$Affiliatetotal = $ADtotal-$Freight;

And does somebody know how to always get the value in a specific currency.
I sell to different countries, but the affiliate value should always be in swedish kronor.

Thank you
/Stefan

Hi, can you provide me help with affiliate code of mine. I need to send total and order ID to them. Can you help with your code. I will modify for my needs.