WHAT IT IS FOR
==============
The supertracker contrib is designed to give you more information on which to base marketing decisions for your osCommerce store. I created the supertracker contrib because, although there were some contribs around that provide a more detailed who's online tool, nothing quite gave me the information I was after.
Here is the information that is recorded for each customer arriving at your site:
referring page
referring query (so we can get at keywords used if search engine)
landing page (including query string - important for Pay Per Click campaign assessment)
arrival time
exit time
exit page
IP address
country code / country name
customer's cart contents
Number of clicks on the site (accuracy is not 100% as this is recorded based on session ID)
Categories Viewed
Products 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)
This is a full install package as the existing contribution mysteriously vanished a week or so ago.
Existing users are strongly advised to upgrade their installations - there is a just one file to replace if you are running the previous version.
Legend: 
Download
Report
Traduzione della contrib in lingua italiana
This is just an update to the classes/supertracker.php to use the value 'rep' rather than agent as it was conflicting with the variable used for saving the browser agent.
this is the full package again.
This install includes built on Supertracker v3.2b Mr Absinthe update of 21 Mar 2006. This is a full package, installation instructions for the AGENT feature are included in the package.
In this agent tracker version I added a feature to allow the tracking of an agent via the landing page get variable 'agent'. This means if you have sales reps who are selling for you and you need to track sales by agents, you can use this feature.
Then, the supertracker will add this agent flag to the database entry and you are able report by agent.
Updates were made to the reporting to allow any referrer report to also be reported on by Agent.
Additional updates included for the Last 10 Visitors report are:
- Agent ID to detail view
- a filter option for landing page,
- an exclude GoogleBot option. (In enabled the skip tracking of bots option in the classes/supertracker.php but this didnt completely work).
- Order ID is added to the Last 10 Visitors report, with a link directly to view that order.
Found an SQL Injection risk with Supertracker, to see if you are at risk, pull up a product page:
/index/product_info.php/ ... some_product_name
Now insert a some roque characters into the product name. ie.
som'e"produc(t<)name
Hit return, if you see a SQL error message, then your site can be hacked from here.
Attached is my copy of the general.php and supertracker.php. I've added clean_url function to general and use it to clean all POST data in Supertracker.php. This should solve most risks, but you may want to further define 'allowed' characters for each field. I also use a deep_clean function added in general to clean any input form fields.
Based on version from 13 Jan 2006
The below Monika's keyword filtering is included, added few defines to language files to make it multilingual.
- corrected few texts for defines
- changed overlapping coding in headings for TABLE_TEXT_KEY_PHRASE causing the text not being displayed
- amended use of class in tables to correspond with install
- added table heading for Countries Stats
- dropped espanol language folder as it was in English anyway
This is a full install package.
A quick hack for those that find the keywords search confusing as the database grows. I caught myself emptying the supertracker table so I could see the latest/new search strings - not the best idea!
With this hack you have the added option of seeing only keywords from the
- last 24h
- last 72h
- last week
- last month (30d)
- changed hard coded englsih by define in the language file
- cosmetic changes for strong caracteres
- few langauge correction
- commented the support links to gain palce in the admin webpage
-> the several languages need to finished to translate
support http://forums.oscommerce.com/index.php?showtopic=166141
Development Thread href="http://forums.oscommerce.com/index.php?showtopic=166839
WHAT IT IS FOR
==============
The supertracker contrib is designed to give you more information on which to base marketing decisions for your osCommerce store. I created the supertracker contrib because, although there were some contribs around that provide a more detailed who's online tool, nothing quite gave me the information I was after.
Here is the information that is recorded for each customer arriving at your site:
referring page
referring query (so we can get at keywords used if search engine)
landing page (including query string - important for Pay Per Click campaign assessment)
arrival time
exit time
exit page
IP address
country code / country name
customer's cart contents
Number of clicks on the site (accuracy is not 100% as this is recorded based on session ID)
Categories Viewed
Products 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)
This is a full install package as the existing contribution mysteriously vanished a week or so ago.
Existing users are strongly advised to upgrade their installations - there is a just one file to replace if you are running the previous version.
Add file to this package