Page 5 of 5 FirstFirst ... 345
Results 41 to 43 of 43
  1. #41
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,649
    Plugin Contributions
    117

    Default Re: Delete Spam Customers

    It never happened but I had a bad dream about it. You *could* have a customer from Zimbabwe who worked for Google and had a yandex.com email address!
    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.
    Do you benefit from Zen Cart? Then please support the project.

  2. #42
    Join Date
    Jul 2007
    Posts
    322
    Plugin Contributions
    6

    Default Re: Delete Spam Customers

    @swguy
    I looked at your delete spam customers as you suggested.
    I worked out if I add this it will remove customers who have not ordered, but I would prefer to not delete customers who have not ordered in the last month. Is there a way of amending this:
    PHP Code:
    $queries[] = array(   'name' => 'Accounts with no purchase',    'string' => "SELECT customers_id FROM " TABLE_CUSTOMERS " WHERE customers_id NOT IN (SELECT customers_id FROM ".TABLE_ORDERS.")"); 
    Assuming this is correct, as the plugin was originally yours do you want to amend it to include this or should I simply submit a revised plugin as Remove Customers who have not ordered?
    Thanks for the guidance.

  3. #43
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,649
    Plugin Contributions
    117

    Default Re: Delete Spam Customers

    Quote Originally Posted by ianhg View Post
    Assuming this is correct, as the plugin was originally yours do you want to amend it to include this or should I simply submit a revised plugin as Remove Customers who have not ordered?
    Thanks for the guidance.
    Neither. I don't update it every time someone has a new idea for a query.

    You said,
    > I would prefer to not delete customers who have not ordered in the last month.

    Do you mean "delete customers who have never ordered if their accounts are more than a month old?"

    If so, see the FAQ on my site has additional examples that might be useful. The last example will point you in the right direction.

    Test your query in phpMyAdmin and see if it's satisfactory.
    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.
    Do you benefit from Zen Cart? Then please support the project.

 

 
Page 5 of 5 FirstFirst ... 345

Similar Threads

  1. v155 Spam - fake customers
    By ma.r.a in forum General Questions
    Replies: 32
    Last Post: 4 Nov 2019, 10:15 PM
  2. v150 Spam Review Messages - 5000+ how to delete?
    By creamcrackers in forum General Questions
    Replies: 5
    Last Post: 24 Apr 2012, 04:55 PM
  3. All customers fields in ADMIN > CUSTOMERS are empty and I can't delete them!
    By plgaudreau in forum Managing Customers and Orders
    Replies: 1
    Last Post: 26 Feb 2008, 02:08 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