Page 1 of 3 123 LastLast
Results 1 to 10 of 28
  1. #1
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,557
    Plugin Contributions
    89

    Default Delete Spam Customers

    Delete Spam Customers allows you to bulk delete customer accounts created by
    bad guys. It cleans out all database records for the bad account.

    It's available here: https://www.zen-cart.com/downloads.php?do=file&id=2253
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  2. #2
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,063
    Plugin Contributions
    22

    Default Re: Delete Spam Customers

    I think you should state that you mean customers whose name starts with http. Not all create account spams use that.
    The full-time Zen Cart Guru. WizTech4ZC.com

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,557
    Plugin Contributions
    89

    Default Re: Delete Spam Customers

    You can adjust the query as needed to capture the pattern used by the bad guys.
    And the current query is not "starts with http" - rather, it's "contains http".
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  4. #4
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,063
    Plugin Contributions
    22

    Default Re: Delete Spam Customers

    gads, how ocd are you :) You are right. I do try to be specific but... Was just thinking about someone who ran across the plugin who might think it works for other spam customers as well. They use it and will complain that it doesn't work.
    The full-time Zen Cart Guru. WizTech4ZC.com

  5. #5
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,340
    Plugin Contributions
    1

    Default Re: Delete Spam Customers

    Thanks for this useful plugin - so how can we make this work for the myriad (50/day plus) of fake customers formatted along the lines of the examples below - cheers;

    first name: KocXreTJRvjk
    surname: FLIgRmQvaVdJ

    and

    first name: Holographicmoy
    surname: zvusalmeomfnxzpGP ..... this one is very common with the GP on the end

  6. #6
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,557
    Plugin Contributions
    89

    Default Re: Delete Spam Customers

    You might need to just use a date range or a customer id range.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  7. #7
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,340
    Plugin Contributions
    1

    Default Re: Delete Spam Customers

    Quote Originally Posted by swguy View Post
    You might need to just use a date range or a customer id range.
    it may be easier for me to delete directly from the db :)
    have just installed Access Blocker by lat9 so between the two hopefully it will catch the majority.
    (this plugin works brilliantly 'as is' for for the https)
    cheers,
    Mike

  8. #8
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,557
    Plugin Contributions
    89

    Default Re: Delete Spam Customers

    Be careful ... the reason I created the mod is that it's hard to delete from the DB without leaving straggling parts of a spam ID. Refer to the code to see all the tables touched.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  9. #9
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,340
    Plugin Contributions
    1

    Default Re: Delete Spam Customers

    Quote Originally Posted by swguy View Post
    Be careful ... the reason I created the mod is that it's hard to delete from the DB without leaving straggling parts of a spam ID. Refer to the code to see all the tables touched.
    Thanks for the advice Scott - the problem with setting a date range or customer i.d. range is that the spam accounts are mixed sporadically in with real accounts, or am I looking at it the wrong way?

  10. #10
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,557
    Plugin Contributions
    89

    Default Re: Delete Spam Customers

    you might have to do this 3 or 4 times (set the range, upload, run the file, set the range, upload, run the file ...) but at least you know the bad ones will be cleaned out properly.

    Also as another suggestion, take a look at ZenNonCaptcha. It has really cut down on spam for my clients that are using it.

    https://www.zen-cart.com/downloads.php?do=file&id=2207
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. v155 Spam - fake customers
    By ma.r.a in forum General Questions
    Replies: 29
    Last Post: 26 Jun 2019, 02:16 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