> > 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. > > 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...
I don't think there's one "right" way to do this - this is a business question, not a technical question. For some business models, one way might be better than another, and for others, the reverse may be the case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ 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
