Exporting my customer database to CSV.

[libracorn]

Bumping this... to see if anyone has any ideas on how to pull the addresses for only customers who ordered in the past year.

[krizzle]

This is a great query, but I don't think my client is saavy enough to work in PHPadmin. He's just looking for a way to export current order customer shipping info to an excel file. Will keep looking! Thanks to a wonderful team

[craiglove]

Dr Byte, where do you run this code? we are also wanting to backup customs to CSV File for mail merging letters to customers.

Craig

how's this:

SELECT 
c.customers_firstname as FirstName,
c.customers_lastname as LastName,
c.customers_email_address as Email,
ab.entry_company as Company,
ab.entry_street_address as Address1,
ab.entry_suburb as Address2,
ab.entry_postcode as ZipPostalCode,
ab.entry_city as City,
z.zone_name as State,
ab.entry_state as Province,
co.countries_name as Country,
c.customers_telephone as Telephone
FROM
customers c,
address_book ab
LEFT JOIN zones z ON (ab.entry_zone_id = z.zone_id
and ab.entry_country_id = z.zone_country_id)
left join countries co ON ab.entry_country_id = co.countries_id
WHERE
ab.customers_id=c.customers_id
and ab.address_book_id = c.customers_default_address_id;

[DrByte]

The most common way would be to run it in phpMyAdmin and then export the results.

[charmedbytina2]

Can this be worked in reverse to ADD customers to database?

I've seen the add customers thru admin mod, but that is a one-by-one process and I'd like to be able to add a list of 200 or more in one fell swoop. (Go ahead ~ call me lazy )

Tina

[DrByte]

Can this be worked in reverse to ADD customers to database?

I've seen the add customers thru admin mod, but that is a one-by-one process and I'd like to be able to add a list of 200 or more in one fell swoop. (Go ahead ~ call me lazy )

Tina

Somewhat, yes. But that's an entirely different topic, since it involves inserting records into multiple tables, which need to be kept in sync and need to link each others' record numbers to each other. And, if you don't supply *all* the required data, your customers will have serious problems doing checkout.
See the wiki for database tables which store customer data.

[charmedbytina2]

Thanks for the info - I'm over to wiki now!~

Tina