Posted in
CMS News
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.
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
As you can see, the Newsletter Subscribers list in Magento has now been updated with the new subscribers.
Click Image to Enlarge
Read more: http://feedproxy.google.com/~r/magento/~3/nMYLtZtO_40/