SharedProductModifierOptionsLocale
List of shared product modifiers with locale overrides.
Table-Specific Information
SELECT
The component uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
| Column | Supported Operators |
| ChannelId | = |
| LocaleId | = |
ChannelId and LocaleId are required filters.
The rest of the filter is executed client-side within the component.
For example, the following queries are processed server-side:
SELECT * FROM SharedProductModifierOptionsLocale;
SELECT * FROM SharedProductModifierOptionsLocale WHERE ChannelId = '1' AND LocaleId = 'en';
UPDATE
You can set locale-specific information for shared product modifiers. Each modifier type (such as checkbox, textField, and dropdown) has specific columns for display name and values. You must specify SharedProductModifierId, ChannelId, and LocaleId in the WHERE clause. For example:
UPDATE SharedProductModifierOptionsLocale SET RectangleListLocaleDisplayName = 'Option Name Localized', RectangleListLocaleValues = '[{\"valueId\": \"bc/store/sharedProductModifierValue/107\",\"label\": \"grande\"},{ \"valueId\": \"bc/store/sharedProductModifierValue/108\", \"label\": \"petite\" }]' WHERE SharedProductModifierId = '2' AND ChannelId = '1' AND LocaleId = 'en'
This table returns shared product modifiers with locale-specific overrides including display names, field values, and option values for various modifier types.
Columns
| Name | Type | ReadOnly | Description |
| SharedProductModifierId [KEY] | String | False |
The ID of the shared product modifier. |
| ChannelId [KEY] | String | False |
Storefront channel ID. |
| LocaleId [KEY] | String | False |
Locale code in the storefront channel (e.g., en, fr). |
| StoreId | String | False |
The ID of the store. |
| DisplayName | String | False |
The display name of the shared modifier. |
| IsRequired | Bool | False |
Whether the shared modifier is required. |
| CheckboxLocaleDisplayName | String | False |
The localized display name for checkbox shared modifier. |
| CheckboxLocaleFieldValue | String | False |
The localized field value for checkbox shared modifier. |
| DateFieldLocaleDisplayName | String | False |
The localized display name for date field shared modifier. |
| FileUploadLocaleDisplayName | String | False |
The localized display name for file upload shared modifier. |
| TextFieldLocaleDisplayName | String | False |
The localized display name for text field shared modifier. |
| TextFieldLocaleDefaultValue | String | False |
The localized default value for text field shared modifier. |
| MultilineTextLocaleDisplayName | String | False |
The localized display name for multiline text field shared modifier. |
| MultilineTextLocaleDefaultValue | String | False |
The localized default value for multiline text field shared modifier. |
| NumbersOnlyLocaleDisplayName | String | False |
The localized display name for numbers only text field shared modifier. |
| NumbersOnlyLocaleDefaultValue | String | False |
The localized default value for numbers only text field shared modifier. |
| DropdownLocaleDisplayName | String | False |
The localized display name for dropdown shared modifier. |
| DropdownLocaleValues | String | False |
The localized values for dropdown shared modifier. |
| RadioButtonsLocaleDisplayName | String | False |
The localized display name for radio buttons shared modifier. |
| RadioButtonsLocaleValues | String | False |
The localized values for radio buttons shared modifier. |
| RectangleListLocaleDisplayName | String | False |
The localized display name for rectangle list shared modifier. |
| RectangleListLocaleValues | String | False |
The localized values for rectangle list shared modifier. |
| SwatchLocaleDisplayName | String | False |
The localized display name for swatch shared modifier. |
| SwatchLocaleValues | String | False |
The localized values for swatch shared modifier. |