Send Email to Customers Question

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

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)

Quote:

---

Originally Posted by 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?

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|?

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

Might be easier than rolling your own.

Quote:

---

Originally Posted by Limitless

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.

The mod has many more marketing features than 'just' what you are trying to do.

Perhaps download the mod and look through it for help with your queries?

Quote:

---

Originally Posted by Limitless

The mod has many more marketing features than 'just' what you are trying to do.

Perhaps download the mod and look through it for help with your queries?

---

I am aware of its functionality as ive looked at it before. however I am not interested in these features. I simply want to send an email to a specified group of customers based on a query I insert into query builder. cheers anyway, i just need some help with the table joins

Code:

---


Select
  customers.customers_firstname,
  customers.customers_lastname,
  customers.customers_email_address,
  orders.customers_name,
  orders.date_purchased

From
  customers Inner Join
  orders On orders.customers_id = customers.customers_id
  where date_purchased <= DATE(DATE_SUB(NOW(),INTERVAL 7 DAY))

---

Quote:

---

Originally Posted by Limitless

Code:

---


Select
  customers.customers_firstname,
  customers.customers_lastname,
  customers.customers_email_address,
  orders.customers_name,
  orders.date_purchased

From
  customers Inner Join
  orders On orders.customers_id = customers.customers_id
  where date_purchased <= DATE(DATE_SUB(NOW(),INTERVAL 7 DAY))

---

---

The query I need wants to select customers that haven't made a purchase and group by date based on when they signed up. Basically the two elements I posted earlier in this thread need to be combined with another join statement?