SSIS Components for BigCommerce

Build 26.0.9655

ProductImageLocales

List of product images overrides.



Table Specific Information

Select

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

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

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

Update

You can update locale-specific overrides for product images.

UPDATE ProductImageLocales SET LocaleAltText = 'Image description FR', LocaleIsThumbnail = true WHERE ProductId = '111' AND ImageId = '265' AND ChannelId = '1' AND LocaleId = 'fr';

Delete

You can remove locale-specific overrides for product images.

DELETE FROM ProductImageLocales WHERE ProductId = '111' AND ImageId = '265' AND ChannelId = '1' AND LocaleId = 'fr';

Columns

Name Type ReadOnly Description
ImageId [KEY] String False

The ID of the product image.

StoreId String False

The ID of the object.

ProductId String False

The ID of the product.

LocaleAltText String False

The image description.

LocaleIsThumbnail Bool False

Indicates whether the image is a thumbnail.

LocaleSortOrder Long False

The order number of the image.

LocaleAddedToProduct Bool False

Indicates whether the image is added to the product and displayed on storefront.

ChannelId String False

Storefront channel ID.

LocaleId String False

Locale in a storefront channel.

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