EcommerceProducts
Lists products available through connected e-commerce integrations, including titles, variants, and pricing.
Table-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| StoreId | = |
| Id | = |
SELECT * FROM EcommerceProducts WHERE StoreId = 'Test_Store123'
SELECT * FROM EcommerceProducts WHERE StoreId = 'Test_Store123' AND Id = '44'
Note: To retrieve the StoreId, query the EcommerceStores view.
Columns
| Name | Type | ReadOnly | References | 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. |