Coupon codes
This page explains the matching and mapping fields that you can use while importing coupon codes and the corresponding data. This page serves purely as a reference and it assumes that you already have a basic understanding of the import tool.
1. Matching fields
The following field is available for matching coupon codes and the corresponding data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.
Setting | Explanation |
---|---|
Campaign ID |
Which column of your CSV file lists the campaign IDs? Choose this column here. This option is useful if you want to update existing coupon codes or the corresponding data. Background info: Every new campaign automatically receives an ID, which cannot be changed. The ID is used to uniquely identify the campaign. Because the ID is unique, it’s a good way to check whether the imported data record already exists in plentymarkets. |
2. Mapping fields
This chapter explains the fields that are available for mapping coupon codes and the corresponding data. Use these fields to specify which column of your file corresponds to which data field in your system.
Basic procedure:
-
In your CSV file: Enter a valid import value into a column.
-
In plentymarkets: Assign this column to the appropriate mapping field.
-
After the import: Check the result in the back end.
No mapping field? Default value applies!
If you don’t include a certain piece of information in your CSV file, i.e. if you don’t use a certain mapping field, then your coupon will be given the default value. |
2.1. Campaign code
2.1.1. Code
Enter the coupon code into your CSV file.
Default value: No default value
Permitted import values: Alpha-numeric
You can find the result of the import in the back end menu Orders » Coupons » [Open campaign] in the Codes tab.
2.1.2. Campaign ID
What’s the ID of the campaign that should be assigned to the coupon code? Enter the campaign ID in your CSV file.
Default value: No default value
Permitted import values: Numeric (internal ID)
You can find the result of the import in the back end menu Orders » Coupons » in the campaign overview.
2.1.3. Number of redemptions
Enter the number of redemptions into your CSV file. The number refers to how often the coupon has already been redeemed.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu Orders » Coupons » in the campaign overview.
2.1.4. Redeemed amount
Enter the redeemed amount of the coupon into your CSV file. The redeemed amount can only be used for coupons of the type Multipurpose coupon.
During import, not the residual balance of the coupon is imported, but the amount already redeemed (see example below). |
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu Orders » Coupons » [Open campaign] in the *Codes tab.
Example: The coupon has a value of EUR 100.00. The customer redeems EUR 80.00 of it. Thus, the residual balance is EUR 20.00. The value that is imported with this mapping field, is EUR 80.00.
2.1.5. Discount value
Enter the discount value of the coupon into your CSV file.
Default value: No default value
Permitted import values: Numeric
You can find the result of the import in the back end menu Orders » Coupons » in the campaign overview and in the campaign in the Coupon area.