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
- Added attribute selection and labels in
- 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.
- create a file in includes/apps/reporting_tool/admin/reports using the name of the report as the title. Example: my_fancy_report.php
- Refer to other reports for the file layout and copy/paste from a simple example like customer_abandoned_basket.php
- $report_settings array carries the following settings: (Language file constants optional.)
- name = the text name of the report to show at the top of the report.
- version = a version number for the report logic
- controls = an array of report controls (date, startdate, enddate, limit, prodid, etc)
- Some of these have auto-programming on their functionalities, refer to the other reports for examples
- text_columns = the headings for the report columns
- text_columns_dormat = the format of the report columns, refer to other reports for examples
- text_columns_align = left/right/center align of report column data
- chart_settings = array for the chart format. You can see an example in sales_report.php
- total_columns = array of 1=on 0=off for each column, if totals are to be displayed at the bottom
- datasets = array of sql queries to be loaded.
- label will be the label on the report dataset
- query will be the data query … where all the magic happens
- The query columns must line up with the above column settings
- If using special columns like customername, diff_amounts, prodname, mfgname, etc … review other reports for an example
- You can use any of the controls above in 3c in your queries as :control_name
- 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.
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.
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.