JDBC Driver for WooCommerce

Build 24.0.9062

SalesReport

Executes a Sales report.

Table Specific Information

Select

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: Period, StartDate, EndDate. All other columns are processed client side.

SELECT * FROM SalesReport WHERE Period = 'week' AND StartDate = '01/01/2019'

Columns

Name Type References Description
TotalSales String Gross sales in the period.
NetSales String Net sales in the period.
AverageSales String Average net daily sales.
TotalOrders Integer Total of orders placed.
TotalItems Integer Total of items purchased.
TotalTax String Total charged for taxes.
TotalShipping String Total charged for shipping.
TotalRefunds Integer Total of refunded orders.
TotalDiscount Integer Total of coupons used.
TotalsGroupedBy String Group type.
TotalsAggregate String Totals.
Period String Report period. Defaults to week. Options: week, month, last_month and year.
StartDate Date Return sales for a specific start date, the date need to be in the YYYY-MM-DD format.
EndDate Date Return sales for a specific end date, the date need to be in the YYYY-MM-DD format.

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