EcommerceProductVariants
Contains information about product variants, such as size or color, linked to e-commerce items.
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 | = |
| ProductId | = |
| Id | = |
SELECT * FROM EcommerceProductVariants WHERE StoreId = 'Test_Store123' AND ProductId = '44'
SELECT * FROM EcommerceProductVariants WHERE StoreId = 'Test_Store123' AND ProductId = '44' AND Id = '88'
Note: To retrieve the StoreId, query the EcommerceStores view.
Delete
The following is an example of a DELETE operation:DELETE FROM EcommerceProductVariants WHERE StoreId = 'Test_Store123' AND ProductId = '44' AND Id = '88'
Note: The API throws an error if the product contains only one variant. Therefore, you must delete the product to delete all variants.
Columns
| Name | Type | ReadOnly | References | 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 | Long | 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. |