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 provider will fetch a list of all the products and perform a request for each product in the list.
SELECT * FROM ProductAttributes WHERE ProductId = 4
Insert
The following attribute is required when performing an insert: Name.
INSERT INTO ProductAttributes (name,slug) values ('testing1234','pa_black')
Update
The following attribute is required when performing an update: Id.
UPDATE ProductAttributes SET Quantity = 12 WHERE Id = 4
Delete
The following attribute is required when performing delete: Id.
DELETE From ProductAttributes WHERE Id = 4
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Attribute ID. | |
| Name | String | False |
Attribute name. | |
| Slug | String | False |
An alphanumeric identifier for the resource unique to its type. | |
| Position | Integer | True |
Position of the product attribute. | |
| Variation | Boolean | True |
If there's variation of the attribute available. | |
| Visible | Boolean | True |
If the attribute is visible. | |
| OptionsAggregate | String | True |
The array of options for the attribute. | |
| ProductId [KEY] | Long | True |
Products.Id |
Id of the product. |
Pseudo-Columns
Pseudo column 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. |