Overrides for the product in a channel locale.



Table-Specific Information

SELECT

The add-in uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

ChannelId and LocaleId are required filters.

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

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

SELECT * FROM ProductPreOrderSettingsLocales;
SELECT * FROM ProductPreOrderSettingsLocales WHERE ChannelId = '1' AND LocaleId = 'en';

UPDATE

You can set locale-specific pre-order settings for a product. ProductId, ChannelId, and LocaleId must be specified in the WHERE clause. For example:

  UPDATE ProductPreOrderSettingsLocales SET PreOrderSettingsMessage = 'Pre-order available' WHERE ProductId = '111' AND ChannelId = '1' AND LocaleId = 'en';

DELETE

You can remove locale-specific pre-order settings overrides.

DELETE FROM ProductPreOrderSettingsLocales WHERE ProductId = '111' AND ChannelId = '1' AND LocaleId = 'fr';

Columns