Clear old contacts

[renier8]

Hi.

Is there a way that I can isolate and remove all customers that have not purchased in the last three years?

 

Thank you

Renier

[idnovate.com]

With this query you can select the customers that have never placed any order:

SELECT *
FROM ps_customer c
WHERE id_customer NOT IN (SELECT id_customer FROM ps_orders)

Then you can filter by date if needed.

[renier8]

Thank you very much😎