Zipur Reporting Tool

(2 customer reviews)

CAD$39.00

All addon licenses are for 1 year, unless otherwise stated. After license expiry the addon will still work, you will just need to renew to get future updates.
SKU: PHOENIX-ZRT Category: Tags: ,

Add-on Name: Zipur Reporting Tool
Version: 1.7.4
Updated: 12/31/2022
Supports CE Phoenix: 1.0.7.5 – 1.0.8.19
PHP Versions Supported: 7.x, 8.0

Description of Add-on

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…

Screenshot(s)

Change Log

  • 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

Download(s)

Install Instructions:

  • 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 customername, 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.

License Details

Expiration Support Lasts for 1 year. You can use this addon for ever but will need a valid license if you need an upgrade.
Limit Limited in the number of domains activated. Up to 1 domain allowed.

2 reviews for Zipur Reporting Tool

  1. René (verified owner)

    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.

  2. Director, cornwallhoney.com

    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.

Add a review