CatalogItems

Returns all catalog items in the account, including product details, pricing, and availability information.

Select

The component 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 component.

Id supports the following operator: =, IN
Published supports the following operator: =

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

SELECT * FROM CatalogItems Where Id = 'catalogcategoryId'
SELECT * FROM CatalogItems Where Published = true

Insert

You can create new catalog items.

Note: Creating a new catalog item does not automatically associate it with a catalog category. To associate an item with a category, insert a record into the CatalogCategoryItems table.

INSERT INTO CatalogItems (ExternalId, Price, Title, Description, URL) VALUES ('catalogitem-externalid', '44', 'Limited Edition 2025 T-Shirt', 'A blue T-Shirt', 'https://cdata.com')

Update

You can update catalog items by specifying the Id of the item and setting the fields to update.

UPDATE CatalogItems 
SET Description = 'Limited Edition 2025 T-Shirt, Low on Stock, Order now' 
WHERE Id = 'lowStockItemId'

Delete

You can delete a catalog item by specifying the Id of the record you want to remove.

DELETE from CatalogCategories Where Id = 'lowStockItemId'

Columns