Forums / General Questions / List of Customers and e-mails

List of Customers and e-mails

Views: 679

Results 1 to 6 of 6
1 Feb 2016, 5:32 PM
#1
sewingzfun avatar

sewingzfun

New Zenner

Join Date:
Mar 2011
Location:
California
Posts:
90
Plugin Contributions:
0

List of Customers and e-mails

Is there a way to print a report listing customer information? I would like to print a word or excel document listing all my customers and their information.

Thanks,
Lynn

2 Feb 2016, 12:25 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: List of Customers and e-mails

You can export your customer, address, tables to csv and then load into excell

Zen-Venom Get Bitten

2 Feb 2016, 12:40 AM
#3
sewingzfun avatar

sewingzfun

New Zenner

Join Date:
Mar 2011
Location:
California
Posts:
90
Plugin Contributions:
0

Re: List of Customers and e-mails

kobra:

You can export your customer, address, tables to csv and then load into excell

Thank you for the reply. I'm really not too bright when it comes to doing this. :dontgetit Would you mind giving me detailed instructions how to export the tables to csv (what is csv?).

I really appreciate the help.
Lynn

2 Feb 2016, 12:29 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: List of Customers and e-mails

Load phpmyadmin
select your database
select export
select export method - custom
Select with the "ctrl" key these tables
address_book
customers
customers_info
Select from the "Format" drop box "CSV"
select "go"

Import this resulting file into excel and arrange the data

Zen-Venom Get Bitten

2 Feb 2016, 2:51 PM
#5
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: List of Customers and e-mails

There's a plugin called email address exporter
Also there is one with more/different information called Export Shipping+Order Information

Haven't used either and don't know if would provide all the desired information, but the first one looks like it could be easily modified to add additional fields (writeup on provided page indicates can be done in three easy steps).

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

2 Feb 2016, 3:49 PM
#6
sewingzfun avatar

sewingzfun

New Zenner

Join Date:
Mar 2011
Location:
California
Posts:
90
Plugin Contributions:
0

Re: List of Customers and e-mails

Yippee! Thank you - thank you:clap:
I will give that a try.
Lynn