CatalogCategoryItems
Returns all catalog items that belong to a specific category, identified by category Id.
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: =
- CategoryId supports the following operator: =
SELECT * FROM CatalogCategoryItems Where Id = 'catalogcategoryId' SELECT * FROM CatalogCategoryItems Where CategoryId = 'categoryId'
Insert
Klaviyo allows associating a catalog item with a catalog category. To do this, execute an INSERT statement that defines both the Id and CategoryId.
Note: This INSERT statement does not create a new catalog item. It simply associates the specified Id with the specified CategoryId.
INSERT INTO CatalogCategoryItems (Id, CategoryId) Values ('catalogItemId', 'CatalogCategoryId')
Columns
| Name | Type | ReadOnly | References | Description | |
| Id [KEY] | String | False |
The unique identifier for the catalog item. This compound Id uses the format {integration}::: {catalog}::: {external_Id}. Currently, only the $custom integration type and the $default catalog are supported. | ||
| CategoryId [KEY] | String | False |
The unique identifier of the catalog category that the item belongs to. Use this value to retrieve all items within a specific category. | ||
| Created | Datetime | False |
The date and time when the catalog item was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | ||
| Description | String | False |
A detailed description of the catalog item, typically including product information or key attributes. | ||
| ExternalId | String | False |
The identifier of the catalog item in an external system, used to synchronize data between Klaviyo and external product sources. | ||
| ImageFullUrl | String | False |
The URL of the primary full-size image associated with the catalog item. | ||
| ImageThumbnailUrl | String | False |
The URL of the thumbnail image representing the catalog item. | ||
| Images | String | False |
A comma-separated list of URLs pointing to all image assets associated with the catalog item. | ||
| Price | Double | False |
Specifies the price of the catalog item as displayed in Klaviyo emails or campaigns. For most price updates, update the price on any related variants using the Update Catalog Variant endpoint. | ||
| Published | Bool | False |
Indicates whether the catalog item is currently published and visible in the catalog. | ||
| Title | String | False |
The title or display name of the catalog item as it appears in the catalog or storefront. | ||
| Updated | Datetime | False |
The date and time when the catalog item was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | ||
| Url | String | False |
The URL directing to the catalog item's page on the organization's website. |