SetVariantOptionsLocale
Sets locale override fields for a product variant option. Supports setting displayName and values for option types: Dropdown, RadioButtons, RectangleList, Swatch.
Stored Procedure Specific Information
You can set locale override fields for a product variant option. Each option type (Dropdown, RadioButtons, RectangleList, Swatch) supports setting displayName and values.
The values parameter should be a JSON array of objects with valueId and label properties.
For example:
EXECUTE SetVariantOptionsLocale ProductId = '80', ProductOptionId = '101', ChannelId = '1', LocaleId = 'fr', DropdownDisplayName = 'Taille', DropdownValues = '{"valueId": "bc/store/productOptionValue/501", "label": "Petit"}, {"valueId": "bc/store/productOptionValue/502", "label": "Grand"}'
Input
| Name | Type | Required | Description |
| ProductId | String | True | The ID of the product. |
| ProductOptionId | String | True | The ID of the product option. |
| ChannelId | String | True | The channel ID. |
| LocaleId | String | True | The locale code (e.g., 'en', 'fr'). |
| DropdownDisplayName | String | False | The localized display name for dropdown option. |
| DropdownValues | String | False | The localized values for dropdown option. |
| RadioButtonsDisplayName | String | False | The localized display name for radio buttons option. |
| RadioButtonsValues | String | False | The localized values for radio buttons option. |
| RectangleListDisplayName | String | False | The localized display name for rectangle list option. |
| RectangleListValues | String | False | The localized values for rectangle list option. |
| SwatchDisplayName | String | False | The localized display name for swatch option. |
| SwatchValues | String | False | The localized values for swatch option. |
Result Set Columns
| Name | Type | Description |
| ProductId | String | The ID of the product option. |
| ProductOptionId | String | The ID of the product option. |
| Success | Boolean | Indicates whether or not the operation executed successfully. |
| Details | String | Any extra details on the operation's execution. |