Lists all possible option values for a given product option, even if not used by a variant.

Table-Specific Information

Select

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

• 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 of the product.
ProductOptionId	String	False		A globally unique Id of the associated product option.
ProductOptionName	String	True		The name of the product option.
Id [KEY]	String	True		A globally unique Id of the product option value.
Name	String	False		The value associated with the product option.
LinkedMetafieldValue	String	False		The metafield value associated with the product option value.
HasVariants	Bool	True		Indicates whether the product option value has any linked variants.
SwatchColor	String	True		The color swatch associated with the product option value.
SwatchImageId	String	True		The image swatch associated with the product option value. 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	Defines how variants are managed for the option values. LEAVE_AS_IS (default): no variants are created or deleted. MANAGE: variants are created and deleted according to the option values added or removed. The allowed values are LEAVE_AS_IS, MANAGE.