Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Berkshire, UK
    Posts
    1,482
    Plugin Contributions
    1

    Default How do I delete a batch of customers based on certain criteria?

    I see that in the email centre, there's an option to email customers who have never purchased, and one for all subscribers, but although I've had a look round the functions, I think I'm a bit too dim to do the following, even in mysql!
    I simply want to delete all customers who registered over 6 months ago AND have never bought anything AND who are not newsletter subscribers.

    Any ideas appreciated! Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Berkshire, UK
    Posts
    1,482
    Plugin Contributions
    1

    Default Re: How do I delete a batch of customers based on certain criteria?

    I don't like "bumping" threads, but one last attempt - if anyone knows the answer to this, it would be great! Thanks

  3. #3
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: How do I delete a batch of customers based on certain criteria?

    You should be able to do this from your webmaster panel using phpMyAdmin, but I'll have to give some thought to what the mySQL statement would have to be. If you can give me a little time, I'll see what I can do, but I recommend using phpMyAdmin to backup your database before trying something like this.
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

 

 

Similar Threads

  1. v153 Client to update Order Status themselves if certain criteria met.
    By Matt Staines in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 27 Jul 2016, 11:59 AM
  2. v139h Choose shipping calculator based on supplied product criteria
    By breauxlg in forum Addon Shipping Modules
    Replies: 1
    Last Post: 2 May 2012, 03:14 PM
  3. How to delete certain Category Links?
    By NBordeau in forum General Questions
    Replies: 0
    Last Post: 6 May 2010, 06:40 AM
  4. how to batch delete orders?
    By artbobo in forum Managing Customers and Orders
    Replies: 0
    Last Post: 26 Aug 2009, 05:39 PM
  5. Replies: 3
    Last Post: 18 Dec 2008, 04:20 AM

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