Monthly Sales and Tax Summary Report [support thread]

[lat9]

Well ; let me get a point-release going. Thanks for the update.

Just submitted v2.0.1 to include that missing class file. See https://github.com/lat9/monthly_sales_and_tax for a quick update, too.

[swguy]

Approved; removed v2.0.0.

[Carbonless]

Downloaded the new file... ran the report in Reports>Monthly Sales and it took about 5 minutes to render all of my data from as far back as 2004... is this normal?

[Elemi]

HTTP 500 error => Check your /logs sub-directory (or view using the Display Logs plugin) to find the debug-log that caused that error return.

[28-Dec-2021 11:51:20 Pacific/Auckland] PHP Fatal error: require(): Failed opening required 'includes/classes/MonthlySalesAndTax.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/amoraromatherapy/public_html/admin/stats_monthly_sales.php on line 138

[Elemi]

[28-Dec-2021 11:51:20 Pacific/Auckland] PHP Fatal error: require(): Failed opening required 'includes/classes/MonthlySalesAndTax.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/amoraromatherapy/public_html/admin/stats_monthly_sales.php on line 138

Working now thanks to the missing file. :)

And I really like it! <3 <3

[lat9]

Downloaded the new file... ran the report in Reports>Monthly Sales and it took about 5 minutes to render all of my data from as far back as 2004... is this normal?

It might be. Due to strict MySQL installations having hissy fits about fields missing from the GROUP BY and the erroneous results returned when they were added, I had to pull the MySQL SUM()'s from the queries and do the summing in PHP.

I'll look at the code (again) to see if that can be handled differently.

[persion]

I meet a problem
1054 Unknown column 'sort_order' in 'order clause'
in:
[SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id]
Fatal error: 1054:Unknown column 'sort_order' in 'order clause' :: SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id
Any one can help me?

[lat9]

I meet a problem
1054 Unknown column 'sort_order' in 'order clause'
in:
[SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id]
Fatal error: 1054:Unknown column 'sort_order' in 'order clause' :: SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id
Any one can help me?

That field (orders_status :: sort_order) was added in zc157, which is the only Zen Cart version currently supported by the report. What version of Zen Cart are you using?

[lat9]

Just submitted v2.0.2 for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains the (previously missing) /YOUR_ADMIN/includes/modules/sms/tpl_stats_monthly_sales_taxes.php and modifies its data-gathering so that a report's generation doesn't take 'centuries'!

[WiccanWitch420]

I have zen cart version info:
Zen Cart 1.5.5d
Database Patch Level: 1.5.5
v1.5.5a [2016-05-30 17:05:28] (Version Update 1.5.4->1.5.5a)
v1.5.4 [2015-02-18 04:55:48] (New Installation)
v1.5.4 [2015-02-18 04:55:48] (New Installation)

PHP Version: 5.6.40 (Zend: 2.6.0)
Database: MySQL 5.5.62-cll

And I wanted to know if I can install the newest version of this plug in, or if I need to install the one that is for 1.5.5? Please let me know, thank you.