List all the corresponding option value objects to the product option, including values not assigned to any variants.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.

• ProductId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM ProductOptionValues WHERE ProductId = 'Val1'

Insert

The following columns can be used to create a new record:

ProductId, ProductOptionId, Name, LinkedMetafieldValue

The following pseudo-column can be used to create a new record:

VariantStrategy

Update

The following columns can be updated:

ProductId, ProductOptionId, Name, LinkedMetafieldValue

Delete

You can delete entries by specifying the following columns:

ProductId, ProductOptionId, Id

Columns

Name	Type	ReadOnly	References	Description
ProductId	String	False		A globally-unique ID.
ProductOptionId	String	False		A globally-unique ID.
ProductOptionName	String	True		The product option's name.
Id [KEY]	String	True		A globally-unique ID.
Name	String	False		Value associated with an option.
LinkedMetafieldValue	String	False		Metafield value associated with an option.
HasVariants	Bool	True		Whether the product option value has any linked variants.
SwatchColor	String	True		The swatch associated with the product option value. The color representation of the swatch.
SwatchImageId	String	True		The swatch associated with the product option value. An image representation of the swatch. A globally-unique ID.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.

Name	Type	Description
VariantStrategy	String	The strategy defines which behavior is observed regarding variants. The strategy 'LEAVE_AS_IS' is used by default - variants are not created nor deleted. If set to 'MANAGE', variants are created and deleted according to the option values to add and to delete. The allowed values are LEAVE_AS_IS, MANAGE.