CatalogVariants
Returns all product variants by item Id or SKU across the catalog.
Select
The connector uses the Klaviyo API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.
- Id supports the following operator: IN
- Published supports the following operator: =
- Sku supports the following operator: =
- Title supports the following operator: CONTAINS
For example, the following queries are processed server-side:
SELECT * FROM CatalogVariants WHERE Id IN ('variant-1', 'variant-2', 'variant-3')
SELECT * FROM CatalogVariants WHERE Published = true AND CONTAINS(Title, 'CData')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the catalog variant. This compound Id uses the format {integration}::: {catalog}::: {external_Id}. Currently, only the $custom integration type and the $default catalog are supported. | |
| Created | Datetime | The date and time when the catalog variant was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| Description | String | A detailed description of the catalog variant, typically describing product variations such as size, color, or material. | |
| ExternalId | String | The identifier of the catalog variant in an external system, used to synchronize variant data between Klaviyo and external product sources. | |
| ImageFullUrl | String | The URL of the full-size image representing the catalog variant. | |
| ImageThumbnailUrl | String | The URL of the thumbnail image associated with the catalog variant. | |
| Images | String | A comma-separated list of URLs for all images linked to the catalog variant. | |
| InventoryPolicy | Int | Determines whether the catalog variant appears in product feeds or dynamic recommendation blocks based on stock levels. Supported values include: 1: the variant is hidden if out of stock. 0 or 2: the variant remains visible regardless of inventory quantity. | |
| InventoryQuantity | Int | The current quantity of the catalog variant available in stock. | |
| Price | Double | Specifies the price displayed for the catalog variant when used in Klaviyo emails or product recommendations. | |
| Published | Bool | Indicates whether the catalog variant is published and visible in the account's catalog. | |
| Sku | String | The stock keeping unit (SKU) identifier assigned to the catalog variant. | |
| Title | String | The title or display name of the catalog variant as it appears in the catalog or storefront. | |
| Updated | Datetime | The date and time when the catalog variant was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| Url | String | The URL directing to the catalog variant's page on the organization's website. |