ProductOptions
Query product options.
View-Specific Information
The cmdlet uses the Shopify API to process search criteria that refer to the ProductId and ProductUpdatedAt columns. The supported SQL operators are '=' for ProductId and '>' and '<' for ProductUpdatedAt.
Select
SELECT * FROM ProductOptions WHERE ProductId = '123'
SELECT * FROM ProductOptions WHERE ProductUpdatedAt > '2018-05-10'
Update
To update a product option, you must include the ProductId. For example:
UPDATE ProductOptions SET Name='test' where ProductId='123'"
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
The id of the product option. | |
ProductId | Long | True |
Products.Id |
The id of the product. |
ProductUpdatedAt | Datetime | True |
The date and time when the product was last modified. | |
Name | String | False |
The name of the product option. | |
Position | Int | True |
The position of the product option. | |
Values | String | True |
The values of the product option. |