RE: Witango-Talk: Avoiding Duplicate customers

[Rick Sanders]

Dan,   But when they submit an order, you need their billing information and email address.   Why don’t you just use their email address as the unique identifier, and compare it with their family name?   Then, do the verification when they try to re-submit the order and compare the email address with the family name? Or other address information they give.   Rick Sanders President 902-401-7689 www.webenergy-sw.com From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 14, 2006 5:18 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Avoiding Duplicate customers   you can always to a soft login. The first visit or first purchase, they get a cookie. When they return to the site, the cookie looks up their information, including their customer account number.   On Mar 14, 2006, at 12:21 PM, Dan Stein wrote: Guess I did not phrase the question right and now that I think about it I will just have to find a way to merge accounts. It is not an issue of saving a cart. It is trying to avoid duplicate customer records in the database for those customers who do not want to "join". I am thinking the best I can do besides incentives and discounts is to ask them one last time if they want to enter a user name and password and become members.   Dan         on 3/14/06 12:33, Rick Sanders at [EMAIL PROTECTED] wrote:   I assign a basket id. One to the user's array, and the other to a domain array. The domain array also has a timestamp of when the id was assigned.   If the basket is exists in both arrays, the customer is active. When they process an order, I assign the basket id to the domain array, then the basket id to the user as a cookie.   Even if they close their browser and come back, I can still track them. I compare the cookie with domain var and compare the timestamp with the time the user submitted the order.   Then, if they want to shop again, I just do an Are you sure verification to the user that they want to submit the order, and they already submitted an order previously at the time that was stamped.   Another way to do it would be to use a table in the database to store temporary shopping carts, but that can get messy.     Rick Sanders President 902-401-7689 www.webenergy-sw.com     -----Original Message----- From: Shane Pearlman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 14, 2006 12:35 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Avoiding Duplicate customers   Hi Dan,   Since the whole cart sits in a user var array, after a successful purchase I dump the cart into a new user var array called something like last purchase and create another user var called last purchase ts. If that user tries to process another transaction within 15 minutes, I compare the carts and if they are identical, I shift them to an error cart duplication page and let them know that if this is not an error, come back in 15.   It's not the perfect solutions and I'm sure that someone else may have a better one.   Shane Pearlman 831.345.7033   -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 14, 2006 5:39 AM To: witango-talk@witango.com Subject: Witango-Talk: Avoiding Duplicate customers   What have people found to be the best techniques for avoiding duplicate customer entries on a ecomm site where you allow orders without sign up?     -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com   "I destroy my enemies when I make them my friends."   Abraham Lincoln         ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf     Roland A. Dumas 310 W. Bellevue Ave. San Mateo, CA 94402 650-347-1373 415-412-9300 (cell) AIM: radumas [EMAIL PROTECTED]     ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf