Export osCommerce and swisscart® Customer E-Mails

We regularly integrate the CleverReach newsletter system with osCommerce and swisscart® and initially make an import of all existing shop customers who have subscribed to the shop newsletter.

You can use the following SQL statement e.g. in phpMyAdmin to export all customers that have registered after a certain date.

SELECT c.customers_email_address, c.customers_firstname, c.customers_lastname 
FROM customers c, customers_info ci 
WHERE c.customers_id = ci.customers_info_id 
AND c.customers_newsletter = 1 
AND ci.customers_info_date_account_created > '2012-06-27 00:00:00'

This is just a very small blog post, but I’m sure it will help someone save some time in the future.