Coupons
Returns all coupon definitions in the account.
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: =
For example, the following queries are processed server-side:
SELECT * FROM Coupons WHERE Id = 'coupon-id'
Insert
You can create a new coupon by using an INSERT statement.
INSERT INTO Coupons (ExternalId, Description)
VALUES ('coupon-external-id', 'a new discount coupon')
Update
You can update a coupon by specifying the Id of the record and setting the Description field.
UPDATE Coupons
SET Description = 'a new discount coupon for 10% Off'
WHERE Id = 'coupon-id'
Delete
You can delete a coupon by specifying the Id of the record you want to remove.
DELETE FROM Coupons
WHERE Id = 'coupon-id'
Columns
| Name | Type | ReadOnly | References | Description | |
| Id [KEY] | String | True |
The unique identifier for the coupon within Klaviyo. This internal Id is equivalent to the external Id stored in a connected integration. | ||
| Description | String | False |
A descriptive summary of the coupon, typically outlining its purpose, discount type, or usage conditions. | ||
| ExternalId | String | False |
The identifier of the coupon in an external system, such as Shopify or Magento. This value is used to synchronize coupon data between Klaviyo and the external platform. |