ProductAttributes
Retrieve product attributes.
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 column for this
table is: ProductId. All other columns are processed client side. If the 'ProductId' filter is not
specified, the component will fetch a list of all the products and perform a request for each product in the list.
SELECT * FROM ProductAttributes WHERE ProductId = 4
Columns
Name | Type | Description |
Id [KEY] | Long | Attribute ID. |
Name | String | Attribute name. |
Slug | String | An alphanumeric identifier for the resource unique to its type. |
Type | String | Type of attribute. By default only select is supported. |
OrderBy | String | Default sort order. Options: menu_order, name, name_num and id. Defaults to menu_order. |
HasArchives | Boolean | Enable/Disable attribute archives. Defaults to false. |
ProductId | Long | Id of the product. |