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.

For example:

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.

Power BI Connector for Mailchimp

EcommerceProductVariants

Table Specific Information

Select

Delete

Columns