[thelist] Backend of a shopping cart system...

[Casey Crookston]

I'm working on a long response.... Stay tuned!

-----Original Message-----
From: Chris Blessing [mailto:webguy at mail.rit.edu]
Sent: Friday, April 05, 2002 9:26 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Backend of a shopping cart system...


But again, once the user ends their session, I have no idea what their
customer id was nor do I know what it will be the next time they start a
session... right?  Unless I write out that specific id to a cookie... I
can't bind it to their already-unique user account because I don't want
to require them to login/create an account before populating their cart.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> Each time a user click's "Add to Cart" a record is added to your Cart
> table.  This table will have several key fields, one being unique to
> that row, one which relates back to the customer (a Customer ID) and
> one which relates back to the product (a Product ID).  Another colum
> would indicate the staus of this items in the cart.  Example 1=added
> but not purchased; 2=Added then deleted; 3=Added and purchased.  When
> that visitor comes back, your SQL statement which populates his cart
> will select all items from Cart where Customer ID = current and Status

> ID = 1.
>
> Other data in this table will record the date and time it was added or

> deleted or purchased, etc.
>
> HTH,
>
> Casey

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !