ProductOptions
Query product options.
View-Specific Information
The driver 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. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.
Select
SELECT * FROM ProductOptions
SELECT * FROM ProductOptions WHERE ProductId='123'
SELECT * FROM ProductOptions WHERE ProductUpdatedAt > '2018-05-10'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Columns
Name | Type | References | Description |
Id [KEY] | Long | The id of the product option. | |
ProductId | Long |
Products.Id | The id of the product. |
ProductUpdatedAt | Datetime | The date and time when the product was last modified. | |
Name | String | The name of the product option. | |
Position | Integer | The position of the product option. | |
Values | String | The values of the product option. |