Overrides for the product in a channel locale.



Table Specific Information

Select

The connector 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 connector.

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

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

UPDATE

You can set locale-specific SEO information for a product. ProductId, ChannelId, and LocaleId must specify in WHERE clause. For example:

UPDATE ProductSeoInformationLocales SET SeoInformationPageTitle = 'Titre de la page', SeoInformationMetaDescription = 'Description meta' WHERE ProductId = '111' AND ChannelId = '1' AND LocaleId = 'fr';

Columns