RemoveVariantOptionsLocaleField
Removes locale override fields for a product variant option.
Stored Procedure Specific Information
You can remove locale override fields for a product variant option. Each option type has specific field values that can be removed.
For example:
EXECUTE RemoveVariantOptionsLocaleField ProductId = '80', ProductOptionId = '101', ChannelId = '1', LocaleId = 'en', DropdownFieldsToRemove = '"DROPDOWN_PRODUCT_OPTION_DISPLAY_NAME_FIELD"', dropdownIds='"bc/store/productOptionValue/125", "bc/store/productOptionValue/126"'
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'). |
| DropdownFieldsToRemove | String | False | Fields to remove for dropdown option. Valid values: DROPDOWN_PRODUCT_OPTION_DISPLAY_NAME_FIELD, DROPDOWN_PRODUCT_OPTION_VALUES_FIELD |
| DropdownIds | String | False | Ids to remove for dropdown option. |
| RadioButtonsFieldsToRemove | String | False | Fields to remove for radio buttons option. Valid values: RADIO_BUTTONS_PRODUCT_OPTION_DISPLAY_NAME_FIELD, RADIO_BUTTONS_PRODUCT_OPTION_VALUES_FIELD |
| RadioButtonsIds | String | False | Ids to remove for radio buttons option. |
| RectangleListFieldsToRemove | String | False | Fields to remove for rectangle list option. Valid values: RECTANGLE_LIST_PRODUCT_OPTION_DISPLAY_NAME_FIELD, RECTANGLE_LIST_PRODUCT_OPTION_VALUES_FIELD |
| RectangleListIds | String | False | Ids to remove for rectangle list option. |
| SwatchFieldsToRemove | String | False | Fields to remove for swatch option. Valid values: SWATCH_PRODUCT_OPTION_DISPLAY_NAME_FIELD, SWATCH_PRODUCT_OPTION_VALUES_FIELD |
| SwatchIds | String | False | Ids to remove 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. |