Google Analytics Integration

[a_berezin]

There are two types of installs. Choose one or the other:
...

Thank you Woody! Add this comments to readme.

[yellow1912]

I have this mysql error while trying to use the sql file:

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'customers', 'delivery', 'billing'),'), (NULL, 'Affiliation', 'G
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Enter your Google Analytics account number', @t4, 1, NOW(), NOW(), NULL, NULL), (NULL, 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'What adress (City/State/Country to correlate the transaction with) use in Analytics transaction?', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('customers', 'delivery', 'billing'),'), (NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Optional partner or store affilation', @t4, 3, NOW(), NOW(), NULL, NULL), (NULL, 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Using as Product SKU code', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('products_id', 'products_model'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[yellow1912]

I found out the reason: I believe my server has the option to auto-strip backslash on (which is called automagicquote or something, forgot it), that's why the script wont work for everyone. I had to manually execute the script (and the modify the groupid).
Anyhow, it works now, thank you for this great mod, save me time editing the template.

[dwessell]

Hi all.. I'm a tad confused on something.. How is this contribution differ from just adding the Google Analytics code to the bottom of the footer?

Thanks
David

[kaylala]

I also had the same mysql error as posted above by "yellow1912"... but I do not know how to manually execute the script like they did. Any tips?

thanks!

[mafiasam]

I had this older version of analytics

v 1.1.2 23.11.2006 14:01

on my site and it was working great until I had to restore a full backup of my store and the database. Now the code looks like this when I do a view page source...

<script type="text/javascript">
function zen_urchinTracker() {
  var scrUTM = document.createElement("script");
  scrUTM.type = "text/javascript";
  scrUTM.src = "http://www.google-analytics.com/urchin.js";
  document.body.appendChild(scrUTM);
  var scrUTM = document.createElement("script");
  scrUTM.type = "text/javascript";
  scrUTM.text = "\n  _uacct = 'UA-737751-1';\n  urchinTracker();\n"; 
  document.body.appendChild(scrUTM);
  
}
</script>

Not sure if that looks right but my analytics are not being recorded now. Need some advice on how to uninstall and do fresh install of this older version or possibly upgrade to the newest verison.

zencart version 1.3.6

thanks

[a_berezin]

Delete
/includes/templates/YOUR_TEMPLATE/jscript/on_load/on_load_google_analytics.js
/includes/templates/YOUR_TEMPLATE/jscript/jscript_google_analytics.*
/includes/modules/pages/checkout_success/jscript_google_analytics.*

[mafiasam]

Delete
/includes/templates/YOUR_TEMPLATE/jscript/on_load/on_load_google_analytics.js
/includes/templates/YOUR_TEMPLATE/jscript/jscript_google_analytics.*
/includes/modules/pages/checkout_success/jscript_google_analytics.*

I am assuming that was for uninstalling the contribution...

Well, I ended up figuring it out. Basically when the backup was restored there were name changes to various files and folders. So the folder
/includes/templates/YOUR_TEMPLATE/jscript/on_load/
was changed to a file and obviously appeared to the app that it was missing. I restored the folder and now it's back to its reliable old self.

Thanks Andrew.

[100asa]

It's strange: yesterday I've had 2 orders, eur247,00 and eur1.160,37
In analytics I see totale ecommerce transaction=eur248,00
It's strange!!!

[a_berezin]

100asa,
What version and what variant you use?