Attributes
Retrieve and modify 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: Id. All other columns are processed client side.
SELECT * FROM Attributes WHERE Id = 4
Insert
The following attribute is required when performing an insert: Name.
INSERT INTO Attributes (Name) VALUES ('attribute_name')
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | False |
Attribute ID. | |
Name | String | False |
Attribute name. | |
Slug | String | False |
An alphanumeric identifier for the resource unique to its type. | |
Type | String | False |
Type of attribute. By default only select is supported. | |
OrderBy | String | False |
Default sort order. Options: menu_order, name, name_num and id. Defaults to menu_order. | |
HasArchives | Boolean | False |
Enable/Disable attribute archives. Defaults to false. |