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 connector 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. |