Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Location
    Pittsburgh, PA area
    Posts
    26
    Plugin Contributions
    0

    Default Customer Reports/Customer Duplicates

    I was wondering if there is a way to pull a customer report to try and identify duplicate customers
    so we can clean up the database?

    Also - is there a way to prevent customers from creating duplicate records?

    Thanks so much!!

  2. #2
    Join Date
    Jul 2012
    Posts
    14,306
    Plugin Contributions
    17

    Default Re: Customer Reports/Customer Duplicates

    If still using ZC 1.3.8a as identified in the thread title, then the answer is probably not. As far as "duplicate" customers, customers are identified by email address. Do these existing "duplicate" customers have the same email address? The next "practical" question is how would the individual be identified as a duplicate? Couldn't there be two John doe's somewhere? (explaining how duplicates have been seen would help in that.)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

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

    Default Re: Customer Reports/Customer Duplicates

    Here's a possibly useful SQL query:

    select customers_id, customers_firstname, count(customers_telephone) as cust_count from customers group by customers_telephone having count(customers_telephone) > 1;

    Also, my 360 sales reporting mod may give you some ideas on how to tie customer accounts together if they originate from the same person, rather than deleting them.

    https://www.zen-cart.com/downloads.php?do=file&id=2218
    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.

 

 

Similar Threads

  1. Replies: 2
    Last Post: 19 Sep 2012, 03:40 AM
  2. Best advice for merging two customer accounts? (duplicates by google)
    By pricediscrimination in forum General Questions
    Replies: 1
    Last Post: 30 Nov 2011, 12:10 AM
  3. Customer Reports
    By fusionsp in forum General Questions
    Replies: 0
    Last Post: 10 Jul 2008, 06:56 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