- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-14-2017
07:17 PM
01-14-2017
07:17 PM
Importing email addresses for newsletter
How can I import email addresses of newsletter subscribers that I exported as a cvs file from my store prior to converting it to Magento? I'm using Magento 2.
Labels:
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2017
10:33 AM
01-16-2017
10:33 AM
Re: Importing email addresses for newsletter
Hi @webdizzier,
You won't be able to import that list with Magento out-of-the-box but the database table is pretty simple.
Maybe you can try to subscribe 1 user and then export the values of the tables. Next step is to create a file with the same structure and all your values.
Finally, import the information into the database table.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2017
02:23 PM
01-16-2017
02:23 PM
Re: Importing email addresses for newsletter
Thanks for the tip. Maybe I'll give that I try. Just a little leary of messing with the database. Don't want to screw anything up.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2017
03:53 PM
01-16-2017
03:53 PM
Re: Importing email addresses for newsletter
Isn't too critical. I guess you haven't subscribers right now.
The best idea is to subscribe an account and then compare the values to fill the new lines.
Cheers!