Deleting customers with no orders for accounts created between a date range…

  • Resolved benyates1

    (@benyates1)


    4 years, 7 months ago

    Hi,

    We’ve had a little issue of our registration form being consistently abused by heavy bot traffic and we have in turn gathered around 8,000 customers of which 3,000 are probably genuine.

    We have a list of potential spam accounts based on email addresses from our transactional mail provider but trying to write a query to match data in our db has been too time consuming.

    I found a SQL query that works to retrieve this information in phpmyadmin at https://www.ads-software.com/support/topic/how-do-i-delete-customers-with-no-orders/.

    That thread has now closed but I’d like to be guided on how I may incorporate a date range so that we can remove customers with no orders if their account was created between two dates.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi @benyates1!

    You can add the following to the query, replacing that with your own dates:

    AND post_date BETWEEN '2020-01-01' AND '2020-04-04';

    Please remember to make a backup of your database as we are not responsible for any data loss.

    Cheers!

Viewing 1 replies (of 1 total)
  • The topic ‘Deleting customers with no orders for accounts created between a date range…’ is closed to new replies.