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.
Important note when importing new email addresses
Currently, the import of new newsletter email addresses triggers the automatic dispatch of confirmation mails. This means that an email will be sent to those contacts who confirmed the newsletter subscription as well as to those contacts who did not confirm the newsletter subscription. This error is known and we will fix it soon. If you want to import newsletter data, we recommend deactivating the two options Newsletter opt-in and Confirmation newsletter opt-in in the Setup » Client » [Select client] » Email » Automatic menu for that time until we fixed this error. |
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.
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. 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:
-
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 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.
2.1.12. Confirmation link
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.