Community Add-Ons

I just updated this for use with osCommerce v2.3.x and added some detailed instructions.

All rights to the original creator.

Changes: Remove the $ because some Shops use EUR
Set the Row Order Total as 1

only stats_detailed_monthly_sales.php att.

This is just the "stats_detailed_monthly_sales.php" file. It has the previously modified DD/MM/YYYY date format (as I am Canadian) as well as separating the last line of totals from the overall total sales.

So there is a space, then the heading "TOTAL", then the total sales data so it is easier to read.

Basically added totals to the reports and right aligned some of the columns. Also changed date formatting to d/m/Y because I'm from Australia.

Only the stats_detailed_monthly_sales.php file

I found it a hassle to patch a couple of times, so I've uploaded a pre-patched version that I've bumped to v1.1

The previous patch (fixed for MySQL 4.0.x)

with added support for Tax Subtotals.
(the original version doesn't display properly order totals as it doesn't take into account Taxes)

after installing the original contribution, please replace stats_detailed_monthly_sales.php in /catalog/admin/

add the following line to
/catalog/admin/includes/languages/english/stats_detailed_monthly_sales.php

define('TABLE_HEADING_TOTAL_TAX','Tax');

The original contribution was failing on MySQL 4.0.X. I had to replace the nested queries with joins.

You have to replace only stats_detailed_monthly_sales.php
in /catalog/admin

Nick

The install was missing the line for the english.php file.

in addition there was a duplicate file in the language file. it doesn't need to be uploaded.

*** UPDATED ***
I forgot to include a file.

"Detailed Monthly Sales" is a report that starts by breaking the orders up into months, grouped by years, listed in descending order, as well as listing Net Sales, Shipping/Handling, and Gross Sales amounts. From there it allows you to drill down to all the orders for a specific month, again, listed in descending order, and shows you the Order #, Customer's Name, Order Date, Order Subtotal, Shipping Total, and Order Total. Once at this screen, you can view a printer friendly version of the report or the original invoice (both opened in new windows).