Monthly Totals [support]

[fozzyo]

I'm the author if a Monthly Totals report, I'm just starting this as a support thread for any questions / suggestions for improvements.

This report shows the total numbers of orders and total value of those orders for each month since installation. These totals include all postage, taxes etc that may have been applied to the order.

It also includes a daily breakdown by month showing total number of orders and total value of orders placed.

Mat

[sensory]

How do I make it show US money $
Thanks

[fozzyo]

This is my first mod I've made public, so slowly getting to grips with the localisation and standards for ZC development. If you look in the file stats_monthy_totals.php line 132 should be:

<td class="dataTableContent" align="right">£<?php echo number_format($results->fields['total'], 2); ?></td>

Change the £ symbol here for a $ sign. The same for lines 160 and 201.

The next revision will use local settings to show the correct currency symbol.

Thanks
Mat

[redheads]

Hi there - thanks for the mod - it looks like just whatt he store owner is looking for when I can get it running... am hoping you can give me some insights on my install.
I just drug the files over, went to the store, and clicked 'monthly totals' per the readme file and get the following error:

Monthly Sales Totals

Month Total Orders
1054 Unknown column 'orders.date_purchased' in 'field list'
in:
[SELECT MONTHNAME(orders.date_purchased) AS month, YEAR(orders.date_purchased) AS year, sum(orders_total.value) AS total, COUNT(*) AS num_orders FROM tatzenorders LEFT JOIN tatzenorders_total ON orders.orders_id = orders_total.orders_id WHERE orders_total.title = 'Total:' GROUP BY YEAR(orders.date_purchased), MONTH(orders.date_purchased)]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

So did I miss something when installing??

It looks like a a possible sql table name error, but I saw that this version is not supposed to have that issue - what shall I check next?

:-)

[fozzyo]

Sorry to hear that, its late here and v tired. I'll come back to this tomorrow morning and see what I can work out for you. :)

Thanks
Mat

[redheads]

Thanks, not a huge rush - looking towards the end of the fiscal year in a few months and feeling glad I stated early - get some rest, and when you get back tell me what else you need from me to troubleshoot :-)

[schoolboy]

Thanks, not a huge rush - looking towards the end of the fiscal year in a few months and feeling glad I stated early - get some rest, and when you get back tell me what else you need from me to troubleshoot :-)

You may care to try Sales Report Mod which is very comprehensive and allows for a lot of custom reporting off the purchase history.

http://www.zen-cart.com/index.php?ma...products_id=83

[JimLink]

Hi there - thanks for the mod - it looks like just whatt he store owner is looking for when I can get it running... am hoping you can give me some insights on my install.
I just drug the files over, went to the store, and clicked 'monthly totals' per the readme file and get the following error:



So did I miss something when installing??

It looks like a a possible sql table name error, but I saw that this version is not supposed to have that issue - what shall I check next?

:-)

Got the exact Same thing.... ??

[fozzyo]

I've just subitted version 1.3 of this mod. This should resolve the issues above with column names. Sorry, my bad!

I've also fixed the currency symbol too - this now uses the localisation settings to display the symbol.

Mat

[redheads]

You may care to try Sales Report Mod

I have that, was trying for a quick monthly-view for some comparison snapshots.