SharedVariantOptionsLocale
List of shared product options 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 SharedVariantOptionsLocale;
SELECT * FROM SharedVariantOptionsLocale WHERE ChannelId = '1' AND LocaleId = 'en'
This table returns shared product options along with their locale-specific overrides including display names and option values.
Columns
| Name | Type | Description |
| SharedOptionId [KEY] | String | The ID of the shared product option. |
| SharedOptionValueLocaleId [KEY] | String | The ID of the localized shared option value. |
| ChannelId [KEY] | String | Storefront channel ID. |
| LocaleId [KEY] | String | Locale in a storefront channel. |
| StoreId | String | The ID of the store. |
| DisplayName | String | The display name of the shared product option. |
| SharedOptionDisplayName | String | The localized display name of the shared option for the specified channel and locale. |
| SharedOptionValueLocaleLabel | String | The localized label of the shared option value. |