EcommerceProductImages
Provides image details for products in connected e-commerce stores, including URLs and dimensions.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| StoreId | = |
| ProductId | = |
| Id | = |
For example, the following queries are processed server-side:
SELECT * FROM EcommerceProductImages
SELECT * FROM EcommerceProductImages WHERE Id = 'Test_Images'
SELECT * FROM EcommerceProductImages WHERE ProductId = '1233' AND StoreId = 'STR002'
SELECT * FROM EcommerceProductImages WHERE Id = 'Test_Images1' AND ProductId = '1233' AND StoreId = 'STR002'
Note: To retrieve the StoreId, query the EcommerceStores view. To retrieve the ProductId, query the EcommerceProducts table.
Columns
| Name | Type | References | Description |
| StoreId [KEY] | String | The unique identifier of the store where the product image is stored. Each store represents an e-commerce integration connected to the Mailchimp account. | |
| ProductId [KEY] | String | The unique identifier of the product that the image belongs to. This links the image to a specific product in the store catalog. | |
| Id [KEY] | String | The unique identifier assigned to the product image within the store system. | |
| Url | String | The direct URL of the product image file, used for display in store listings, campaigns, or product recommendations. | |
| VariantIds | String | A list of variant identifiers that this image is associated with, allowing specific product variations (such as color or size) to use distinct visuals. | |
| Links | String | A collection of related API references and schema links for navigating between product image resources. |