I thought of that but what do I do then if they never finish the registration for some reason so the course is not paid for.
Your right that I want to pull it out of inventory but how do I get it back in if they don't actually make a purchase. -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: "Tom Ferguson" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Mon, 30 Dec 2002 14:50:11 -0500 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: RE: Witango-Talk: Courses Full? > > well, if you think of this "shopping cart" as an actual shopping cart, you > could reduce your class "inventory" as soon as it was put in the cart. So > if Mrs. Smith put little Billy on the class list, it would be full and not > allow her to pick that same class for Jill. Then she has the option of > putting Billy's class "back on the shelf". > > I'd also be sure to timestamp the transactions... just in case. > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Stein >> Sent: Monday, December 30, 2002 2:36 PM >> To: Multiple recipients of list witango-talk >> Subject: Witango-Talk: Courses Full? >> >> >> Looking for suggestions. >> >> I have a community school application that allows users to sign up for >> courses on line. For 90% of the courses the max amount of classes is not >> critical. One or two over makes no difference. And class demand >> is not high. >> >> Therefore this system works fine. >> >> When a user selects a course it is put in their basket. >> >> When the pay for the course(s) the course count is increased by one and if >> it is = or > course max then course is closed. >> >> But now we are adding these kids swim program courses. They are >> limited and >> highly competitive to get in. Probably 150 people will sign up >> kids between >> 8 and 10 AM the 1st day. >> >> My problem is how to keep the course count accurate when they sign up more >> than one kid in their family. >> >> So here is the scenario. >> >> Mrs. Smith has 3 kids >> >> She logs into the site and goes to registration >> >> She gets a drop down list of her family members. >> >> She picks bill and swimming and puts course 1401 in her basket ( there is >> room for 32 kids and bill makes number 32) >> >> She then goes to add Jill >> >> She selects the same course >> >> Without counting Bill it is still open but in reality if she were >> to pay for >> Bills course now it would be closed. >> >> The system will think it is open and allow her to add Jill but now we are >> one over. >> >> >> The other issue is with so many people signing up at once while a >> course is >> open when you 1st sign up by the time you get to the checkout it might be >> closed. >> >> I can deal with this last one I guess by checking the course count again >> before checkout and if the course is now closed show them that >> and wait list >> them removing the charge. >> >> Any other thoughts on how to handle this? >> >> >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> Land: 215-799-0192 >> Mobile: 610-256-2843 >> Fax 413-410-9682 >> FMP, WiTango, EDI,SQL 2000 >> [EMAIL PROTECTED] >> www.dss-db.com >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
