High Octane:

Would somebody be so kind as to e-mail me the files?
It seems the site they where hosted on doesn't have them anymore.

Thanks in advance

sales at MoparPartSales dot com
Same problem here, if someone have it i wold like it to try this mod,
Thank you

Supertracker 1.0 has been uploaded to the Zen Cart downloads area.
No code changes. Readme is updated.

Supertracker for Zen Cart
Version 1.0 (Ported to Zen Cart by Andrew Berezin - 05-09-07)
Based on Supertracker v.3.20b (01-11-05) by Mark Stephens

Download from:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=683

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

Supertracker records statistics for each user arriving at your shop and allows merchants to generate various reports.

Straight forward installation. No core files overwritten.

Download latest GeoIP.dat IP database separately
(Required but free - see readme)
Download flags separately
(Optional and free - see readme)

Supertracker records the following data:

• Referring page
• Referring query (allows access to keywords used in search engine)
• Landing page (including query string - important for PPC campaign assessment)
• Arrival time / exit time / exit page
• IP address
• Country code / country name
• Customer's cart contents
• Number of clicks on shop (accuracy is not 100% as this is recorded based on session ID)
• Products viewed / Categories viewed
• Customer ID (if signed in)
• Order ID (if order was placed)
• Were products added to cart? (true/false)
• Did the customer Checkout? (true/false)

Reports Generated:

• Top Referrers
• Top Sales Generating Referrers
• Visiting Countries Stats
• Search Keywords Used - Totals
• Search Keywords Used in Last 24 Hours
• Search Keywords Used in Last 3 Days
• Search Keywords Used in Last Week
• Search Keywords Used in Last Month
• Top Exit Pages (No Sale)
• Top Exit Pages (No Sale, but added to cart)
• Average Clicks on Site by Referrer
• Average Time Spent on Site by Referrer
• Products Viewed Report
• Last Ten Visitors

History

v.1.0.0 05.09.07 a_berezin
(Initial ZC version - based on ported v.3.20b - 01.11.05)

• Code optimization
• Updated Readme (08.04.07)

Small typo in label/constant:

admin/supertracker.php

Lines c. 272 - 280

    case 'landing':
      $title = TEXT_LANDING_PAGE;
      $headings[] = TEXT_SERIAL;
      $headings[] = TEXT_LANDING_PAGE;
      $headings[] = TEXT_NUMBER_OF_OCCURRENCES;
      $row_data[] = 'landing_page';
      $row_data[] = 'total';
      $tracker_query_raw="SELECT landing_page, landing_page_name, COUNT(*) as total FROM " . TABLE_SUPERTRACKER . " GROUP BY landing_page ORDER BY total DESC";
      break;

Needs 'TABLE_' in front of 'TEXT_LANDING_PAGE':

    case 'landing':
      $title = TABLE_TEXT_LANDING_PAGE;
      $headings[] = TEXT_SERIAL;
      $headings[] = TABLE_TEXT_LANDING_PAGE;
      $headings[] = TEXT_NUMBER_OF_OCCURRENCES;
      $row_data[] = 'landing_page';
      $row_data[] = 'total';
      $tracker_query_raw="SELECT landing_page, landing_page_name, COUNT(*) as total FROM " . TABLE_SUPERTRACKER . " GROUP BY landing_page ORDER BY total DESC";
      break;

Pixxi:

Small typo in label/constant:
admin/supertracker.php
Lines c. 272 - 280
Needs 'TABLE_' in front of 'TEXT_LANDING_PAGE':

Thanks Pixxi.

Would you know which Supertracker report(s) where this issue manifests itself?

Woody

Woodymon:

Would you know which Supertracker report(s) where this issue manifests itself?
I see now. If you don't change the define the two Landing Page reports will not show in the drop down. Thanks for the heads up.

BTW some of the features in Supertracker are disabled within the mod code. When Andrew ported he did not plan to further develop this mod, rather he was working on releasing his own tracking mod with features from Supertracker, User Tracking, BBClone, etc. But with Andrew saying goodbye to the Zen Cart community looks like that will never happen. So unless a developer picks this mod up to improve on it don't expect any bug patches or complex fixes or updates to be released. But might as well post your ideas and wishes for this mod in case a developer does pick up on it.

Woody

In YOUR_ADMIN/includes/languages/english/supertracker.php

After Line 65
INSERT

define('TEXT_LANDING_PAGE', 'Landing Page');

It doesn't really matter where you insert it but that seemed like a nice location ;-)

Woody

Hi Woody,

Does the release of SuperTracker in the downloads area include all the fixes discussed in this thread? Including the sql patch from Andrew on the first page of this thread?

I just want to know where I need to start from before I attempt to install this mod.

I love this mod! I've seen it in action on an OSC store. Would love to get it up on my Zen site.

Thanks,
Kevin

StoryBook:

Does the release of SuperTracker in the downloads area include all the fixes discussed in this thread? Including the sql patch from Andrew on the first page of this thread?

As far as I can see no code fixes were discussed or posted to this thread. Only sql patch by Andrew in post #3.

Regarding the questin on if the updated sql patch is in the available download version of Supertracker mod, it is easy enough for you to check. Just download and compare!

At bottom of the announce post:

v.1.0.0 05.09.07 a_berezin
(Initial ZC version - based on ported v.3.20b - 01.11.05)

Since the release date of the mod, as listed above, is AFTER Andrew's sql fix posting, it could be presumed the updated sql patch would be in version in the ZC downloads area. But if you do not like to assume things then as stated it would easy enough for you to compare with the sql posted on the forum and rectify.

At any rate Andrew would not have updated the mod version number just because of a slightly altered sql patch.

But for you I just checked and the version in the downloads area indeed contains the updated sql patch. So please proceed. :wink2:

Woody

Thanks Woody!

Got it installed and it works flawlessly, as far as I can tell right now. Just as soon as I've collected enough data, I'll look over the wealth of information.

I do appreciate the help.

I think it's important to remember, that even though a lot of Zen Cart store owners are ahead of the curve, and have a good working knowledge of coding (or at least as far as ZenCart goes), our primary vocation is in what we sell, not how we sell it.

I am, after all, a potter. I make cookie jars. :P

The Zen Cart community is great, and I hope some day I'll be able to give back some of the help I've received thus far.

Thanks again!
StoryBook

StoryBook:

I think it's important to remember, that even though a lot of Zen Cart store owners are ahead of the curve, and have a good working knowledge of coding (or at least as far as ZenCart goes), our primary vocation is in what we sell, not how we sell it. I am, after all, a potter. I make cookie jars.

I recommended comparing files as it appeared that you did not know you could do that for sql files (otherwise you probably would have done that and not posted your question). sql patch files are just text files. Obtain a good compare tool and learn the basics in using it. If running Windows try WinMerge or Beyond & Compare. Just some hints to help you become a little more self-sufficient in Zen Cart shopowner basics.

I need to visit my potters support website and ask them why my cookie jar broke when I dropped it and how to glue it back together it. Hope they understand my primary vocation is eating cookies, not fixing cookie jars. :wink2:

Woody

Woodymon:

I recommended comparing files as it appeared that you did not know you could do that for sql files (otherwise you probably would have done that and not posted your question). sql patch files are just text files. Obtain a good compare tool and learn the basics in using it. If running Windows try WinMerge or Beyond & Compare. Just some hints to help you become a little more self-sufficient in Zen Cart shopowner basics.

Thanks! I got WinMerge. Neat program, thanks for recommending it. I did as you suggested (now after the fact) so that I can become familiar with the technique. I feel like I just made a major leap forward!

Woodymon:

I need to visit my potters support website and ask them why my cookie jar broke when I dropped it and how to glue it back together it. Hope they understand my primary vocation is eating cookies, not fixing cookie jars. :wink2:

I can help you with that!! First, let me ask you if your jar is vitreous Porcelain, Stoneware, or low-fire ceramic? What cone was the clay body fired at? How long did it soak? :smartalec:

Ha!!

Thanks again. Really!!

Kevin

So I have SuperTracker installed, and every report works just fine, EXCEPT for the last ten visitors report.

For some reason I can't seem to fathom, it is taking up to 45 seconds for the last ten visitors to load. Everything other report works just fine, and I've having no other issues with anything else on the site.

Any ideas?

Kevin

StoryBook:

So I have SuperTracker installed, and every report works just fine, EXCEPT for the last ten visitors report.

For some reason I can't seem to fathom, it is taking up to 45 seconds for the last ten visitors to load. Everything other report works just fine, and I've having no other issues with anything else on the site.

Possibly resolving each customers IP to a host name is contributing to your delay. The resolution occurs at time the report is rendered (such info is not saved to the database)

To test if this may be contributing to your delay comment out the Supertracker code which resolves the IP (to disable the lookup function).

I don't observe this delay on the shops where I have installed Supertracker.

For the wishlist: Add additional switches to Supertracker admin UI config to enable/disable Supertracker features (eg disable host lookup).

Woody

I chased this thing around for two days. Checked every log, looked at everything I had changed or added, ran tests against showmyip, optimized the database, but nothing indicated any problem.

We run SuperTracker on our OSC site, and it works just fine, even during the period that the ZenCart version was having problems.

But this morning, the issue cleared up on it's own. I didn't do anything else that might have fixed it, other than getting a good night's sleep. I have to assume that the issue was on my host's end? Except that my data is stored at the same place as our OSC store.

I dunno...but all's fine now.

Thanks Woody, for responding, and I agree with the "wishlist". It could help problem solving to be able to easily isolate external requests.

Thanks again,
SB

godspeed27:

I am updating my cart for 1.3.0.2 to 1.3.7. I am trying to add this in. It seems to work but when I go to the Configuration>Super Tracker

I just get a blank page. There are no settings. I have run the uninstall sql and the install sql from both the cart admin and myphpadmin. Still the same thing. I also have usertracking install, but this seems to be way better. I am almost sure its a sql problem here.

Any help would be great.

P.S. Andrew, I sent you a pm about other stuff. Thanks for porting this over!

I am having a similar problem, expect, I'm not seeing the supertracker stuff in the reports menu? Any ideas?

cjcrafts:

I am having a similar problem, expect, I'm not seeing the supertracker stuff in the reports menu? Any ideas?
Are you stating when you go to Reports > Supertracker, the resulting page is blank?

Or are you saying when you select the Reports menu, Supertracker does not appear on the Tools dropdown menu?

Or are you saying something else?

But you are observing Configuration > Super Tracker
just fine and can manage the functions on that admin page ok?

Woody

Woodymon:

Are you stating when you go to Reports > Supertracker, the resulting page is blank?

Or are you saying when you select the Reports menu, Supertracker does not appear on the Tools dropdown menu?

Or are you saying something else?

But you are observing Configuration > Super Tracker
just fine and can manage the functions on that admin page ok?

Woody

It's all good now.. It was a screwed up database. Thanks for your swift response.

Hi,

I installed SuperTracker successfully on ZC 1.3.7.1 (fresh installation). I can manage SuperTracker under Configuartion -> SuperTracker. I can also open the report page at Reports -> SuperTracker.

However, the report always say: "Database Info: the Supertracker database currently holds 0 rows (oldest record : )"

It should have at least some info because I've installed it for a few days. My cart has visitors when checking with AWStats. I also disabled the function to exclude myself and bots. Thus, at least, I should see some records of me browsing around. However, nothing was recorded.

Please help me. Thank you very much.

Regards,
Kenny

kennymxp
Welcome to Zen Cart forums
Can we see your cart?

I clicked on the link
"http://zen-cart.spb.ru/freedownload.php?file=zc-contribution/supertracker.zip"
and I am redirected to the zen cart with error message at the top

File "zc-contribution/supertracker.zip" not found in download directory...