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
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
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
www.dss-db.com 

"I destroy my enemies when I make them my friends."   

Abraham Lincoln




________________________________________________________________________


Roland A. Dumas
310 W. Bellevue Ave.
San Mateo, CA 94402
650-347-1373
415-412-9300 (cell)
AIM: radumas



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

Reply via email to