List of product option values 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:

• 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 add-in.

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