Contributions

Sales Report

A sales report utility that includes Daily, Weekly, Monthly and Yearly sales reports, including Total # of Orders, Avg. Order Amount, Total Sales, % Variance from previous hours/days/weeks/months.

Expand All / Collapse All

sales_report_v1.31 minor sql bugfix

4 Jul 2006

in classfile: language_id in sql missed, fixed.

Order Status Display Choice size wars not ok, if you have long titels

sales_report_v1.3 minor bugfix

9 Feb 2006

sales_report_v1.3 by azer.zip

13 Dec 2005

traducción Español

Rafael Expśoito

29 Nov 2004

french translation

erwan

21 Oct 2004

Sales Report

Charly Wilhelm

9 Mar 2003

Sales Report v1.2

Greg Williams

20 Dec 2002

Sales Report v1.1

Greg Williams

13 Dec 2002

Sales Report v1.0

Greg Williams

13 Dec 2002

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
SALES REPORT v1.0
12/13/2002
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Summary:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

A sales report utility that includes Daily, Weekly, Monthly and Yearly sales reports,
including Total # of Orders, Avg. Order Amount, Total Sales, % Variance from previous
hours/days/weeks/months.

Daily/Weekly/Hourly reports also include graphs that track total sales. Daily report
uses a stacked bar graph to include average order amount.

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Recent Improvements:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

v1.0 - Hourly reports, dynamic graphs, improved navigation, minor tweaks
v.8 - Minor fix in Install file
v.7 - Additions made to language files
v.6 - Moved all the logic into class file sales_report.php in admin/includes/classes/

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Installation:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

NEW FILES:
>> copy stats_sales_report.php to admin/
>> copy sales_report.php to admin/includes/classes/
>> copy contents of /jsgraph to NEW folder admin/jsgraph
>> copy stats_sales_report.php to admin/includes/languages/english/
>> copy contents of /images to admin/images

MODIFICATIONS TO EXISTING FILES:

1) CHANGE the following in admin/includes/boxes/reports.php

$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a> ' .
'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a> ' .
'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a> ');
to
$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a> ' .
'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a> ' .
'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a> ' .
'<a href="' . tep_href_link(FILENAME_STATS_SALES_REPORT, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_SALES_REPORT . '</a>');

2) ADD the following line in admin/includes/application_top.php

define('FILENAME_SALES_REPORT', 'stats_sales_report.php');

3) ADD the following line in admin/includes/languages/english.php

define('BOX_REPORTS_SALES_REPORT', 'Sales Report');

VIEW YOUR REPORTS:

Access reports through Admin Control Panel>Reports>Sales Report.

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Known Bugs:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

Some minor layout issues with the graphs:

> data ranges
> spacing across the X-axis

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Recent Improvements:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

v1.0 - Hourly reports, dynamic graphs, improved navigation, minor tweaks
v.8 - Minor fix in Install file
v.7 - Additions made to language files
v.6 - Moved all the logic into class file sales_report.php in admin/includes/classes/

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
To Do:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

-> Improve graphing function (PHP, perhaps?)
-> Improved export options (CSV and Print)
-> User input for date range of reports
-> Additional sales data to include categories/subcategories, specials

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Other Info:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

Screenshot of Daily report:

>> http://www.tibetcollection.com/images/sales_report.gif

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Development Team:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

* Charly Wilhelm
* Greg Williams