Excel Add-In for WooCommerce

Build 23.0.8839


Execute a top sellers report.

Table Specific Information


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


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.

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