Oscommerce local search mod
Introduction
This module allows you track all of the keywords used to search you website. This can be helpful because it can give you an insight into what your customers actually need.
Installation
Step 1: Import rawseo_keyword_reports.sql into your oscommerce database.
Step 2: Upload everything in the admin directory to your oscommerce admin directory.
Step 3:
open advanced search results.php at around line 50:
if (isset($HTTP_GET_VARS['keywords'])) {
add the following (make sure it is before }):
$keywords = $HTTP_GET_VARS['keywords'];
$keywordQuery = sprintf("INSERT INTO rawseo_keyword_reports (keyword,timestamp) VALUES('%s',now())",mysql_escape_string($keywords));
@mysql_query($keywordQuery);
$keywordQuery = sprintf("INSERT INTO rawseo_keyword_reports (keyword,timestamp) VALUES('%s',now())",mysql_escape_string($keywords));
@mysql_query($keywordQuery);
Download
All files for this module can be download here.
