Query product options.

View-Specific Information

The connector 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.