Community Add-Ons

in classfile: language_id in sql missed, fixed.

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

This contrib is just a minor bugfix to sales_report_v1.3 by azer that fixed the missing $report_descs.

I also added my german language file.

Nothing big, i hope it still helps
~ Tzirrit

+ added march update by Charly Wilhelm in the package + translation and Fix for some layout
changed the id in the beginning of php refering to antoher contribution
$Id: stats_sales_report.php,v 1.3 2002/11/27 19:02:22 cwi Exp $
ATTENTION ! - i added the language defines in english for spanish and german, got to be corrected

La traducción al español

add this file to include/languages/french

Replace the two included files and you should be able to select the order stati.

save the old files.
use at your own risk

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
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.2 - Fix for some graph layout issues
v1.1 - Fix to Install file
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:
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

-> Improved navigation
-> 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

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
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.1 - Fix to Install file
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/

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
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

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
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><br>' .
'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a><br>');
to
$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a><br>' .
'<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

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

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/

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

A sales report utility, which includes Daily, Weekly, Monthly and Yearly sales reports. View sales trends by day/week/month.

So far, a very useful sales reporting tool, though there are additional improvements to follow. Future additions will include dynamic graph creation and improved export options.

Installation is a breeze with only one change to an existing OSC file.

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

Screenshot of daily report:

http://www.tibetcollection.com/images/umsatz.gif

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

* Charly Wilhelm
* Greg Williams

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

v.07 - Additions made to language files
v.06 - Moved all the logic into class file sales_report.php in admin/includes/classes/

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

A sales report utility, which includes Daily, Weekly, Monthly and Yearly sales reports. View sales trends by day/week/month.

So far, a very useful sales reporting tool, though there are additional improvements to follow. Future additions will include dynamic graph creation and improved export options.

Installation is a breeze with only one change to an existing OSC file.

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

Screenshot of daily report:

http://www.tibetcollection.com/images/umsatz.gif

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

* Charly Wilhelm
* Greg Williams

In a nutshell, it's a very nice little sales report utility, which includes Daily, Weekly, Monthly and Yearly sales reports.

This is a good start if you're looking for a sales reporting tool, though there remains room for improvement, specifically category/product specific performance analysis.

Includes original Install instructions. Install in a breeze.

Screenshot: http://www.TibetCollection.com/images/umsatz.gif

Moved all the logic into class file sales_report.php in admin/includes/classes/

Thanks for the help goes to Greg Williams!

Another small update, now shows the currency selected in the admin area.

Change the name of the package from umsatz (german) to sales_report.



Thanks to Greg Williams for help and translation.

Greg Williams:
"In a nutshell, it's a very nice little sales report utility, which includes Daily, Weekly, and Monthly sales reports.

In addition to adding translations to the English language file, I made some minor layout changes to the report itself (e.g., alignment of tables; spacers added between monthly, weekly, daily reports; currency formatting for sales data).

This is a good start if you're looking for a sales reporting tool, though there remains room for improvement, specifically category/product specific performance analysis.

Includes original Install instructions. Install in a breeze.

Screenshot: http://www.TibetCollection.com/images/umsatz.gif"

Enjoy

This contribution is a translation to English of Charly Wilhelm's contribution, "Umsatz", located here:

http://www.oscommerce.com/downloads.php/contributions,730/type,5

In a nutshell, it's a very nice little sales report utility, which includes Daily, Weekly, and Monthly sales reports.

In addition to adding translations to the English language file, I made some minor layout changes to the report itself (e.g., alignment of tables; spacers added between monthly, weekly, daily reports; currency formatting for sales data).

This is a good start if you're looking for a sales reporting tool, though there remains room for improvement, specifically category/product specific performance analysis.

Includes original Install instructions. Install in a breeze.

Screenshot: http://www.TibetCollection.com/images/umsatz.gif

Enjoy.

- GDW

First release of a report which shows the conversions (translation of "umsatz" by altavista.com) of the last 3 months, weeks and days.