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.
