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 HeaderDescription
TitleThe 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.
TypeThe coupon type, whether SKU Coupon, SKU Quantity Coupon, or Buy X Get Y Coupon. For more information, see the coupon types section.
DescriptionThe internal-facing description of the coupon.
Is stackableThe 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 priorityThe value defining coupon stacking order. The lower the number, the higher the priority. For more information, see the coupon stacking section.
Is always appliedThe value that indicates whether the coupon is always applied; YES if coupon is auto-applied; NO if manual entry is required.
Single/Multi-use couponThe value that defines usage the limit, either SINGLE-USE or MULTI-USE.
Coupon codeThe code a customer must enter at checkout, such as SAVE10 or CLEARANCE25.
Limit use per customerThe maximum number of redemptions per customer.
Limit use site wideThe maximum total number of redemptions for all customers.
Shipment methods IDsThe shipment method IDs eligible for this coupon in a comma-separated format.
Eligible PriceListThe ID of the price list this coupon applies to.
Terms and conditions titleThe title of the terms and conditions displayed to the customer.
Terms and conditions descriptionThe body of the terms and conditions displayed to the customer.

​
Example file

TitleStart Date (UTC)End Date (UTC)TypeDescriptionIs stackableStacking priorityIs always appliedSingle/Multi-use couponCoupon codeLimit use per customerLimit use site wideShipment methods IDsEligible PriceListTerms and conditions titleTerms and conditions description
SPRING252025-05-01T00:00:00Z2025-06-01T00:00:00ZSKU CouponSpring sale on seasonal SKUsYES1NOMULTI-USESPRING253500101,102300456Spring TermsValid on select SKUs from the spring collection.
BUY2GET12025-05-10T00:00:00Z2025-07-15T00:00:00ZBuy X Get Y CouponBuy 2, get 1 free promotionNO2YESSINGLE-USEBUY2FREE11000103300789Buy More PromoBuy 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.

​
Importing Coupons

  1. In the left menu, click Offers > Coupons > All Coupons. The Coupons page is displayed.
  2. At the top of the page, click Import Codes. The Import CSV file to add your coupon codes is displayed.
  3. (Optional) To download the template click here. The file is downloaded.
  4. To import a CSV file, do one of the following:
    • Drag and drop the file from your computer into the window.
    • Click Select a File from your computer.
  5. Click Import File. You must edit and finalize each imported coupon individually.
  6. To complete setup, on the Coupons page, click the title of the coupon. The edit page is displayed.
  7. Edit the coupon’s attributes as required. For more information see the Coupons Overview topic.
  8. Click Save.

The CSV file is imported and the coupons are created.

To complete setup, each imported coupon must be edited and finalized individually. For details, see the Editing Imported Coupons section.

​
Editing Imported Coupons

To edit the coupons you imported, do the following:

  1. In the left menu, click Offers > Coupons > All Coupons. The Coupons page is displayed.
  2. Click the title of the coupon you wish to edit. The edit page is displayed.
  3. Edit the coupon’s attributes as required.
  4. Click Save.

The coupon is updated with the settings you provided.

​
Checking the Import Status

To view the status of a CSV file import, do the following:

  1. In the left menu, click Offers > Coupons > All Coupons. The Coupons page is displayed.
  2. At the top of the page, click Import History. The Coupon Import History page is displayed.

A list of all your previous coupon import jobs is displayed. The Status column displays the results, whether Successful, In progress**, or Error.