bp100a
Guest
|
 Posted:
Mon Oct 25, 2004 11:24 pm Post subject:
Decrementing Inventory |
|
|
I'm having a problem decrementing inventory.
First my "InventoryCheck" stage (a Scriptor component) verifies that the
quantity in stock is sufficient to meet the lineitem (in this case both
values are 1, this site sells collectibles, so there is only 1 of any item).
Later in the Checkout Pipeline is a SQLADOItem that decrements the database
quantity value.
The problem is that the "cached" value is not decremented, hence two
simulated users can checkout the same item (the item have a quantity of 1).
I know it has something to do with the cache, if I IISRESET the server
between checkouts things work fine.
Any ideas?
/harry |
|
David Messner [MSFT]
Guest
|
| Posted:
Sat Dec 11, 2004 2:08 am Post subject:
RE: Decrementing Inventory |
|
|
There are a lot of questions related to this. But I can tell you that such
a simplistic inventory scheme is likely to be riddled with problems. The
good news is that proper inventory integration is a planner feature for
Commerce Server 2006.
When you are referring to cached values, I presume you mean cached by the
catalog system? The existing catalog system isn't suitable for data is
that is read/write, it is suitable only for infrequently changing data.
I suggest you would be much better off writing your own inventory system
distinct from the catalog system from scratch than attempting to do this.
Alternatively, wait for 2006.
regards
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.
--------------------
From: "bp100a" <someone@microsoft.com>
Subject: Decrementing Inventory
Date: Mon, 25 Oct 2004 14:24:15 -0400
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <eX04y$ruEHA.272@TK2MSFTNGP15.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: pcp02329569pcs.summit01.nj.comcast.net 68.84.50.160
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15021
X-Tomcat-NG: microsoft.public.commerceserver.general
I'm having a problem decrementing inventory.
First my "InventoryCheck" stage (a Scriptor component) verifies that the
quantity in stock is sufficient to meet the lineitem (in this case both
values are 1, this site sells collectibles, so there is only 1 of any item).
Later in the Checkout Pipeline is a SQLADOItem that decrements the database
quantity value.
The problem is that the "cached" value is not decremented, hence two
simulated users can checkout the same item (the item have a quantity of 1).
I know it has something to do with the cache, if I IISRESET the server
between checkouts things work fine.
Any ideas?
/harry |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in