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