Simple Google Analytics - Support

[DTB]

Just in case someone is still on 1.2.x and wants to implement the Google Analytics:

Here is what needs to be done on 1.2.x:

1) Install the Mod like described in the README file.
2) Modify the core file /includes/classes/db/sql/query_factory.php:

a) Find around line 268

function queryTime() {
return $this->total_query_time;
}

}

b) Add right AFTER the function queryTime() and BEFORE the second curly brace the following code from the 1.3.x version of this file.
The final result looks like this:

function queryTime() {
return $this->total_query_time;
}

function getBindVarValue($value, $type) {
$typeArray = explode(':',$type);
$type = $typeArray[0];
switch ($type) {
case 'csv':
return $value;
break;
case 'passthru':
return $value;
break;
case 'float':
return (!zen_not_null($value) || $value=='' || $value == 0) ? 0 : $value;
break;
case 'integer':
return (int)$value;
break;
case 'string':
if (isset($typeArray[1])) {
$regexp = $typeArray[1];
}
return '\'' . $this->prepare_input($value) . '\'';
break;
case 'noquotestring':
return $this->prepare_input($value);
break;
case 'currency':
return '\'' . $this->prepare_input($value) . '\'';
break;
case 'date':
return '\'' . $this->prepare_input($value) . '\'';
break;
case 'enum':
if (isset($typeArray[1])) {
$enumArray = explode('|', $typeArray[1]);
}
return '\'' . $this->prepare_input($value) . '\'';
default:
die('var-type undefined: ' . $type . '('.$value.')');
}
}
/**
* method to do bind variables to a query
**/
function bindVars($sql, $bindVarString, $bindVarValue, $bindVarType, $debug = false) {
$bindVarTypeArray = explode(':', $bindVarType);
$sqlNew = $this->getBindVarValue($bindVarValue, $bindVarType);
$sqlNew = str_replace($bindVarString, $sqlNew, $sql);
return $sqlNew;
}

function prepareInput($string) {
return @mysql_real_escape_string($string);
}
}


It seems to be working without a glitch on the 1.2.5 code.

All the best,
--dreamdaily

hi all...

i just followed these steps as i'm running 1.2.4 and it doesn't seem to be working.

Before doing the additional change that dreamdaily suggests, it all functioned properly, but on Google Analytics it said i wasn't configured properly, and wasn't set up yet...

I then tried dreamdaily's suggestion for 1.2.x users, and i couldn't load a single thing (admin or catalog) as it said there was an error in my query_factory file...
any suggestions cuda?

[tomato]

If someone could help me with this it would be greatly appreciated. I have tried several times to get Google Analytics working. I have installed according to the readme and put my account number in admin. I am currently using Zen-Cart version 1.3.5 my site is located at http://www.japanshopdirect.com

Thank you for your time and any help/advice that you can offer me.

[econcepts]

If someone could help me with this it would be greatly appreciated. I have tried several times to get Google Analytics working. I have installed according to the readme and put my account number in admin. I am currently using Zen-Cart version 1.3.5 my site is located at http://www.japanshopdirect.com

Thank you for your time and any help/advice that you can offer me.

What seems to be the problem? I went to the site and did a "view source". The code shows Google Analytics installed? Here is the end of your page:

<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-1873077-5";
urchinTracker();
</script></body></html>

What makes you think it isn't working?

[tomato]

When I log in to my Google Analytics account I get this:

"Tracking for your website has not yet been validated: www.japanshopdirect.com
Click 'Check Status' to validate whether or not you have added tracking correctly to your website's home page. Clicking the 'Check Status' will also provide instructions for adding tracking to your website."

But I have am pretty sure I have followed all of the steps. This seems like an easy thing to integrate into my site but I cant put my finger on why it isn't working.

[econcepts]

You have to click on "check status" for Google to make sure your code is on the page. Once that is complete, the message will turn to "Waiting / Receiving for data..." in your Google Account.

SO, you are close, but Google can't gathering data to track if you haven't told it the code is present yet. See?

[tomato]

Thank you for the reply but I did do that. I guess I will let it go maybe it takes time to start working but it's been more than a day. I'll give it another day and then uninstall it if it doesnt work. Im just curious why it isnt working. The information google provides looks interesting so I really wanted to use this.

[DTB]

ugh, i want this to work, but it won't!

[DTB]

ok, so i started over.

went back, and began at step 1 in the readme...

i replaced my:

<body id="<?php echo $body_id; ?>"<?php if($zv_onload !='') echo ' onload="'.$zv_onload.'"'; ?>>

with the suggested:

<body id="<?php echo $body_id . 'Body'; ?>"<?php if($zv_onload !='') echo ' onload="'.$zv_onload.'"'; ?>>

and still no dice..


as i posted before, i did try that change that dreamdaily suggested, but haven't tried it again, since my re-started attempt...

my catalog site is:

http://www.designertoybox.com/index.php

if anyone can help, i would be eternally grateful...

thank you..

bill

[econcepts]

ok, so i started over.

went back, and began at step 1 in the readme...

i replaced my:

<body id="<?php echo $body_id; ?>"<?php if($zv_onload !='') echo ' onload="'.$zv_onload.'"'; ?>>

with the suggested:

<body id="<?php echo $body_id . 'Body'; ?>"<?php if($zv_onload !='') echo ' onload="'.$zv_onload.'"'; ?>>

and still no dice..


as i posted before, i did try that change that dreamdaily suggested, but haven't tried it again, since my re-started attempt...

my catalog site is:

http://www.designertoybox.com/index.php

if anyone can help, i would be eternally grateful...

thank you..

bill

What version of Zen are you running? If you can get me quick access (FTP) to the site, I can look at what is going on and try to get it installed for you. PM me the details if you are interested. It really shouldn't be this hard?

Also, do you have any other mods running on the site? Not that it would matter too much, but it is good to know. Just shoot me a private message if you want me to look at it further. I'd be happy to.

[econcepts]

ugh, i want this to work, but it won't!

If you can't get it to work using the Mod. You may want to try the "manual install" method (the mod does not need to be installed).

I used Google Analytics on an older Zen 1.2.x version and it worked just fine. I installed analytics, conversion tracking, and e-commerce tracking manually (before the Simple Analytics mod was even available -- or I might have tried that route).

Anyhow, I listed out the manual steps and code to get it installed here for another user. It may help.

http://www.zen-cart.com/forum/showthread.php?t=43907