Importing email addresses for newsletter

[webdizzier]

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.

[Damian Culotta]

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.

[webdizzier]

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.

[Damian Culotta]

@webdizzier,

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!