Google Analytics update

[besheer]

Just wondering if the instructions posted here: http://www.zen-cart.com/forum/showth...ight=analytics on how to integrate GA into ZC are still valid with the newest version (1.3.0.1). Sorry to start a new thread, but the other one is locked and I would really like to use GA without breaking the cart.

This is what they had concluded I think:

#1 Go to your Google Analytics Settings -> Edit Settings -> Edit Main Website Profile -> E-Commerce Website : Yes

#2 Edit
includes/templates/your-template/common/html_header.php
At the very bottom just before </head>

<?php if ($request_type == 'NONSSL') { echo
'<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-XXXXXX-1";
urchinTracker();
</script>'; } 
else { echo
'<script src="https://ssl.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-XXXXXX-1";
urchinTracker();
</script>'; } 
?>
</head>

#3 Create a new file:
includes/modules/pages/checkout_success/on_load_ga.js
Insert into the new file:

javascript:__utmSetTrans()

#4 Edit
includes/templates/template_default/tpl_checkout_success_default.php
At the very bottom add:

<?php
$ga_orders_id = $db->Execute("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "' order by date_purchased desc limit 1");
$ga_utm_t = $db->Execute("select order_total , order_tax, delivery_city, delivery_state, delivery_country from " . TABLE_ORDERS . " where orders_id = '" . $ga_orders_id->fields['orders_id'] . "'");
$ga_utm_t_delivery_country = $db->Execute("select countries_iso_code_2 from " . TABLE_COUNTRIES . " where countries_name = '" . $ga_utm_t->fields['delivery_country'] . "'");
$ga_utm_t_delivery_state = $db->Execute("select zone_code from " . TABLE_ZONES . " where zone_name = '" . $ga_utm_t->fields['delivery_state'] . "'");
$ga_utm_t_ship = $db->Execute("select value from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . $ga_orders_id->fields['orders_id'] . "' && class = 'ot_shipping'");
$ga_utm_i = $db->Execute("select * from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . $ga_orders_id->fields['orders_id'] . "' order by products_name");
//$ga_utm_i_category = $db->Execute("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $ga_utm_i->fields['products_id'] . "'");
//$ga_utm_i_category_name = $db->Execute("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $ga_utm_i_category->fields['categories_id'] . "'");

$ga_utm_i_array = array();
while (!$ga_utm_i->EOF) {
  $ga_utm_i_array[] = array('product_id' => $ga_utm_i->fields['products_id'],
               'name' => $ga_utm_i->fields['products_name'],
               'price' => $ga_utm_i->fields['final_price'],
               'quantity' => $ga_utm_i->fields['products_quantity'],
   //'category' => $ga_utm_i_category_name->fields['categories_name']
   );
  $ga_utm_i->MoveNext();
 }
?>
<form style="display:none;" name="utmform">
<textarea id="utmtrans">
UTM:T|<?php echo $ga_orders_id->fields['orders_id'] . '|' . "zencart" . '|' . $ga_utm_t->fields['order_total'] . '|' . $ga_utm_t->fields['order_tax'] . '|' . substr($ga_utm_t_ship->fields['value'], 0, 4) . '|' . $ga_utm_t->fields['delivery_city'] . '|' . $ga_utm_t_delivery_country->fields['countries_iso_code_2'] . '|' . $ga_utm_t_delivery_state->fields['zone_code']; ?>

<?php $ga_utm_i_array_displayed = array();
for ($i=0, $n=sizeof($ga_utm_i_array); $i<$n; $i++) {
if (!in_array($ga_utm_i_array[$i]['products_id'], $ga_utm_i_array_displayed)) {
echo ' UTM:I|' . $ga_orders_id->fields['orders_id'] . '|' . $ga_utm_i_array[$i]['product_id'] . '|' . $ga_utm_i_array[$i]['name'] . '||' . sprintf("%01.2f", $ga_utm_i_array[$i]['price']) . '|' . $ga_utm_i_array[$i]['quantity'];
   }
 }
?>

[besheer]

In case anyone is wondering, I've been using it for a few days and everything seems to be working alright.

[DrByte]

The more effective way to do the step you mentioned above for "includes/templates/your-template/common/html_header.php" is to create a new file called:
includes/templates/YOURTEMPLATE/jscript/jscript_google_analytics.php

... and put the code you suggested above into that file instead.

This will make upgrading Zen Cart easier because it won't have touched the html_header.php core file.

[besheer]

But being in the includes/templates/your-template/common/ directory, isn't the file untouched anyway?

[DrByte]

yes, it's untouched, but if the next version of zen cart includes an update to the template_default/common/html_header.php file, then YOU NEED TO MERGE THOSE CHANGES into YOUR includes/templates/XXXXXCUSTOM/common/html_header.php file

I was just suggesting to use the jscript overrides system to save yourself the step.

[wickedklown]

drbyte,

You said to create another file in the jscript directory. Exactly what code should be entered into that file? all of it, or just the stuff thats suppose to be in html_header.php?
and the rest of it is as stated? or does all the code go into that one file?

Any help would be great

[wickedklown]

sorry for the double post, but im noticing something that might be a problem


for some reason the tpl_checkout_sucess_defualt.php file is located in

/includes/templates/template_defult/templates

is this correct, or did i mess something up when i updated??????

everything has been functional, although this dont seem to be the correct structure that you guys have listed here...


please help

[wickedklown]

well it seems to be working, however i dont see any of my sales being shown on the google page.....

anyone else having this issue?

[besheer]

You have to set it up as an "e-commerce" site. It's hidden somewhere in the Google Analytics settings.

[kelvyn]

Regarding YAHOO conversion tracking, it gives a single file like:

Example of a basic HTML document using recommended tagging method

<html>
<head>
<title>Sample HTML File</title>
<SCRIPT LANGUAGE="JavaScript">
<!-- Overture Services Inc. 03/01/2003
var ov_tagVersion = "1.0.0";
var ov_accountID = "XXXX";
var ov_queryStr = "?" + "tv=" + ov_tagVersion + "&ai=" +
ov_accountID + "&rf=" + escape(document.referrer);
var ov_convImage = new Image();
ov_convImage.src = "//oa.overture.com/Conversion.gif" +
ov_queryStr;
// -->
</SCRIPT>
</head>
<body>
This is the content of your web page.
</body>
</html>

Maybe I'm doing something wrong, but I tried putting my file in a similar file to jscript_yahoo_conversion.php (along the lines of Dr Byte's suggestion) but it's not including it. Can two javascripts be called? Or have I made a typo?