Phoenix Reporting Tool


  • Current Version: 1.8.0
  • Last Updated: 07/03/2024
  • Supports Phoenix: –
  • PHP: >=7.3, <=8.2

  • License: Annual
  • Requires: No Extras

This admin tool will allow you to run many customizable reports from your store admin. When you purchase a license, you get the following:

  • Updates for 1 year
  • All available reports and any new reports for 1 year from purchase date
  • Support

Once the license expires, the report tools will still work you will just not be able to update to a new version until you renew.

Current report list:

  • Customer Abandoned Basket Report
  • Customer No Orders Report – allowing you to search and remove old customers
  • Customer to Products Detail Report
  • Customer to Product Report
  • Inventory Low Report
  • Payment Method to Sales Report
  • Quantity Detail Report
  • Quantity Report (Product Sales)
  • Sales by Country Report
  • Sales by Currency
  • Sales Report (Gross)
  • Sales Report (Net)
  • Products Viewed Report
  • Order Summary Report

You can also:

  • Print text reports
  • Export to CSV
  • Run Graphical Reports
  • Write your own reports

There will be many more reports coming…

This is a very helpfull reporting tool. I especially use the stock modules to see if stock lasts for the current orders. Preston was very helpfull during the installation process, answers allways came within a day, usually even within a few hours.

Rated by Undisclosed User

Zipur Reporting is an awesome tool – a “must have” for every business. It is easy to configure the bundle of reports included to do so much, a real time saver. We are very pleased.

Rated by Robert Bell
  • 1.8.0 (07/03/2024)
    • Added jquery to addon.
    • Fixed sorting issue when clicking column headers.
    • Added new report control for customers. This allows you to easily add this control to your reports to be specific to a selected customer.
    • Added new report - Action Recorder Report.
    • Added new report - Product Value Sold Detail Report.
    • Added new report - Order Totals Detail - shows order#, customer, date, payment, status, subtotal, shipping, tax, total with column totals at the bottom.
    • Added new report - Product Sold Customer Report - shows product name, model, date sold, quantity sold, customer name, total sold at the bottom.
    • Added new report - Order Detail Report - shows Order#, Customer Name, Shipping Address, Billing Address, Payment Method, Status, Model, Product, Quantity, Amount, Tax, Total.
    • Updated report - Product Quantity Sold Detail Report - now sorts by number sold DESC to also work as a bestsellers report.
    • Added logic to remove html from shipping and payment methods.
    • Updated report - Order Summary Report - cleaned up address columns to hide extra spacing if full address not used.
  • 1.7.5 (04/27/2024)
    • Added support for PHP 8.2
  • 1.7.4 (12/31/2022)
    • Updates to installer to correct errors on later PHP versions
    • Correct calculations in Sales Reports and Quantity Report as Shipping and Selected Order Status was not calculating correctly
  • 1.7.3 (11/23/2022)
    • Product Quantity Sold Report – if choosing a specific product, it was summing the matching orders and not just the matching items
    • Sales By Country Report / Sales By Currency Report – if choosing specific product, it was summing the matching orders and not just the matching items – Also adjusted logic for % to calc from subtotal.
    • Sales Report (NET) – fixed issue with reporting of orders without shipping not totally correctly
    • Sales Report (if you choose some product) shows wrong Average Sale its, show the value of the order where is the product bought
    • Inventory Low report – Increased maximum from 10 to 50
  • 1.7.2 (11/18/2022)
    • Added new logic to some reports to allow for monthly/daily/yearly reporting
  • 1.7.1 (10/31/2022)
    • Fixed any deprecated tep_ function/variable issues for
  • 1.7.0 (07/06/2022)
    • Remove ALL tep_db, tep_draw, tep_ functions where possible – change to use internal functions that support old and new way of functioning using a detect function logic.
  • 1.6.4 (04/18/2022)
    • Update logic to link to admin/catalog.php for product reports if Phoenix version >=
    • Update logic to link to admin/zipur_product_manager.php for product reports if Product Manager is installed.
    • Updated Product Viewed Report to add hyperlinks to admin products page
  • 1.6.3 (04/11/2022)
    • Fix error catch in report logic when some data not available
    • Fix Sales by Country report to allow for Country selection
  • 1.6.2 (03/15/2022)
    • Updated Order reports to allow for guest orders as well as deleted customers orders.
    • Updated Customer Abandoned Basket Report to sort by date descending.
    • Added sort links at the top of each column to sort data by column. If you have custom reports, you will have to add default_sort and default_sort_dir settings in your custom reports.
  • 1.6.1 (01/21/2022)
    • Added further adjustments to Order Summary Report
  • 1.6.0 (01/21/2022)
    • Added Order Summary Report
  • 1.5.0 (08/22/2021)
    • rewritten license manager/updater
    • restructured all code to fit new code format
  • 1.4.0 (08/10/2021)
    • Added order status selection to several reports
    • Fixed % in Sales By Currency Report to be calculated by month rather than by date range
    • Fixed % in Sales By Country Report to be calculated by month rather than by date range
    • Added checkbox functionality to reporting engine to allow for execution of commands based on results.
    • Updated Customer No Orders Ever Report and added checkboxes to allow for deletion of selected customers
    • New report – Products Viewed
  • 1.3.1 (05/26/2021)
    • Added new report – Customer Abandoned Basket
  • 1.3.0 (03/17/2021)
    • Added attribute selection and labels in
      • Product Quantity Sold Detail Report
      • Customer to Product Detail Report
  • 1.2.5 (03/16/2021)
    • Fixed Sales Report order counts
  • 1.2.4 (03/16/2021)
    • Corrected Reports to include variable attributes in totals
  • 1.2.3 (03/15/2021)
    • Fixed logic issues with Product Report Sales not calculating correctly
    • Added support for category reporting up to 3 levels deep
  • 1.2.2 (03/15/2021)
    • Updated some reports to show better data
    • Fixed some language file issues on ajax calls
    • Change date logic to better switch between reports
  • 1.2.0 (03/04/2021)
    • Adjusted code to handle latest Phoenix Core Changes
  • 1.1.1 (12/20/2020)
    • Updated language settings to fix a couple issues.
  • 1.1.0 (12/19/2020)
    • Added language constants for all reports
  • 1.0.17 (12/18/2020)
    • Added Customer No Orders Ever report
    • Fixed some more logic issues
  • 1.0.16 (12/18/2020)
    • fixes to sales reports not calculating shipping correctly
  • 1.0.15 (12/17/2020)
    • add missing comm file to package
  • 1.0.14 (12/12/2020)
    • Fixed several bugs and logic issues.
  • 1.0.0 (08/27/2020)
    • Initial Release
This addon support lasts for 365 days. You can use this addon forever but will need a valid license if you need an upgrade.
  • Purchase and you will receive the zip file containing this add-on and a license code
  • Unzip the file
  • Copy the contents of the zip into the root of your catalog
  • Navigate to your catalog/admin/zipur_reporting_tool.php
  • Enter your license code from your order email receipt
  • Happy Reporting! 😉

How To Write Your Own Reports

No real docs on how to write new reports, but you can use this as a quick guide. Also refer to existing reports in includes/apps/reporting_tool/admin/reports for reference.
  1. create a file in includes/apps/reporting_tool/admin/reports using the name of the report as the title. Example: my_fancy_report.php
  2. Refer to other reports for the file layout and copy/paste from a simple example like customer_abandoned_basket.php
  3. $report_settings array carries the following settings: (Language file constants optional.)
    1. name = the text name of the report to show at the top of the report.
    2. version = a version number for the report logic
    3. controls = an array of report controls (date, startdate, enddate, limit, prodid, etc)
      1. Some of these have auto-programming on their functionalities, refer to the other reports for examples
    4. text_columns = the headings for the report columns
    5. text_columns_dormat = the format of the report columns, refer to other reports for examples
    6. text_columns_align = left/right/center align of report column data
    7. chart_settings = array for the chart format. You can see an example in sales_report.php
    8. total_columns = array of 1=on 0=off for each column, if totals are to be displayed at the bottom
    9. datasets = array of sql queries to be loaded.
      1. label will be the label on the report dataset
      2. query will be the data query … where all the magic happens
        1. The query columns must line up with the above column settings
        2. If using special columns like customer name, diff_amounts, prodname, mfgname, etc … review other reports for an example
        3. You can use any of the controls above in 3c in your queries as :control_name
        4. The query is the most complex part. If you know SQL, you’ll be fine. If you don’t, you’ll likely need some assistance.
Phoenix Admin Access Levels (ver 1.x)
Phoenix Admin Access Levels (ver 1.x)

With this Admin access levels you can setup each admin user ...
>=7.3, <=8.2 –