How To Export Customer Email Addresses to CSV
How To Export Customer Email Addresses to CSV
It seems like this should be a simple feature, but I can't find it anywhere. Can someone help?
Thanks!
I've labeled this a How To so that someone else can find it when it's answered.
Thanks!
I've labeled this a How To so that someone else can find it when it's answered.
Re: How To Export Customer Email Addresses to CSV
You can export email addresses by going on Admin-->Marketing-->Email Lists-->ManageList Page(Edit List).
hope this helps!
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
__________________
s_ismail
AbleCommerce Customization
Free Plugins and Add-Ons
AbleCommerce Plugins and Add-Ons
Plugables Blog
Re: How To Export Customer Email Addresses to CSV
Yeah, that's what I thought would be the logical move. However, I'm trying to export a list of anyone that has ever made a purchase on my site. Right now I can only see one list which someone before me made called eNewsletter, but it only has 235 emails or 17 pages of emails. Whereas, I can look under sales by customer and there are easily 35 pages of emails. So I'm just confused.
Re: How To Export Customer Email Addresses to CSV
Nevermind, You basically have to go to Admin-->Marketing-->Email Lists-->ManageList Page(Edit List), then make a new list by putting something for name like "all emails" and then click save. In the Manage List page, click "Manage Users" and then click quick search "All" Then you can browse and add all the emails, from there you can export them to CSV. It's still pretty tedious because you have to go through each page like it's 1998.
Last edited by andswan on Thu Jun 16, 2011 11:29 am, edited 1 time in total.
Re: How To Export Customer Email Addresses to CSV
Okay, is there no way to do this faster????
Re: How To Export Customer Email Addresses to CSV
If you have direct access to your SQL database, you could pull out the BillToEmail from ac_Orders to build your master list.
Another alternative is a page I wrote that lets you mass-mail customers who bought a specific product within a specified timeframe. You can find the code in the helpful posts forum:viewtopic.php?f=47&t=15301
That page could probably be easily modified to pull everything if no product SKU is specified - that would accomplish what you need I think.
Another alternative is a page I wrote that lets you mass-mail customers who bought a specific product within a specified timeframe. You can find the code in the helpful posts forum:viewtopic.php?f=47&t=15301
That page could probably be easily modified to pull everything if no product SKU is specified - that would accomplish what you need I think.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com
Re: How To Export Customer Email Addresses to CSV
Thanks Joe, what code would I need to put in to do that? I downloaded your mass email program, and I'm looking at the code right now, but I'm learning how to do this on the spot so any help would be appreciated! You designed our site after all.
Re: How To Export Customer Email Addresses to CSV
It's a simple modification, just one line.
Find this line in the code:
and replace it with this line:
Then save the change.
Now if you want to use that page to email anyone who has bought ANYTHING from your store within a specific time period, just enter a percent-sign (%) as the SKU instead of a specific SKU value.
The percent-sign is like a wildcard (*) symbol in SQL query statements that use a LIKE operator.
You can still use the page for a specific SKU by entering the exact SKU value as before. All we've done here is add support for a wildcard value.
Find this line in the code:
Code: Select all
sql.Append("where i.sku = @sku");
Code: Select all
sql.Append("where i.sku LIKE @sku");
Now if you want to use that page to email anyone who has bought ANYTHING from your store within a specific time period, just enter a percent-sign (%) as the SKU instead of a specific SKU value.
The percent-sign is like a wildcard (*) symbol in SQL query statements that use a LIKE operator.
You can still use the page for a specific SKU by entering the exact SKU value as before. All we've done here is add support for a wildcard value.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com
Re: How To Export Customer Email Addresses to CSV
Ahhh, thank you so much!