I think your problem is more of a policy issue than a programming issue. What you're
trying to do is create logic to account for exceptions. I think the problem would be
better solved through management decisions than programatic decisions.
Consider this:
When a customer places an order, it is based upon inventory levels you believe to be
accurate to the best of your knowledge. Even if the computer says one thing and the
inventory clerks say the same thing, that doesn't mean that the product is actually
sitting on the shelf nor does it mean that the product is in deliverable condition.
With that in mind, you should only update the actual inventory levels once the product
has been shipped.
If you want to keep track of the order quantities vs. the actual quantity on hand - go
ahead! Once the order quantities exceed the last known inventory level, advise the
customer that the product MIGHT have to be on backorder and explain your policy on
backorders.
Programatic functions of flushing out bad orders should solve the problem of resetting
the order quantities on their own, and so the next customer ordering the same product
would not receive the backorder notice if there is sufficient quantity on hand.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: t nelson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 4:29 PM
> To: CF-Talk
> Subject: Putting a temporary hold on a quantity
>
>
> Hi All,
>
> I have a small dilemma on my hands. I am trying to figure out a
> way to place
> a temporary hold on a quantity in my database.
>
> Here's the scenario:
>
> I am in the process of finishing up an e-commerce site. like every other
> commerce site, users can go through items and place them into a shopping
> cart of sorts until they are ready to check out.
>
> here's the problem:
>
> let's say that a customer decides to bail out on the transaction
> at the last
> minute.(of course i'll have a button which will allow them to
> cancel their
> order) but let's say the persons pc crashes on them before they
> can finish
> their order or their phone service gets shut off or the world comes to an
> end (you get the picture). barring the last scenario, i would hate for
> another user to lose out on that product simply because it's out of the
> system in a manner of speaking.
>
> my question is basically this: is there a way for me to
> temporarily set the
> a fore mentioned quantity aside and then after a set time has
> expired have
> it reintroduced into my quantity field?
>
> thanks in advance,
>
> nelson
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
