Hello,
I recently migrated my newsletter inhouse to MailWizz. One issue I ran into is, how do I import unsubscribed email addresses (since I want to be able to track them and not accidentally resubscribe the people)? As of yet, there is no easy way to do this from within MailWizz itself because we cannot modify the 'Status' column while importing. However, there is a workaround.
To import unsubscribed emails, do the following:
a) Create a CSV file with two columns: UNSUBSTATUS and EMAIL
b) Copy / paste the unsubscribed emails into the EMAIL column and the word "removed123" (without quotes) into the UNSUBSTATUS column for each email. Your CSV should look something like this:
c) Import the CSV into your list from MailWizz customer backend Lists -> Lists -> Pick your list -> Tools -> Import - > CSV
d) After import has finished, open phpmyadmin or any other way which you can run sql queries on your database.
e) Run the following query on your database:
*Note: If you modified your table prefix to something other than mw, you will need to adjust the table names accordingly
f) Go back to MailWizz customer backend Lists -> Lists -> Pick your list -> Manager custom fields -> Delete the UNSUBSTATUS custom field
Done!
I recently migrated my newsletter inhouse to MailWizz. One issue I ran into is, how do I import unsubscribed email addresses (since I want to be able to track them and not accidentally resubscribe the people)? As of yet, there is no easy way to do this from within MailWizz itself because we cannot modify the 'Status' column while importing. However, there is a workaround.
To import unsubscribed emails, do the following:
a) Create a CSV file with two columns: UNSUBSTATUS and EMAIL
b) Copy / paste the unsubscribed emails into the EMAIL column and the word "removed123" (without quotes) into the UNSUBSTATUS column for each email. Your CSV should look something like this:
Code:
UNSUBSTATUS EMAIL
removed123 xxx@gmail.com
removed123 xxx@yahoo.comd) After import has finished, open phpmyadmin or any other way which you can run sql queries on your database.
e) Run the following query on your database:
Code:
UPDATE mw_list_subscriber
INNER JOIN mw_list_field_value ON mw_list_subscriber.subscriber_id = mw_list_field_value.subscriber_id
SET mw_list_subscriber.status = 'Unsubscribed'
WHERE mw_list_field_value.value = 'removed123' AND mw_list_subscriber.status = 'Confirmed'*Note: If you modified your table prefix to something other than mw, you will need to adjust the table names accordingly
f) Go back to MailWizz customer backend Lists -> Lists -> Pick your list -> Manager custom fields -> Delete the UNSUBSTATUS custom field
Done!
