JDBC Driver for WooCommerce

Build 24.0.9062

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 References Description
Title String Product title.
ProductId Long 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062