Windows Server

Kyle Malcharek · Guest

Hi,

We're planning on integrating inventory management into Commerce Server.
I've read through the "Integrating Inventory Data with a Catalog System"
book, but it includes inventory levels in the base catalog. So, whenever
inventory levels change, so does the base catalog and the database must
be re-cached. What we'd like to do is keep inventory levels in a
separate table, and perform a join with the catalog table to avoid
having to constantly re-cache it.

Has anyone approached inventory management this way? If so, would you
recommend using the oid from the base catalog table as primary key/join
value or the ProductID and VariantID? Any other tips?

Thanks,

-Kyle

Vinayak Tadas[MSFT] · Guest

I guess using the oid as a join key would be better since it uniquely
identifies a record in the catalog table and also since you can only
specify one join key(If you have variants this can be an issue)

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only

--------------------
Reply-To: "Kyle Malcharek" <kyle.malcharek@nospam.officialcommunity.com>
From: "Kyle Malcharek" <kyle.malcharek@nospam.officialcommunity.com>
Sender: "Kyle Malcharek" <kyle.malcharek@nospam.officialcommunity.com>
Subject: Planning to implement inventory management
Date: Tue, 30 Aug 2005 12:31:08 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_00CB_01C5AD5E.BA907E90"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
thread-index: AcWtgDnDxvSsbhKpR0GOulV1ZG8mog==
X-Transport: MAPILab NNTP v1.3 for Microsoft Outlook,
http://www.mapilab.com/
Message-ID: <Oo9HDBYrFHA.3852@TK2MSFTNGP15.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: mail.officialcommunity.net 207.188.77.211
Lines: 1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3324
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi,

We're planning on integrating inventory management into Commerce Server.
I've read through the "Integrating Inventory Data with a Catalog System"
book, but it includes inventory levels in the base catalog. So, whenever
inventory levels change, so does the base catalog and the database must
be re-cached. What we'd like to do is keep inventory levels in a
separate table, and perform a join with the catalog table to avoid
having to constantly re-cache it.

Has anyone approached inventory management this way? If so, would you
recommend using the oid from the base catalog table as primary key/join
value or the ProductID and VariantID? Any other tips?

Thanks,

-Kyle

Ravi Shankar · Guest

Hi Kyle,

How real do you want your Inventory ?

If you do a join with catalog it'd be cached with the catalog and
subsequents updates such as on purchase would leave your site with some
discrepancies ...

If you write a component and make a check on every product page refresh
you'd incur additional overheads (such as page response, end user response
and probably a higher spec server to support your user load) associated with
this call but you'd have correct inventory values..

You need to decide on what is critial for the business operation and take a
call...

My 2c
--
Ravi Shankar

"Kyle Malcharek" wrote:

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1