ccdl_product_option_value

Selectable values for B2C Commerce product options, keyed by productId, productOptionId, and valueId. Each row is one choice for an option — for example, One Year or Two Year for an Extended Warranty — with its SKU extension.

Default refresh frequency: Daily.

Primary Key: (productId, productOptionId, valueId).

For example, for an "Extended Warranty" product option, product option values can include "One Year", "Two Year", and so on.

Column Reference

Column Name Data Type Description
default Boolean Whether this is the default value
productId Text Product identifier (null if shared)
productOptionId Text Parent option identifier
skuExtension Text SKU extension for this option value
tenantId Text Tenant identifier
value Text Display value
valueId Text Unique value identifier
version Text Schema version identifier