ProductVariantValuesForLocale
List of product option values with locale overrides.
Table Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- ProductId supports the = comparison. 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 connector.
For example, the following queries are processed server-side:
SELECT * FROM ProductVariantValuesForLocale;
SELECT * FROM ProductVariantValuesForLocale WHERE ChannelId = '1' AND LocaleId = 'en'
SELECT * FROM ProductVariantValuesForLocale WHERE ChannelId = '1' AND LocaleId = 'en' and productId = '80';
This table returns shared product options along with their locale-specific overrides including display names and option values.
Columns
| Name | Type | Description |
| OptionId [KEY] | String | The ID of the option. |
| ProductId [KEY] | String | The ID of the product. |
| LocaleValueId [KEY] | String | The ID of the localized option value. |
| StoreId | String | The ID of the store. |
| LocaleDisplayName | String | The localized display name of the option for the specified channel and locale. |
| LocaleValueLabel | String | The localized label of the option value. |
| ChannelId | String | Storefront channel ID. |
| LocaleId | String | Locale in a storefront channel. |