Don't you have to prevent overselling of ALL your stock? Our inventory is a bit different than most because we can't re-order or back-order anything, what we have is what we have. So I check your cart against inventory when you add something (but don't allocate) and then again when you go to checkout...
> 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 crap py > 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 Den ial > 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 applicati on > > scoped array within a CFLOCK populated by looping over a query. As user s > add > > items, I update the quantities in the that array. What I can't figure o ut > is > > how to deal with abandoned shopping carts - how do I update the invento ry > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists