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:
- ChannelId supports the = comparison. Required filter.
- LocaleId supports the = comparison. Required filter.
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. |