ProductCategories
Retrieve product categories.
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: Id, Slug, ProductId. All other columns are processed client side.
If the 'ProductId' filter is not specified, the connector 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'
Columns
| Name | Type | References | 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 |
Products.Id | Id of the product. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |