EcommerceProducts

A list of an account's ecommerce products.

Table Specific Information

Select

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

The StoreId can be retrieved by selecting the ECommerceStores view.

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

For example:

SELECT * FROM EcommerceProducts WHERE StoreId = 'Test_Store123'

SELECT * FROM EcommerceProducts WHERE StoreId = 'Test_Store123' and Id = '44'

Columns


Name	Type	ReadOnly	Description
StoreId [KEY]	String	False	The StoreId for the table.
Id [KEY]	String	False	A unique identifier for the product.
Title	String	False	The title of a product.
Handle	String	False	The handle of a product.
Url	String	False	The URL of a product.
Description	String	False	The description of a product.
Type	String	False	The type of product.
Vendor	String	False	The vendor for a product.
ImageUrl	String	False	The image URL for a product.
Variants	String	False	An array of the product's variants.
PublishedAtForeign	Datetime	False	The date and time when the product was published.

Cmdlets for Mailchimp

EcommerceProducts

Table Specific Information

Select

Columns