Skip to main content
  1. Home
  2. Data
  3. Importing data

Coupon codes

This page explains the matching and mapping fields that you can use while importing coupon codes and campaign 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 campaign data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 1. Matching field for importing coupon codes and campaign data
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 and campaign data.
If you want to import new coupon codes, leave this field empty. The IDs for the campaigns are automatically assigned when carrying out the import.

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 campaign data. Use these fields to specify which column of your file corresponds to which data field in your system.

Basic procedure:

  1. In your CSV file: Enter a valid import value into a column.

  2. In plentymarkets: Assign this column to the appropriate mapping field.

  3. 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.

To top