Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Collecting clients email database?


trembita

Recommended Posts

You can use phpMyAdmin and run a query directly. You can then save the results as a CSV and import it into excel or whatever

 

This query will give you all the details you want sorted by signup date.

 

SELECT c.customers_firstname, c.customers_lastname, c.customers_telephone, a.entry_street_address, a.entry_suburb, a.entry_city, a.entry_state, a.entry_postcode, c.customers_email_address, i.customers_info_date_account_created

FROM customers AS c LEFT JOIN customers_info AS i ON (c.customers_id =

i.customers_info_id) LEFT JOIN address_book AS a ON (c.customers_id =

a.customers_id) ORDER BY i.customers_info_date_account_created

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...