EcommerceProductImages

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

Table Specific Information

Select

The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.

The StoreId can be retrieved by selecting the EcommerceStores view and ProductId can be retrieved by selecting the EcommerceProducts table.

StoreId supports the '=' operator.
ProductId supports the '=' operator.
Id supports the '=' operator.

For example:

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';

Columns


Name	Type	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.

Excel Add-In for Mailchimp

EcommerceProductImages

Table Specific Information

Select

Columns