Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Monthly Sales & Tax Report


Recommended Posts

I just posted version 1.5 of the Monthly Sales & Tax Report:



The report works only for snapshots since 2002-04-08. It presents a summary by month of all orders or by status of orders, breaking the gross income into components (products, tax, shipping, low order fees, other) and separates taxed sales from non-taxed sales, for general accounting purposes and to assist in the preparation of sales tax filings.


The data can also be shown in a printer-friendly window, or downloaded as a file of comma separated values. A descriptive Help popup is also provided.


This version corrects the query for the extra class column, and clears the annual footer totals properly. And, for sites whose servers balk at the csv file capability, this is now easily disabled.

Link to comment
Share on other sites

  • 2 weeks later...

Very hand little report but...


Im probably missing something here but when i run report i get the wonderful errors:


Warning: fopen("temp.csv", "w") - Permission denied in /home/stadmin/public_html/test/admin/stats_monthly_sales.php on line 416


Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home/stadmin/public_html/test/admin/stats_monthly_sales.php on line 417


Warning: fclose(): supplied argument is not a valid File-Handle resource in /home/stadmin/public_html/test/admin/stats_monthly_sales.php on line 418


Its probably something really stupid like a php setting but im half asleep and cant remember how to sort it.


anyone know???

Link to comment
Share on other sites

These errors indicate that on our server the script does not have permission to open the file for writing the csv data.


Read step 6 in the install.txt:

If the csv file commands cause fatal errors on your server, the csv capability may be disabled.  Merely edit the file admin/stats_monthly_sales.php and change the value of the variable $csv_enabled at line 43 to false instead of true.  Then, the File choice will not be displayed, and the csv data will not be stored into a file.


If you disable the csv file capability, the report will run fine in all other respects. The next revision of this contribution will use another method to present the csv data, so this error does not occur.

Link to comment
Share on other sites

version 1.4a didnt have this code. Ive loaded 1.5 and fixed the issue. :)


Now i wonder how hard it is going to be to intergrate this mod with the graphs from the sales report mod???


That would be a nice feature :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...