Commerce Server General - Multiple storages in CS2007

Author

Multiple storages in CS2007

J.F. Larente

2006-06-20, 9:13 am

If I remember correctly, you could create a virtual catalog for each
physical location in order to track inventory. This way, storing the ERP
feed into each virtual catalog would work very well. The online shop could
still point to the base catalog but you would bring in the virtual catalog
anytime the person selected a store for checking inventory.

Let me know if you want me to investigate this further.

J.F. Larente
Cactus Commerce

"FredrikT" <FredrikT@discussions.microsoft.com> wrote in message
news:40EEB679-A8A0-40D8-86C1-579F082C1B05@microsoft.com...
> Hi,
>
> I am investigating the potential use of CS2007 for a online shop. I have
> looked at the Catalog and it seems like that will fit in to our
> requirements.
>
> When it comes to inventory, we have to keep track of the storage for a
> couple of hundred physical stores. We are not actually hosting the stock
> balance; that is sent to us from the ERP system. So when a customer places
> an
> order, we don't have to do anything with the stock balance.
>
> I have looked briefly at the Inventory object, but I'm not sure if that
> can
> handle multiple storages? Another way might be to store the storage for
> each
> store in a separate table and the join with the product catalog. Don't
> know
> if that makes sence?
>
> Thanks

FredrikT

2006-06-20, 1:19 pm

Hi,

I am investigating the potential use of CS2007 for a online shop. I have
looked at the Catalog and it seems like that will fit in to our requirements.

When it comes to inventory, we have to keep track of the storage for a
couple of hundred physical stores. We are not actually hosting the stock
balance; that is sent to us from the ERP system. So when a customer places an
order, we don't have to do anything with the stock balance.

I have looked briefly at the Inventory object, but I'm not sure if that can
handle multiple storages? Another way might be to store the storage for each
store in a separate table and the join with the product catalog. Don't know
if that makes sence?

Thanks

J.F. Larente

2006-06-20, 1:19 pm

Vinayak Tadas[MSFT]

2006-06-21, 12:03 am

Have you considered adding a property to the product definition which
stores the inventory information?
That way you can avoid joining with additional tables

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

--------------------
Thread-Topic: Multiple storages in CS2007
thread-index: AcaUcWhYYUhKHuLPQSmuIpEFFJ4bVA==
X-WBNR-Posting-Host: 194.18.224.139
From: =?Utf-8?B?RnJlZHJpa1Q=?= <FredrikT@discussions.microsoft.com>
Subject: Multiple storages in CS2007
Date: Tue, 20 Jun 2006 06:57:02 -0700
Lines: 16
Message-ID: <40EEB679-A8A0-40D8-86C1-579F082C1B05@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17928
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi,

I am investigating the potential use of CS2007 for a online shop. I have
looked at the Catalog and it seems like that will fit in to our
requirements.

When it comes to inventory, we have to keep track of the storage for a
couple of hundred physical stores. We are not actually hosting the stock
balance; that is sent to us from the ERP system. So when a customer places
an
order, we don't have to do anything with the stock balance.

I have looked briefly at the Inventory object, but I'm not sure if that can
handle multiple storages? Another way might be to store the storage for
each
store in a separate table and the join with the product catalog. Don't know
if that makes sence?

Thanks

FredrikT

2006-06-21, 1:50 am

Haven't thought about that, and to be honest my exeperience and knowledege of
CS is limited. I'd really appreciate if you would like to explain a little
bit more how we could use product definition properties for our inventory.

Thanks,

Fredrik

""Vinayak Tadas[MSFT]"" wrote:

> Have you considered adding a property to the product definition which
> stores the inventory information?
> That way you can avoid joining with additional tables
>
>
> 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
>
>
> --------------------
> Thread-Topic: Multiple storages in CS2007
> thread-index: AcaUcWhYYUhKHuLPQSmuIpEFFJ4bVA==
> X-WBNR-Posting-Host: 194.18.224.139
> From: =?Utf-8?B?RnJlZHJpa1Q=?= <FredrikT@discussions.microsoft.com>
> Subject: Multiple storages in CS2007
> Date: Tue, 20 Jun 2006 06:57:02 -0700
> Lines: 16
> Message-ID: <40EEB679-A8A0-40D8-86C1-579F082C1B05@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.general
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17928
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
>
> I am investigating the potential use of CS2007 for a online shop. I have
> looked at the Catalog and it seems like that will fit in to our
> requirements.
>
> When it comes to inventory, we have to keep track of the storage for a
> couple of hundred physical stores. We are not actually hosting the stock
> balance; that is sent to us from the ERP system. So when a customer places
> an
> order, we don't have to do anything with the stock balance.
>
> I have looked briefly at the Inventory object, but I'm not sure if that can
> handle multiple storages? Another way might be to store the storage for
> each
> store in a separate table and the join with the product catalog. Don't know
> if that makes sence?
>
> Thanks
>

FredrikT

2006-06-21, 1:54 am

I read a little bit about virtual directories in CS2007 but wasn't sure you
could/should use them to track inventory for each physical store. Based on
your input, I might be able to investigate this a little bit further, and if
you have more information on the subject you are more than welcome to share
it.

Thanks,

Fredrik

"J.F. Larente" wrote:

> If I remember correctly, you could create a virtual catalog for each
> physical location in order to track inventory. This way, storing the ERP
> feed into each virtual catalog would work very well. The online shop could
> still point to the base catalog but you would bring in the virtual catalog
> anytime the person selected a store for checking inventory.
>
> Let me know if you want me to investigate this further.
>
> J.F. Larente
> Cactus Commerce
>
>
> "FredrikT" <FredrikT@discussions.microsoft.com> wrote in message
> news:40EEB679-A8A0-40D8-86C1-579F082C1B05@microsoft.com...
>
>
>

J.F. Larente

2006-06-21, 7:07 am

You could add some properties to your product definition for example if you
have a shoe which is normally defined as:

Product:
Name
Description
Price

Variant:
Size
Color

You could add properties to your product definition extend that to have the
above plus:

Variant:
Store1Inventory
Store2Inventory
Store3Inventory

Is that where you were going Vinayak?
That being said though, if you have 50 stores, you have 50 fields in your
product definition (If I've got this right).

But keeping in mind that this is is CS 2007, why couldn't you simply use one
virtual catalog per physical location and leverage the "out of the box" CS
inventory system. The site could use the base catalog for browsing and
leverage the virtuals for inventory checking.

Thanks,
J.F. Larente
Cactus Commerce

"FredrikT" <FredrikT@discussions.microsoft.com> wrote in message
news:AE70093E-2063-4CF1-8441-34C2E6166362@microsoft.com...[vbcol=seagreen]
> Haven't thought about that, and to be honest my exeperience and knowledege
> of
> CS is limited. I'd really appreciate if you would like to explain a little
> bit more how we could use product definition properties for our inventory.
>
> Thanks,
>
> Fredrik
>
> ""Vinayak Tadas[MSFT]"" wrote:
>

Vinayak Tadas[MSFT]

2006-06-21, 7:29 am

FredrikT

2006-06-21, 7:29 am

FredrikT

2006-06-21, 7:29 am

J.F. Larente

2006-06-21, 7:29 am

FredrikT

2006-06-28, 7:23 am

Thanks.

Vinayak, is this where you were going?

/Fredrik

"J.F. Larente" wrote:

> You could add some properties to your product definition for example if you
> have a shoe which is normally defined as:
>
>
> Product:
> Name
> Description
> Price
>
> Variant:
> Size
> Color
>
> You could add properties to your product definition extend that to have the
> above plus:
>
> Variant:
> Store1Inventory
> Store2Inventory
> Store3Inventory
>
> Is that where you were going Vinayak?
> That being said though, if you have 50 stores, you have 50 fields in your
> product definition (If I've got this right).
>
> But keeping in mind that this is is CS 2007, why couldn't you simply use one
> virtual catalog per physical location and leverage the "out of the box" CS
> inventory system. The site could use the base catalog for browsing and
> leverage the virtuals for inventory checking.
>
> Thanks,
> J.F. Larente
> Cactus Commerce
>
>
> "FredrikT" <FredrikT@discussions.microsoft.com> wrote in message
> news:AE70093E-2063-4CF1-8441-34C2E6166362@microsoft.com...
>
>
>
>