ProductImageLocales
List of product images overrides.
Table Specific Information
Select
The server 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 server.
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. |