ODBC Driver for WooCommerce

Build 20.0.7587

TopSellersReports

Execute a top sellers 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: Title, ProductId, Quantity, StartDate, EnDDate. All other columns are processed client side.

SELECT * FROM TopSellersReports WHERE Title = 'criteria'
SELECT * FROM TopSellersReports WHERE ProductId = 4

Columns

Name Type Description
Title String Product title.
ProductId Integer Product ID.
Quantity Integer Total number of purchases.
StartDate Date Return the report for a specific start date.
EndDate Date Return the report for a specific end date.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587