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. Following columns are supported server side, all other columns are processed client side. If the 'ProductId' filter is not specified, the add-in will retrieve attributes for all products in a single paginated request to the products listing endpoint.
- ProductId supports the '=' operator.
SELECT * FROM ProductAttributes WHERE ProductId = 4
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Attribute ID. | |
| Name | String | Attribute name. | |
| Slug | String | An alphanumeric identifier for the resource unique to its type. | |
| Position | Integer | Position of the product attribute. | |
| Variation | Boolean | If there's variation of the attribute available. | |
| Visible | Boolean | If the attribute is visible. | |
| OptionsAggregate | String | The array of options for the attribute. | |
| ProductId [KEY] | Long |
Products.Id | Id of the product. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |