EcommerceProducts
Lists products available through connected e-commerce integrations, including titles, variants, and pricing.
Table Specific Information
Select
The connector 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 connector.
The StoreId can be retrieved by selecting the ECommerceStores view.
- StoreId supports the '=' operator.
- Id supports the '=' operator.
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 unique identifier of the store where the product is listed. Each store represents an e-commerce integration connected to the Mailchimp account. |
| Id [KEY] | String | False |
The unique identifier assigned to the product within the store. This value links the product to related images, variants, and orders. |
| Title | String | False |
The display name or title of the product as shown in the store or promotional materials. |
| Handle | String | False |
A unique text string used to identify the product in URLs or API requests, often based on the product title. |
| Url | String | False |
The direct URL to the product page on the store's website. |
| Description | String | False |
A detailed description of the product, including features, specifications, or marketing information. |
| Type | String | False |
The classification or category of the product, such as apparel, electronics, or accessories. |
| Vendor | String | False |
The name of the vendor, brand, or supplier that provides the product. |
| ImageUrl | String | False |
The primary image URL representing the product, typically used as the default thumbnail or featured image. |
| Variants | String | False |
A list of product variants available, such as different sizes, colors, or configurations. Variants can be managed through the EcommerceProductVariants table. |
| PublishedAtForeign | Datetime | False |
The date and time when the product was published or made visible in the store, recorded in ISO 8601 format. |
| CurrencyCode | String | True |
The three-letter International Organization for Standardization (ISO) 4217 code that specifies the currency used for the product's pricing. |
| Images | String | False |
A collection of image URLs associated with the product, showcasing different angles or variations. |