how to add and edit reports in zencart

updated 2014-06-21

How To Create Your Own Reports in ZenCart

I have done google searches on how to create my own reports in zencart and searches on how to edit the reports that are there and got no worthwhile information. There is a plugin zencart offers under “Admin Tools”, called “Graphical Sales Report” and another simply called “Sales Report”. They look helpful but are complicated by the inclusion of multi-language support and etc.

If you know php and mysql and can write your own querys, you can take one of the reports you do not use and edit its file (see the 5 file names below) and replace everything between the <!-- body //--> and the <!-- body_eof //--> with your own query(s) and output. . . . Or you can simply insert your query etc. just above <!-- body //-->
in the admin area: Reports:

  Customer Orders-Total
  Customers Referral
  Products Low Stock
  Products Purchased
  Products Viewed

the zencart admin file names all start with stats.

They are:
  stats_customers.php
  stats_customers_referrals.php
  stats_products_lowstock.php
  stats_products_purchased.php
  stats_products_viewed.php

They are all directly under your admin folder.

also see the list (barely) documented at Zencart.com
www.zen-cart.com/wiki/index.php/Administration