EcommerceProductVariants
Contains information about product variants, such as size or color, linked to e-commerce items.
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.
- ProductId supports the '=' operator.
- Id supports the '=' operator.
SELECT * FROM EcommerceProductVariants WHERE StoreId = 'Test_Store123' and ProductId = '44' SELECT * FROM EcommerceProductVariants WHERE StoreId = 'Test_Store123' and ProductId = '44' and Id = '88'
Delete
Note : API will throw error if the Product contains only one variant. You will have to delete the product to delete all the variants.
DELETE FROM EcommerceProductVariants WHERE StoreId = 'Test_Store123' and ProductId = '44' and Id = '88'
Columns
| Name | Type | ReadOnly | Description |
| StoreId [KEY] | String | False |
The unique identifier of the store where the product variant is listed. Each store represents an e-commerce integration connected to the Mailchimp account. |
| ProductId [KEY] | String | False |
The unique identifier of the parent product to which this variant belongs. Variants represent specific versions of a single product. |
| Id [KEY] | String | False |
The unique identifier assigned to the product variant within the store system. |
| Title | String | False |
The display name or title of the product variant, often including attributes such as color, size, or material. |
| Url | String | False |
The direct URL to the variant's product page or specific option selection in the store. |
| Sku | String | False |
The Stock Keeping Unit (SKU) used to track and manage the inventory of the product variant. |
| Price | Decimal | False |
The selling price of the product variant, typically displayed in the store's default currency. |
| InventoryQuantity | Integer | False |
The total number of units of this product variant currently in stock. |
| ImageUrl | String | False |
The URL of the image representing this specific product variant, used in listings and marketing content. |
| Backorders | String | False |
The backorder policy for the variant, indicating whether additional units can be ordered when stock runs out. |
| Visibility | String | False |
Defines the visibility status of the variant in the store, such as visible, hidden, or archived. |
| CreatedAt | Datetime | True |
The date and time when the product variant was first created in the store system. |
| UpdatedAt | Datetime | True |
The date and time when the product variant record was last updated. |