CatalogVariants
Returns all product variants by item Id or SKU across the catalog.
Select
The add-in 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 add-in.
- 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. |