ODBC Driver for BigCommerce

Build 26.0.9655

ProductBasicInformationLocales

Overrides the basic information for the product in a channel locale.



Table Specific Information

Select

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

  • ChannelId supports the = comparison.
  • LocaleId supports the = comparison.

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

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

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

Update

You can set locale-specific basic information for a product including name and description. ProductId, ChannelId and LocaleId are required in WHERE clause to update the record. For example:

UPDATE ProductBasicInformationLocales SET BasicInformationName = 'Updated Product Name', BasicInformationDescription = 'Updated product description' WHERE ProductId = '111' AND ChannelId = '1' AND LocaleId = 'en';

Columns

Name Type ReadOnly Description
ProductId [KEY] String False

The unique identifiers of the products.

ChannelId [KEY] String False

Storefront channel.

LocaleId [KEY] String False

Locale in the channel.

BasicInformationDescription String False

Description for the product in a channel locale.

BasicInformationName String False

Name for the product in a channel locale.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655