ProductOptions
A list of product options. The limit is specified by Shop.resourceLimits.maxProductOptions.
View-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the ProductId column. The driver processes other filters client-side within the driver.
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.
For example, the following queries are processed server side:
SELECT * FROM ProductOptions WHERE ProductId = 'gid://shopify/Product/1234567890123'
SELECT * FROM ProductOptions WHERE ProductId IN ('gid://shopify/Product/1234567890123', 'gid://shopify/Product/1234567890124')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique identifier. | |
| ProductId | String |
Products.Id | A globally-unique identifier. |
| Name | String | The product option's name. | |
| Position | Int | The product option's position. | |
| Values | String | The corresponding value to the product option name. |