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

Newsletter

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

Table 1. Fields for importing newsletter data
Matching field Explanation

ID

Which column of your CSV file lists the IDs of the email addresses which the newsletters are to be sent to? Choose this column here. This option is useful if you want to update existing newsletter data.
If you want to import new email addresses, leave this field empty. The IDs for the email addresses are automatically assigned when carrying out the import.

Background info: Every new newsletter data record automatically receives an ID, which cannot be changed. The ID is used to uniquely identify the contact. 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 newsletter 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 newsletter will be given the default value.

2.1. Newsletter

2.1.1. ID

Enter the ID of the email address to which the newsletter is sent 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 Setup » CRM » Newsletter » Emails » Expand folder after you have carried out the search ().

2.1.2. ID of the folder

Enter the ID of the folder in which the email address of the newsletter recipient is saved 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 Setup » CRM » Newsletter » Emails in the overview Emails per folder.

2.1.3. Contact ID

Do you want to establish a link to an existing contact when carrying out the import? Enter the ID of the contact in your CSV file.

Default value: No default value

Permitted import values: Numeric (internal ID)

2.1.4. First name

Enter the recipient’s first name in your CSV file.

Default value: No default value

Permitted import values: Text

You can find the result of the import in the back end menu Setup » CRM » Newsletter » Emails » Expand folder. Then click on search () and expand () the data record. The value is saved in the First name field.

2.1.5. Last name

Enter the recipient’s last name in your CSV file.

Default value: No default value

Permitted import values: Text

You can find the result of the import in the back end menu Setup » CRM » Newsletter » Emails » Expand folder. Then click on search () and expand () the data record. The value is saved in the Last name field.

2.1.6. Email

Enter the recipient’s email address in 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 Setup » CRM » Newsletter » Emails » Expand folder. Then click on search () and expand () the data record. The value is saved in the Email field.

2.1.7. Form of address

Enter the recipient’s form of address in your CSV file.

Default value: No default value

Permitted import values: Text

This information might be useful for external newsletter providers, for example.

2.1.8. Birthday

Enter the recipient’s date of birth in your CSV file.

Default value: No default value

Permitted import values: Date

This information might be useful for external newsletter providers, for example.

2.1.9. Template language

Enter the language that is saved for the email template in your CSV file.

The language is set in the Email message tab of the email template.

Default value: No default value

Permitted import values: Alpha-numeric

This information might be useful for external newsletter providers, for example.

2.1.10. Confirmed at

Enter the date when the recipient confirmed the newsletter receipt in your CSV file.

Default value: No default value

Permitted import values: Date

You can find the result of the import in the back end menu Setup » CRM » Newsletter » Emails » Expand folder. Then click on search () and expand () the data record. The value is saved in the Confirmed at field.

2.1.11. IP address

Enter the IP address that the recipient used to confirm the newsletter registration in your CSV file.

Default value: No default value

Permitted import values: Numeric

This information might be useful for external newsletter providers, for example.

What is the confirmation link that the persons who want to register for the newsletter receipt have to click? Enter this confirmation link in your CSV file.

The confirmation link can be inserted in the email template via the template variable $NewsletterConfirmURL.

Default value: No default value

Permitted import values: URL

This information might be useful for external newsletter providers, for example.

To top