Skip to main content

Data & Display

This section includes settings that control the data calculation and rendering in both the table and the chart.

Display amounts with two decimal places​

When enabled, the fields with the Round checkbox checked in the Fields list will be rounded to two decimal places for display. Calculations are done based on the amounts stored in the database without intermediate rounding (except when the intermediate rounding option is enabled and applicable), so selecting this option may introduce small rounding variances.

The totals row is based on the rounded values if this option is enabled.

Time Limit​

Change how long PHP allows the reporting process to run, if supported by your hosting. Useful for allowing data-intense reports to run longer when necessary.

Sort Buffer Size Pro​

Increasing the size of your database server's sort buffer can make the report run faster, and resolve issues where the report cannot run because the buffer is too small.

Attempt to prevent other plugins or code from changing the export query or output Pro​

Enabling this option removes all hooked functions from the following hooks before running the report, to avoid conflicts with other plugins or code that could impact report accuracy. However, often these functions are hooked for a reason, and unhooking them could also impact accuracy, so be sure to verify the accuracy and completeness of the export output when using this option.

  • woocommerce_reports_get_order_report_data_args
  • woocommerce_reports_order_statuses
  • woocommerce_reports_get_order_report_query
  • woocommerce_reports_get_order_report_data

Remove HTML tags in the content of non-built-in fields Pro​

Strips HTML tags from meta fields, Group By fields, etc. (Doesn't apply to add-on fields.)

Disable WordPress object caching Pro​

Enable this option if you are encountering memory limit errors while running reports.

Use WordPress date formatting functionality for dynamic date values Pro​

If the dynamic date feature is not producing output in the language that your field values are using, and your WordPress language is set to that language, try enabling this option.

Intermediate rounding​

Enabling this option will round certain order line item amounts to two decimal places before they are added to the total amount on any given row.

This only applies to the following built-in fields:

  • Gross Sales
  • Gross Sales (After Discounts)
  • Total Discount Amount
  • Taxes
  • Taxes - [tax name]
  • Total Sales Including Tax
  • Gross Amount Refunded (Excl. Tax)
  • Gross Amount Refunded (Incl. Tax)
  • Tax Refunded

Some of these fields are derived from other fields by addition or subtraction; for those fields, the rounding occurs before addition or subtraction.

Enable debug mode​

Enabling this option will output the report query SQL when the report is run, along with enabling other debugging functionality, to assist in technical troubleshooting. This setting can break certain report output formats, such as XLSX.