From the Support Team: Importing Newsletter Subscribers

On 11.20.09, In Magento News, by admin

This post is part of a weekly series by the Magento Enterprise Edition subscription support team covering tips, tricks and hints to some of the most common, and uncommon, issues as submitted by support customers.

+++++++

Among the many features that can help you build your brand and increase customer loyalty and draw customers to your site [...]

If you find this interesting or useful please share this content:

+++++++

Among the many features that can help you build your brand and increase customer loyalty and draw customers to your site is sending out newsletters in order to raise awareness of your site’s new products, promotions, etc. Of course Magento has great direct marketing capabilities built right in, and so we often times receive questions about the challenges of importing subscribers from another system into your Magento System. With Magento, this can be done pretty easily with the dataflow feature found in the Admin panel (System -> Import/Export -> Profiles).

First, we need to find out the file format that we are going to use for importing the data. To do this, I will create a profile that will export some customer records from the database by using the export filters in the Profile Wizard tab.

Click Image to Enlarge

Once the file has been successfully exported, the file (as shown below) will contain several columns including the is_subscribed field which is for the newsletter subscription. The value ‘0’ is for unsubscribed, while ‘1’ is for subscribed.

Click Image to Enlarge

Currently, we have two customers who have unsubscribed to our Newsletter.

Click Image to Enlarge

Using the Import Customers profile, we will upload the new file containing the updated list of customers who are currently subscribed to the newsletter.

Click Image to Enlarge