SharedVariantOptionsLocale
List of shared product options with locale overrides.
Table-Specific Information
SELECT
The driver 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 driver.
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. |