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. |