Send Email to Customers Question

[philip937]

On the send email to customers page, on the drop down you get various options to send bulk emails.

I would like to contact customers that have never comeplted a purchace but not ALL of them. just ones in say the past week.

Is there a way to change what ever query pulls the customers that havent made a purchase to limit them by this sort of period of time? perhaps a good one would be 'customers that havent made a purchase last week', so 7 days from 14 days ago?

Many Thanks,

Phil

[philip937]

I think I have a query that should deal with the dates bit, will this work?

WHERE Date BETWEEN (NOW() - INTERVAL 14 DAY) AND (NOW() - INTERVAL 7 DAY)

[philip937]

I think I have a query that should deal with the dates bit, will this work?

WHERE Date BETWEEN (NOW() - INTERVAL 14 DAY) AND (NOW() - INTERVAL 7 DAY)

So I think I should be able to use this:
SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL

and i need hep merging the two above?? anyone?

[philip937]

im assuming i need to join the customers_info table so I have a date (customers_info_date_account_created) to reference but unsure how to do this|?

[Limitless]

You could utilize the mailbeez addon for this and/or the 'recover cart' plugin.

Might be easier than rolling your own.

[philip937]

You could utilize the mailbeez addon for this and/or the 'recover cart' plugin.

Might be easier than rolling your own.

installing a whoe mod rather compared to adding one query to a built in feature?

my preference is using the send mail page hence why I am trying to establish the correct sql syntax to pull the desired customer info.