From the Support Team: Importing Newsletter Subscribers

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 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.

image
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.

image
Click Image to Enlarge

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

image
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.

image
Click Image to Enlarge

As you can see, the Newsletter Subscribers list in Magento has now been updated with the new subscribers.

image
Click Image to Enlarge


RSS: This Entry| All Blog Posts (RSS)