Coupons
Returns all coupon definitions in the account.
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: =
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. |