I have an existing customer base of several hundred people that have purchased products (digital file downloads) from our Ubercart shopping cart. I want to be able to notify these customers about new product releases and updates to existing products. Is there a Drupal module or some other clever way to access all those email addresses I have in Ubercart to do these mailouts at the click of a few buttons? Or are they locked away and can only be accessed one at a time?
Fri, 05/13/2011 - 05:22
Re: Is there a way to access Ubercart customer email addresses t
Have you tried exporting your DB to excel or something similar?
Re: Is there a way to access Ubercart customer email addresses t
You can try using:
http://drupal.org/project/simplenews
Re: Re: Is there a way to access Ubercart customer email address
I think he's asking how to get the emails out of the DB all at once so he doesn't have to click each order and copy the email address out for every single order. I know simplenews doesn't do that and all the emails have to be either manually inserted or the user has to subscribe and put their email address in.
Re: Re: Re: Is there a way to access Ubercart customer email add
Use the sites control panel and access phpMyAdmin for your site. The email address (Drupal version 6) are listed in uc_orders.
From there you can either "Export" the entire table or the column of interest by ruuing a SQL query to only display the primary email. Both can be exported to your desktop as a CSV file, Excel file or other file choices.
Once in Excel the files can be cleaned up and placed into your emailer or choice. On this end use Turbo Mailer which works well for small mailing lists. If for greater needs, then one of the commercial email firms would be an option.