Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    40
    Plugin Contributions
    0

    Default How to quickly get rid of 1000+ old customers from database?

    Is there an sql code or something to allow me to quickly prune the old and no longer relevant customers from my database? I've got several thousand on there, going back to 2010, and what with gdpr, people moving house or changing email, efficiency and general jurisprudence and so forth I could probably do with deleting anyone who hasn't logged into their account in a few years as the data will be out of date anyway.

    I can't believe that i will literally have to manually delete each and every account via the Admin - there must be a database query of some sort that I could apply? One that would delete people with, say, last log in before 2016 or no log in at all (blank entry)?

    Any help appreciated!
    ta
    Andy

    v 1.5.6

  2. #2
    Join Date
    Jul 2011
    Posts
    40
    Plugin Contributions
    0

    Default Re: How to quickly get rid of 1000+ old customers from database?

    Or indeed, based on their last order date...?

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,967
    Plugin Contributions
    109

    Default Re: How to quickly get rid of 1000+ old customers from database?

    You may want to use my Delete Spam Customers mod, which can delete customers according to whatever query you want to build.

    https://www.zen-cart.com/downloads.php?do=file&id=2253
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

 

 

Similar Threads

  1. Replies: 1
    Last Post: 12 May 2013, 03:56 AM
  2. v151 can i salvage very old shipping settings from old database?
    By enddes in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 8 Oct 2012, 08:27 AM
  3. Database - add new customers from old database
    By ljdream00 in forum General Questions
    Replies: 0
    Last Post: 6 Apr 2011, 05:43 AM
  4. How to Get Rid of Old Shipping Module?
    By susb8383 in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 28 Jul 2009, 09:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR