Provides image details for products in connected e-commerce stores, including URLs and dimensions.

Table-Specific Information

Select

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

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.

Insert

The StoreId, ProductId, Id, and Url columns are required for INSERT operations.

INSERT INTO EcommerceProductImages (StoreId, ProductId, Id, Url) VALUES ('STR002', '1233', 'img_001', 'https://example.com/images/product1.jpg')

Update

The StoreId, ProductId, and Id columns are required in the WHERE clause for UPDATE operations. Updatable columns include Id, Url, and VariantIds.

UPDATE EcommerceProductImages SET Url = 'https://example.com/images/product1_v2.jpg' WHERE StoreId = 'STR002' AND ProductId = '1233' AND Id = 'img_001'

Delete

The following is an example of a DELETE operation:

DELETE FROM EcommerceProductImages WHERE StoreId = 'STR002' AND ProductId = '1233' AND Id = 'img_001'

Columns

Name	Type	ReadOnly	References	Description
StoreId [KEY]	String	False		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	False	EcommerceProducts.Id	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	False		The unique identifier assigned to the product image within the store system.
Url	String	False		The direct URL of the product image file, used for display in store listings, campaigns, or product recommendations.
VariantIds	String	False		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	True		A collection of related API references and schema links for navigating between product image resources.