SharedProductModifierOptionsLocale

List of shared product modifiers with locale overrides.

Table Specific Information

Select

The add-in uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

ChannelId supports the = comparison. Required filter.
LocaleId supports the = comparison. Required filter.

The rest of the filter is executed client-side within the add-in.

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 (checkbox, textField, dropdown, etc.) has specific columns for display name and values. You must specify shared , 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.
PickListLocaleDisplayName	String	False	The localized display name for pick list shared modifier.
PickListLocaleValues	String	False	The localized values for pick list shared modifier.

Excel Add-In for BigCommerce

SharedProductModifierOptionsLocale

Table Specific Information

Select

Update

Columns