EcommerceProductImages

A Product Image represents a specific product image.

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 id for the store.
ProductId [KEY]	String	The ID of the associated product.
Id [KEY]	String	A unique identifier for the product image.
Url	String	The actual promotional code.
VariantIds	String	URL used to redeem the promo code.
Links	String	A list of link types and descriptions for the API schema documents.

Excel Add-In for Mailchimp

EcommerceProductImages

Table Specific Information

Select

Columns