y a catalog/phone order
> business, items
> on backorder are fine. If our entire stock had to play this game it would
> paint an entirely different picture.
>
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 17, 2002 2:
TED]]
Sent: Thursday, January 17, 2002 2:20 PM
To: CF-Talk
Subject: RE: Dealing with inventories
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
Here's yet another way to do this. DB-intensive but has never given me any trouble (is
vulnerable to a DoS attack, and merchant/siteowner knows this):
I use a db-based cart, and each product record in the products table has 3 fields:
Qty, Reserved and Sold. When an item is put into a cart Qty
but that's another story) but I'm
checking against inventory when you add to cart AND when you place the
order.
> -paris
>
>
> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 17, 2002 10:01
> To: CF-Talk
> Subj
e" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 11:14 AM
Subject: RE: Another dealing with inventories?
> You're turning an everyday problem into a show stopper.
>
> If the relationship is 1 to 1 between songs and clip
> > 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 unpu
:01
To: CF-Talk
Subject: Re: Dealing with inventories
But when a shopping cart is abandoned (which is often), you've got
inventory allocated that you can't sell for however long you wait to clean
up... In my case, we often have small quantities of titles, so I can't
afford to do th
hild may
have
peace'..."
- Thomas Paine, The American Crisis
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 10:47 AM
To: CF-Talk
Subject: Re: Another dealing with inventories?
Actually maybe I know the answer, but tell me if thi
I think the product catalog is in the application scope, not the individual
shopping carts.
- Original Message -
From: "Stephen Moretti" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 12:43 PM
Subject: Re: Dealing
l 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
>
>
&
Thanks for all the suggestions. Just to clarify, I am NOT using application
scope for the shopping cart. I am using application scope for a global array
that holds an up-to-date inventory.
- Original Message -
From: "Stephen Moretti" <[EMAIL PROTECTED]>
>
> I am trying to figure out how
But when a shopping cart is abandoned (which is often), you've got
inventory allocated that you can't sell for however long you wait to clean
up... In my case, we often have small quantities of titles, so I can't
afford to do that...
> Yes, that's what I'm doing - allocating the inventory when th
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
>
> 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 fig
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
]>
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 applicatio
n" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 10:40 AM
Subject: Another dealing with inventories?
> I have a form with several fields that will be filled in by someone
> adding song titles. Each song title will have a song clip(3
Message -
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 12:40 PM
Subject: Another dealing with inventories?
> I have a form with several fields that will be filled in by someone
> adding song titles.
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 preve
I have a form with several fields that will be filled in by someone
adding song titles. Each song title will have a song clip(30 second demo
of song) Have not figured out if they should be on the same form or not.
I need figure out how to handle the song clip issue.
I need the song clips ID to
" <[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 ar
002 12:54 PM
To: CF-Talk
Subject: Re: Dealing with inventories
Yes, that's what I'm doing - allocating the inventory when the item is
added. Otherwise, IMO, it's like running around in the supermarket and
taking things from one shopper's card and giving the items to the anoth
Yes, that's what I'm doing - allocating the inventory when the item is
added. Otherwise, IMO, it's like running around in the supermarket and
taking things from one shopper's card and giving the items to the another
one :DO
- Original Message -
From: "Tony Schreiber" <[EMAIL PROTECTED]>
Are you saying that you're allocating inventory to that person when they
put the item in their shopping cart (meaning it's no longer available for
sale)?
What I do is check inventory before it's placed in the cart to make sure
there's adequate inventory, then I ignore it... When the order is to b
TED]]
Sent: Thursday, January 17, 2002 10:59 AM
To: CF-Talk
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 o
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 figur
26 matches
Mail list logo
