Phoenix Reporting Tool

CAD$39.00


  • Current Version: 1.7.4
  • Last Updated: 12/31/2022
  • Supports Phoenix: 1.0.7.5 – 1.0.8.19
  • PHP: 7.x, 8.0

  • 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
VERIFIED 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
VERIFIED USER
  • 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.0.8.19
  • 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 >= 1.0.8.6
    • 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
Expiration
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.
Reviews
Phoenix Master Password
Phoenix Master Password
CAD$19.00

Many times we have to check on a customers account why they ...
Version
Updated
1.2.0
10/31/2021
PHP
Phoenix
7.x, 8.0
1.0.7.5 – 1.0.9.1