---
title: "Action: Refund coupons"
description: "Imports existing refund coupons with their amount and sale date so they can be redeemed in Sapera."
url: https://support.sapera.io/en/articles/611-action-refund-coupons
collection: "SyncTool"
updated: 2026-09-25
language: en
alternates: [da]
---

# Action: Refund coupons

Imports existing refund coupons with their amount and sale date so they can be redeemed in Sapera.

Imports existing refund coupons with their amount and sale date so they can be redeemed in Sapera.

## How to use the action

1\. Select the action in the **Action** field. 2. Point to your data source – a **file** (CSV or Excel) or a **SQL query**. 3. Map the source columns to Sapera's fields in the column mapping (see _Source fields_ below). 4. Run **Compare** to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run **Update Sapera** to perform the import.

Use the **Allow create** and **Allow update** parameters to control whether new rows are created and whether existing ones are updated.

## How matching and updating works

Each row is matched on the refund coupon's **identifier** (Identifier). The action is used to **load existing refund coupons** with amount and sale date.

-   If the coupon does not exist it is created. Direction: from file/SQL into Sapera.
    

## Key parameters

<table data-id="da83b4ba-34ee-4df4-905c-3391e93d1361" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="5795fc0b-9b56-4051-b32e-54a57c6f7016" style="text-align: left;"><strong>Parameter</strong></p></td><td colspan="1" rowspan="1"><p data-id="45e78940-c7fc-4067-9a1b-5fbf0377c463" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="081ea455-bb42-4a1a-b64c-1f91f1e130ad" style="text-align: left;">AllowCreate</p></td><td colspan="1" rowspan="1"><p data-id="a5f9c971-d8e7-4724-9c4d-2bc5e8a2e047" style="text-align: left;">When enabled, refund coupons that do not exist are registered.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="4700b842-4daf-436c-afdc-ef8b33809b12" style="text-align: left;">AllowUpdate</p></td><td colspan="1" rowspan="1"><p data-id="f4615833-b446-48de-9884-739ad6038516" style="text-align: left;">When enabled, existing refund coupons are updated.</p></td></tr></tbody></table>

## Source fields

<table data-id="551f828e-27fe-42a4-a44c-6ffa507bf116" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="a67e6868-09a3-4893-9015-e809b3dc5a2e" style="text-align: left;"><strong>Field</strong></p></td><td colspan="1" rowspan="1"><p data-id="fb020589-298b-4c5d-8ded-195e7cadb26b" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="137931b1-f2ee-4492-86ad-5f76e6417d5d" style="text-align: left;">Amount</p></td><td colspan="1" rowspan="1"><p data-id="5ad292ea-7d06-4f33-9037-575b1da49ada" style="text-align: left;">The value of the refund coupon.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="134d0ba7-2d61-44e7-ba26-20481d9a3e95" style="text-align: left;">Identifier</p></td><td colspan="1" rowspan="1"><p data-id="48e2293d-94df-44d8-b24d-6993f4463ba0" style="text-align: left;">The numeric refund coupon number (the identifier of the row).</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="be32393a-b789-4ea8-ac48-93441200aa71" style="text-align: left;">SoldAt</p></td><td colspan="1" rowspan="1"><p data-id="d931f741-bf07-4a78-91ad-ca1efa54d794" style="text-align: left;">The date the refund coupon was issued, used as its financial date.</p></td></tr></tbody></table>

* * *

See also the overview [SyncTool – actions](https://support.sapera.io/en/articles/547-synctool-handlinger.md).

* * *

**Want to know more?**

Read more in these related articles:

[

Standard parameters for all actions

The general parameters available on most SyncTool actions: step control, error handling, timeout, etc.

](https://support.sapera.io/en/articles/648.md)
