List of product custom fields 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 = comparisons.
• ChannelId supports the = comparison.
• LocaleId supports the = comparison.

The rest of the filter is executed client-side within the add-in.

For example, the following queries are processed server-side:

SELECT * FROM ProductCustomFieldsLocales;
SELECT * FROM ProductCustomFieldsLocales WHERE ChannelId = '1' AND LocaleId = 'en';
SELECT * FROM ProductCustomFieldsLocales WHERE ProductId = '111' AND ChannelId = '1' AND LocaleId = 'fr';

Update

You can update locale-specific overrides for product custom fields. ProductId, CustomFieldId, ChannelId and LocaleId must be specify in the WHERE clause. For example:

UPDATE ProductCustomFieldsLocales SET LocaleName = 'Custom Field Name FR', LocaleValue = 'Custom Value FR' WHERE ProductId = '111' AND CustomFieldId = '5' AND ChannelId = '1' AND LocaleId = 'fr';

Columns