Lists all product categories configured in the account catalog, including category names, Ids, and metadata.

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
• Name supports the following operator: CONTAINS

For example, the following queries are processed server-side:

SELECT * FROM CatalogCategories Where Id = 'catalogcategoryId'
SELECT * FROM CatalogCategories Where CONTAINS(Name, 'summer')

Insert

Klaviyo allows creating new CatalogCategories.

INSERT INTO CatalogCategories (ExternalId, Name) Values ('summercollection', 'Summer Collection 2025')    

Update

Klaviyo allows Updating CatalogCategories.

UPDATE CatalogCategories SET Name = 'Summer Collection 2025 (Limited Edition)' Where Id = '$custom:::$default:::summercollection'

Delete

A CatalogCategories can be deleted by providing the Id of the record you want to delete

DELETE from CatalogCategories Where Id = '$custom:::$default:::summercollection'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False			The unique identifier for the catalog category. This compound Id uses the format {integration}::: {catalog}::: {external_Id}. Currently, only the $custom integration type and the $default catalog are supported.
ExternalId	String	False			The identifier of the catalog category in an external system, used to link Klaviyo categories with external product data sources.
Name	String	False			The display name of the catalog category as it appears in the connected catalog or storefront.
Updated	Datetime	True			The date and time when the catalog category was last modified, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).