EcommerceProducts
A list of an account's ecommerce products.
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 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. |