CData Python Connector for Shopify

Build 23.0.8839

ProductOptions

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839