Magento 2 Administration Extensions

  1. Home
  2. Docs
  3. Magento 2 Administration Extensions
  4. Magento 2 Import Export Newsletter Subscribers
  5. User Guide

User Guide

1. Overview

Magento 2 Import Export Newsletter Subscribers is an ideal extension for all administrators to import multiple newsletter subscribers to Magento 2 websites via a CSV file. Besides, exporting all newsletter subscribers or export by store ID and customer type into a CSV file also becomes extremely simple and easy; especially admins can save a lot of time and effort.

EXPLORE Magento 2 Import Export Extension to break the default limit!

2. How Does It Work?

2.1. Import Newsletter Subscribers

You go to System ⇒ Data Transfer ⇒ Import by BSS and select Newsletter Subscribers in the drop-down list of Entity Type.


2.1.1. In Import Behavior

  • Import Behavior: There are 3 options for you to select.

+ Add/Update: This option allows administrators to add new newsletter subscribers. In addition, it also updates newsletter subscribers if these subscribers already exist in the database.

+ Replace: The module will delete old newsletter subscribers and then add new ones.

+ Delete: This option allows the system to get newsletter subscribers based on customer_ID in the CSV file, then delete items which are available in the database.

  • Validation Strategy: select one option from the drop-down list to determine how the system operates when there are errors in the import process.

+ Stop on Error: the system stops importing when there are errors.

+ Skip error entries: the system skips errors and continues to import.

  • Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds the maximum number you fill in this field, the system will stop importing.
  • Accept the default value of a comma (,) for the Multiple value separator. A comma is the default separator in a CSV file. If you want to use a different character, please make sure that the data in the CSV file matches the character that you specify.

2.1.2. CSV File Preparation

Before you import newsletter subscribers via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File. Then you open this file and fill in fields:

CSV File

Field Format Meaning
ID Natural numbers ID number of the newsletter subscriber.
email Email Customer email – which is used to subscribe to newsletters.
type String Type of emails: customer or guest.
customer_first_name String The first name of the customer. For guests, enter "---"
customer_last_name String The last name of the customer. For Guests, enter "---"
status_id Natural numbers + Not Activated: Value = 2.
+ Subscribed: Value = 1.
+ Unsubscribed: Value = 3.
+ Unconfirmed: Value = 4.
(If you don’t enter the status or you enter the wrong value, the default value is 1).
change_status_at yyyy/m/d hh:mm:ss The time when customers subscribe to the newsletter.
web_site String Website where customers subscribe to the newsletter.
store String Store where customers subscribe to the newsletter.
store_view_code String Store view where customers subscribe to the newsletter. If you enter the wrong value, it is changed into Default.

2.1.3. In File to Import

After you finish the CSV file, tab Choose File button to select the file to import.

2.1.4. Check Data and Import

After you select the CSV file, you need to click Check Data button to validate data before importing.

  • If your CSV file is free from errors, there is a message to notify validation results and Import button now appears to click.

You click Import button to start importing newsletter subscribers in the CSV file into Magento 2 website. There is also a notification about results of the import process.

  • If your CSV file includes errors, Import button cannot be displayed for you to click and there is a notification about these problems.

2.2. Export Newsletter Subscribers

You go to System Export by BSS and select Newsletter subscribers in the drop-down list of Entity Type.

You choose CSV in the Export File Format field.

In Export By section: you can export all available newsletter subscribers by choosing All from the drop-down list or export them based on store IDs or Subscriber type.

Export Newsletter Subscribers

  • Export by Store ID:

Export by Store ID

When exporting by Store ID, you need to select a store to export from.

  • Export by Subscriber type:

Export by Subscriber type

More Magento 2 Import Export extensions from BSSCommerce are useful for your work:

Was this article helpful to you? Yes No

How can we help?