Lists possible values for each product option, including those not currently assigned to 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		The globally unique identifier of the product associated with this option value.
ProductOptionId	String	False		The globally unique identifier of the product option to which this value belongs.
ProductOptionName	String	True		The display name of the product option that this value is part of, such as 'Size' or 'Color'.
Id [KEY]	String	True		The globally unique identifier for this specific product option value record.
Name	String	False		The actual value assigned to the option, such as 'Red', 'Large', or 'Cotton'.
LinkedMetafieldValue	String	False		The value of the metafield associated with this option, used to store additional custom data or attributes.
HasVariants	Bool	True		Indicates whether this option value is linked to one or more product variants.
SwatchColor	String	True		The color value used to visually represent this option value as a swatch in the storefront, typically in hexadecimal or RGB format.
SwatchImageId	String	True		The globally unique identifier of the image used as a swatch representation for this option value.

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 Shopify manages product variants when option values are modified. 'LEAVE_AS_IS' prevents automatic variant creation or deletion, while 'MANAGE' synchronizes variants to match added or removed option values. The allowed values are LEAVE_AS_IS, MANAGE.