EcommerceProductVariants
A list of an ecommerce product's variants.
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.
- 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. |