indeed I left out the time and reallocation point... yes... know your customer and limit the hold experience.. for some 1 hour might be too long... 30 minutes typically is gracious... affording the shopper the timeout notice via popup and giving the an opportunity to buy it or lose it is a fair business rule... enforce it.
-paris -----Original Message----- From: Kurt Ward [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 13:33 To: CF-Talk Subject: RE: Dealing with inventories We do this for clearance items to keep from overselling stock. If a clearance product is added to a basket, we flag the qty as "hold". If the items are purchased within one hour, we decrement the inventory. We have a stored proc running every 15 minutes that removes any unpurchased items from baskets if they are at least 1 hour old which releases them from the "hold" count. Has worked well for us. Kurt -----Original Message----- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 1:24 PM To: CF-Talk Subject: RE: Dealing with inventories nice idea... suppose that could be done to ticket master too...?? Add rows 1-1000 at the local concert hall to my cart.. :) that would in theory be a funny denial of service to hear about... a crappy one to have to explain to investors/management... -p -----Original Message----- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 13:20 To: CF-Talk Subject: Re: Dealing with inventories Isn't this a security flaw? Seems like someone could easily script a Denial of Service to go to your site, add all your inventory to their cart, therefore preventing anything from being sold ----- Original Message ----- From: "stas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 10:59 AM Subject: Dealing with inventories > Hello, > > I am trying to figure out how to deal with updating the inventory in a > shopping cart. I create (only if it doesn't already exist) an application > scoped array within a CFLOCK populated by looping over a query. As users add > items, I update the quantities in the that array. What I can't figure out is > how to deal with abandoned shopping carts - how do I update the inventory > back to the real value? > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
