Product Sales Report Pro for WooCommerce Changelog

Note: In addition to the changes listed here, there may be other minor fixes and improvements that are not noted. For more information about this product, visit the Product Sales Report Pro for WooCommerce product page.

Version 2.2.7 May 13th, 2021

  • automatically create line-item refunds when the status of an order is set to Refunded, so this setting and other line-item refund related functionality should reflect both line-item refunds entered manually and generated automatically on order status change (if order filtering conditions are met).

Version 2.2.6 May 4th, 2021

  • Added clarification about WooCommerce behavior regarding line item refunds and Refunded order status: WooCommerce 2.4+ should automatically create line-item refunds when the status of an order is set to Refunded, so this setting and other line-item refund related functionality should reflect both line-item refunds entered manually and generated automatically on order status change (if order filtering conditions are met).

Version 2.2.5, April 30th, 2021

  • Feature: Add a second order field filtering setting
  • Feature (experimental): Add option to disable grouping by product

Version 2.2.4, April 15th, 2021

  • Add option: Advanced > Use WordPress date formatting functionality for dynamic date values (may be helpful if you are filtering date values that are in the same language as your WordPress installation, rather than in English)

Version 2.2.3, April 9th, 2021

  • Fix: Time values displayed in the title and filename merge fields may be incorrect if the order period is not a custom date range
  • Time values displayed in the title and filename merge fields are now both inclusive regardless of the Order Period setting

Version 2.2.2, March 31, 2021

  • Security fix: Report files may be stored in the system's temporary directory when the built-in email functionality is used to send a report; use a directory within the WordPress installation instead for security reasons in shared environments
  • Security fix: Report files may be stored in the system's temporary directory when XLSX formats are generated; use a directory within the WordPress installation instead for security reasons in shared environments (note: this may also have affected the XLS format generation in older versions)
  • Fix: XLSX format generation may result in an empty file in some hosting environments

Version 2.2.1, March 22, 2021

  • Fix: potential PHP error when an XLSX export is triggered

Version 2.2.0, March 22, 2021

  • Replaced PHPExcel with PHP_XLSXWriter to address PHP 8 compatibility issue
  • Removed support for generating XLS format files (existing presets should be automatically updated to use XLSX)
  • Fix: PHP 8 deprecation notice

Version 2.1.34, March 15, 2021

  • Add two additional Group By field options in the Grouping & Sorting tab, allowing a up to three Group By fields to be selected
  • Add order item field filtering options in the Order Filtering tab, allowing up to two order item meta filtering conditions to be specified

Version 2.1.33, February 17, 2021

  • Fix: The totals row values for "Order Item" fields may be incorrectly doubled

Version 2.1.32, February 15, 2021

  • Security fix: Improve browser caching disabling headers

Version 2.1.31 - February 11, 2021

  • Security fix: Send headers to disable browser caching during report viewing/downloading
  • Added addons tab

Version 2.1.30 - February 2, 2021

  • Add hm_psr_row_value filter to allow for additional processing of the values in report rows
  • Security improvements

Version 2.1.29 - January 26, 2021

  • Fix: The Product Menu Order field is not populated for zero-sales products
  • Update the "Current Product Price" field to use the WooCommerce method for retrieving price instead of retrieving from post meta for zero-sales products (this change was already previously made for non-zero-sales products)

Version 2.1.28 - January 25, 2021

  • Show disabled product variations with no sales in the report when "Include products with no sales...", "Include unpublished products", and "Report on each variation separately" are enabled (Note: The "Include unpublished products" setting should have no effect on including/excluding disabled variations from the report if they have sales and the product is published)

Version 2.1.27 - January 22, 2021

  • Add "Product Menu Order" built-in field
  • Fix: "Total" checkboxes in the field list were not automatically appearing when the totals row was enabled
  • Add message about field re-ordering to the Report Fields tab

Version 2.1.26 - November 27, 2020

  • Fix: Prevent problems when loading PHPExcel if PHPExcel is already loaded (for example, when used with Scheduled Email Reports or Frontend Reports with another reporting plugin in the same email or page, in certain cases)
  • Avoid outputting errors during XLS/XLSX format generation to avoid file corruption

Version 2.1.25 - November 20, 2020

  • Add Product Description and Product Description Excerpt fields

Version 2.1.24 - September 30, 2020

  • Security fix: Temporary report files may have been generated in the publicly-accessible wp-content directory (or another directory specified by WP_TEMP_DIR) and/or temporary directories that could be accessible by other web server users. The location would have been determined by the get_temp_dir() function in WordPress. In most cases these temporary files would have been deleted quickly but in some cases, such as when using the Scheduled Email Reports addon plugin or when automatic deletion failed, these temporary files may not have been deleted automatically by the plugins in question. This update changes the plugin's temporary directory to a fixed location below wp-content and uses randomized subdirectories to help prevent unauthorized access on a properly configured web server (an update to Scheduled Email Reports also addresses the deletion issue). Existing temporary report files may remain present on the server after update.

Version 2.1.23 - July 29, 2020

  • Fix: The dynamic date option for custom date ranges in the Order Period setting (Order Filtering tab) was incorrectly overriding the time field (this issue was visible in the report settings)
  • Fix: The dynamic date field in the Only Orders With Field setting (Order Filtering tab) was visible even when the dynamic date feature was not in use

Version 2.1.21 - July 13, 2020

  • Updated Plugin Author
  • UI improvements: new admin area
  • Added license key protection
  • For custom fields added via the hm_psr_addon_fields hook, the field callback now has an additional argument that provides the variation ID for product variations with zero sales (i.e. where $type is 'nil'). See line 636 of hm-product-sales-report-pro.php (comment above the getAddonFields() function).
  • Fix PHP notices on the admin page
  • Fix form fields width on small screens

Version 2.1.20 - July 3, 2020

  • Add option to filter reported products by a product field that matches the current user ID (or meets another comparison such as does not match, etc.)

Version 2.1.19 - June 26, 2020

  • Fix: Grouping & Sorting > Sort By option is not respected in the HTML (enhanced) output format

Version 2.1.18 - June 20, 2020

  • Fix: Certain character(s) may not display correctly in the Variation Attributes field

Version 2.1.17 - June 5, 2020

  • Fix: Line item refunds may be inaccurately deducted when the "Include line-item refunds" setting is enabled and the Group By setting is used
  • Add "Line Item Count" field to report the number of line items reflected by each report row
  • Add additional information/warnings regarding the Group By setting to the admin UI
  • Changed the join type for various joins in the report query to LEFT JOIN

Version 2.1.16 - March 26, 2020

  • Feature: The Only Orders With Field setting now supports automatically updated (dynamic) date and/or time values for filtering
  • Fix: Inconsistency in the reporting query for shipping data (order field filtering); may affect shipping-related information in reports if the "Only Orders With Field" setting is enabled and a numeric value is used for the filtering condition (first value if using BETWEEN) in that setting
  • Only treat customer and order field filtering values in a BETWEEN condition as numeric if both values are numeric

Version 2.1.15 - March 11, 2020

  • Fix CSRF security vulnerability

Version 2.1.14 - February 13, 2020

  • Fix: SQL injection vulnerability in a certain report setting, could be taken advantage of by users with permission to edit report settings
  • Allow the use of fields with names containing spaces and/or dashes in the Group By setting (Grouping & Sorting tab)

Version 2.1.13 - January 22, 2020

  • Added an option to set the database sort buffer size in the Advanced tab; set to 512K by default

Version 2.1.12 - December 17, 2019

  • Fix: The "Only Orders with Field" setting was not showing the "does not exist" filtering condition as selected in the dropdown when that condition had been selected and saved (in a preset or last used settings)
  • Fix: Disable WooCommerce report data caching which may cause inaccuracies in report output in certain instances

Version 2.1.11 - December 13, 2019

  • Not needed on this site

Version 2.1.10 - December 4 2019

  • Fix: line item refunds are not reported if there are no sales (product line item refunds are not reported if there are no product sales; shipping line item refunds are not reported if there are no shipping sales)

Version 2.1.9

  • After saving an existing preset, it no longer needs to be re-selected or updated in Scheduled Email Reports or Frontend Reports

The names of deleted products are now displayed from order line item data

  • Fixed an issue with deactivated or invalid license keys not deactivating

Version 2.1.8

  • Added option to only include orders placed by customer users matching specified user meta filtering criteria

Version 2.1.7

  • Implemented performance improvement for sites with many orders
  • Added an option to help address a certain type of plugin conflict
  • Fixed a bug related to certain fields associated with refunds (e.g. the "Quantity Refunded" field, etc.)

Version 2.1.6

  • Fixed issue related to the "group by" functionality

Version 2.1.5

  • Fixed reporting on products with no matching sales

Version 2.1.4

  • Fixed issue with additional character(s) being added to certain report settings values on preset save

Version 2.1.3

  • CSV format options now allow for no delimiter, no surrounding character, and/or no escape character

Version 2.1.2

  • Added ability to sort by any field in the report
  • Replaced field checkboxes with remove buttons on the Report Fields tab
  • Added CSV format options (delimiting, surrounding, and escape characters)

Version 2.1.1

  • Fixed potential bug when including line-item refunds in the report

Version 2.1.0

  • Added "dynamic date" feature for the order period dates
  • Added option to add a title at the top of the report
  • Added field to set the report filename
  • Added field to set the CSS for HTML reports (depending on user permissions)
  • Added debug option (displays SQL for primary report queries, etc.)
  • Added field for setting the execution time limit (where supported)
  • Added option to disable WordPress object caching during report body generation
  • Changed license from GPLv2+ to GPLv3+

Version 2.0.11

  • Added order date related group by fields
  • Fixed issue with shipping tax in WC 3.0+
  • Added "does not exist" option for order meta filtering

Version 2.0.10

  • Fixed bug affecting certain integration(s) (e.g. Scheduled Email Reports)

Version 2.0.9

  • Fixed bug with saving product category filtering settings in presets
  • Fixed database query that was generating an error in some instances
  • Allowed for no date range override when generating a report programmatically (e.g. using Scheduled Email Reports)

Version 2.0.8

  • Fixed issue with line-item refunds and order status filtering

Version 2.0.7

  • Fixed order field filtering for field names containing spaces
  • Fixed order field filtering and customer user role filtering for line item refunds
  • Fixed potential security issue
  • Updated the plugin updater

Version 2.0.6

  • Critical bugfix: Fixed incorrect date ranges when using the "Last 7 days", "Last 30 days", "Next 7 days", or "Next 30 days" options
  • Added improved preset management interface
  • Added calendar month based order period options
  • Added option to enable or disable totals for certain fields

Version 2.0.5

  • Fixed "Include unpublished products" setting

Version 2.0.4

  • Fixed bugs related to numeric values in order and product field filtering

Version 2.0.3

  • Fixed potential incompatibility with order status plugin(s)

Version 2.0.2

  • Fixed incompatibility with older PHP versions resulting in a fatal error on activation
  • Minor improvements

Version 2.0.1

  • Fixed error when including zero-sales products

Version 2.0.0

  • Added tabs to admin interface
  • Added grouping
  • Added product tag filtering
  • Miscellaneous bug fixes

Note: In addition to the changes listed here, there may be other minor fixes and improvements that are not noted. For more information about this product, visit the Product Sales Report Pro for WooCommerce product page.