ADO.NET Provider for WooCommerce

Build 20.0.7654


Retrieve product categories.

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: Id, Slug, ProductId. All other columns are processed client side. If the 'ProductId' filter is not specified, the provider will fetch a list of all the products and perform a request for each product in the list.

SELECT * FROM ProductCategories WHERE Id = 4
SELECT * FROM ProductCategories WHERE Slug = 'criteria'


Name Type Description
Id [KEY] Integer Unique identifier for the resource.
Name String Category name.
Slug String An alphanumeric identifier for the resource unique to its type.
ProductId Integer Id of the product.

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