Importing Coupons

This topic explains the process of importing coupons in bulk using a CSV file. Bulk importing can speed up the process of creating multiple coupons at once, and is useful when managing large campaigns or sales.

The import feature supports partial coupon setup. After importing, you need to edit each imported coupon in the Offers > Coupons page to complete the configuration.

CSV File Guidelines

When preparing your CSV file for import, ensure that the coupon data format aligns with the column requirements. Different columns have specific data input requirements. Not all fields in the CSV are required, but fabric recommends completing as many fields as possible to minimize the manual work required later.

Column Header	Description
Title	The internal-facing name of the coupon.
Start Date (UTC)	The date and time the coupon becomes active, in UTC format.
End Date (UTC)	The date and time the coupon expires, in UTC format.
Type	The coupon type, whether `SKU Coupon`, `SKU Quantity Coupon`, or `Buy X Get Y Coupon`. For more information, see the coupon types section.
Description	The internal-facing description of the coupon.
Is stackable	The value that indicates whether the coupon can be stacked. `YES` if coupon is stackable; `NO` if it is not. For more information, see the coupon stacking section.
Stacking priority	The value defining coupon stacking order. The lower the number, the higher the priority. For more information, see the coupon stacking section.
Is always applied	The value that indicates whether the coupon is always applied; `YES` if coupon is auto-applied; `NO` if manual entry is required.
Single/Multi-use coupon	The value that defines usage the limit, either `SINGLE-USE` or `MULTI-USE`.
Coupon code	The code a customer must enter at checkout, such as `SAVE10` or `CLEARANCE25`.
Limit use per customer	The maximum number of redemptions per customer.
Limit use site wide	The maximum total number of redemptions for all customers.
Shipment methods IDs	The shipment method IDs eligible for this coupon in a comma-separated format.
Eligible PriceList	The ID of the price list this coupon applies to.
Terms and conditions title	The title of the terms and conditions displayed to the customer.
Terms and conditions description	The body of the terms and conditions displayed to the customer.

Example file

Title	Start Date (UTC)	End Date (UTC)	Type	Description	Is stackable	Stacking priority	Is always applied	Single/Multi-use coupon	Coupon code	Limit use per customer	Limit use site wide	Shipment methods IDs	Eligible PriceList	Terms and conditions title	Terms and conditions description
SPRING25	2025-05-01T00:00:00Z	2025-06-01T00:00:00Z	SKU Coupon	Spring sale on seasonal SKUs	YES	1	NO	MULTI-USE	SPRING25	3	500	101,102	300456	Spring Terms	Valid on select SKUs from the spring collection.
BUY2GET1	2025-05-10T00:00:00Z	2025-07-15T00:00:00Z	Buy X Get Y Coupon	Buy 2, get 1 free promotion	NO	2	YES	SINGLE-USE	BUY2FREE	1	1000	103	300789	Buy More Promo	Buy any 2 eligible items and get a third item free.

Prerequisites

Ensure that you have Admin or Editor privileges for Offers. For more detailed information on these settings, see the Role-Based Access Control section.
Ensure that you have created at least one price list in fabric Offers. For more information, see the Pricing section.
Files must be in CSV format; Offers doesn’t support any other data or file types. Empty rows and columns are ignored.