ProductOptionValues
Lists possible values for each product option, including those not currently assigned to variants.
Table-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.
- 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
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| 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. 使用できる値は次のとおりです。LEAVE_AS_IS, MANAGE |