Tableau Connector for Mailchimp

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060