Excel Add-In for WooCommerce

Build 23.0.8839


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 add-in 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] Long Unique identifier for the resource.
Name String Category name.
Slug String An alphanumeric identifier for the resource unique to its type.
ProductId Long Id of the product.

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