Excel Add-In for WooCommerce

Build 23.0.8839


Execute a totals report.

Table Specific Information


WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns support only the = comparison, unless stated otherwise. The available columns for this table are: ReportType, StartDate, EndDate. All other columns are processed client side.

SELECT * FROM TotalsReport WHERE ReportType = 'reviews' AND StartDate = '01/01/2019'


Name Type Description
Slug String An alphanumeric identifier for the resource.
Name String Review type name.
Total String Amount of reviews.
ReportType String Type of the report. Must be one of: reviews, products, orders, customers, coupons.
StartDate Date Return the report for a specific start date.
EndDate Date Return the report for a specific end date.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839