EcommerceProducts
A list of an account's ecommerce products.
Table Specific Information
Select
The add-in 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 add-in.
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. |