ProductAttributeTerms
Retrieve the terms for an attribute.
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, AttributeId, ProductId. All other columns are processed client side.
If the 'AttributeId' filter is not specified, the add-in will fetch a list of all the attributes
and perform a request for each attribute in the list.
SELECT * FROM ProductAttributeTerms WHERE AttributeId = 4 SELECT * FROM ProductAttributeTerms WHERE ProductId = 41 AND Slug = 'criteria'ProductAttributeTerms.rsd
Insert
The following attributes are required when performing an insert: Name, AttributeId.
INSERT INTO ProductAttributeTerms (Name, AttributeId) VALUES ('term_name', 2)
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Unique identifier for the resource. | |
| Name | String | False |
Term name. | |
| Slug | String | False |
An alphanumeric identifier for the resource unique to its type. | |
| Description | String | False |
HTML description of the resource. | |
| MenuOrder | Integer | False |
Menu order, used to custom sort the resource. | |
| Count | Integer | True |
Number of published products for the resource. | |
| AttributeId | Long | False |
Id of the attribute. |