EcommerceProductVariants
A list of an ecommerce product's variants.
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 StoreId for the table. |
| ProductId [KEY] | String | False |
The ProductId for the table. |
| Id [KEY] | String | False |
A unique identifier for the product variant. |
| Title | String | False |
The title of a product variant. |
| Url | String | False |
The URL of a product variant. |
| Sku | String | False |
The stock keeping unit (SKU) of a product variant. |
| Price | Decimal | False |
The price of a product variant. |
| InventoryQuantity | Integer | False |
The inventory quantity of a product variant. |
| ImageUrl | String | False |
The image URL for a product variant. |
| Backorders | String | False |
The backorders of a product variant. |
| Visibility | String | False |
The visibility of a product variant. |
| CreatedAt | Datetime | True |
The date and time when the product was created. |
| UpdatedAt | Datetime | True |
The date and time the product was last updated. |