ADO.NET Provider for BigCommerce

Build 26.0.9655

ProductModifierOptionsLocales

List of product modifiers with locale overrides.



Table Specific Information

Select

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

  • ProductId supports the = comparisons. Required filter
  • ChannelId supports the = comparison. Required filter.
  • LocaleId supports the = comparison. Required filter.

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

For example, the following queries are processed server-side: 

SELECT * FROM ProductModifierOptionsLocales;
SELECT * FROM ProductModifierOptionsLocales WHERE ProductId = '80' AND ChannelId = '1' AND LocaleId = 'en';
SELECT * FROM ProductModifierOptionsLocales WHERE ChannelId = '1' AND LocaleId = 'fr';

Update

You can set locale-specific information for product modifiers. Each modifier type (checkbox, textField, dropdown, radioButtons, rectangleList, swatch, pickList, etc.) has specific columns for display name, default value, and values. You must specify the ModifierId, ProductId, ChannelId, and LocaleId in the WHERE clause. For example: 

UPDATE ProductModifierOptionsLocales SET RectangleListLocaleDisplayName = 'Theme de vacances', RectangleListLocaleValues = '[{"valueId": "bc/store/productModifierValue/113", "label": "Anniversaire"}, {"valueId": "bc/store/productModifierValue/114", "label": "Noel"}]' WHERE ModifierId = '121' AND ProductId = '111' AND ChannelId = '2' AND LocaleId = 'en';

This table returns product modifiers with locale-specific overrides including display names, field values, default values, and option values for various modifier types.

Columns

Name Type ReadOnly Description
ModifierId [KEY] String False

The ID of the modifier.

ProductId [KEY] String False

The ID of the product.

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.

TypeName String False

The type of the modifier (e.g., CheckboxProductModifier, SwatchProductModifier).

DisplayName String False

The display name of the modifier.

IsRequired Bool False

Whether the modifier is required.

IsShared Bool False

Whether the modifier is shared across products.

CheckboxCheckedByDefault Bool False

For checkbox modifiers, whether it is checked by default.

CheckboxFieldValue String False

The field value for checkbox modifier.

CheckboxLocaleDisplayName String False

The localized display name for checkbox modifier.

CheckboxLocaleFieldValue String False

The localized field value for checkbox modifier.

DateFieldLocaleDisplayName String False

The localized display name for date field modifier.

FileUploadLocaleDisplayName String False

The localized display name for file upload modifier.

TextFieldDefaultValue String False

The default value for text field modifier.

TextFieldLocaleDisplayName String False

The localized display name for text field modifier.

TextFieldLocaleDefaultValue String False

The localized default value for text field modifier.

MultilineTextDefaultValue String False

The default value for multiline text field modifier.

MultilineTextLocaleDisplayName String False

The localized display name for multiline text field modifier.

MultilineTextLocaleDefaultValue String False

The localized default value for multiline text field modifier.

NumbersOnlyDefaultValue String False

The default value for numbers only text field modifier.

NumbersOnlyLocaleDisplayName String False

The localized display name for numbers only text field modifier.

NumbersOnlyLocaleDefaultValue String False

The localized default value for numbers only text field modifier.

DropdownValues String False

The values for dropdown modifier.

DropdownLocaleDisplayName String False

The localized display name for dropdown modifier.

DropdownLocaleValues String False

The localized values for dropdown modifier.

RadioButtonsValues String False

The values for radio buttons modifier.

RadioButtonsLocaleDisplayName String False

The localized display name for radio buttons modifier.

RadioButtonsLocaleValues String False

The localized values for radio buttons modifier.

RectangleListValues String False

The values for rectangle list modifier.

RectangleListLocaleDisplayName String False

The localized display name for rectangle list modifier.

RectangleListLocaleValues String False

The localized values for rectangle list modifier.

SwatchValues String False

The values for swatch modifier.

SwatchLocaleDisplayName String False

The localized display name for swatch modifier.

SwatchLocaleValues String False

The localized values for swatch modifier.

PickListValues String False

The values for pick list modifier.

PickListLocaleDisplayName String False

The localized display name for pick list modifier.

PickListLocaleValues String False

The localized values for pick list modifier.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655