EcommerceProductImages

A Product Image represents a specific product image.

Table Specific Information

Select

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

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.

ODBC Driver for Mailchimp

EcommerceProductImages

Table Specific Information

Select

Columns