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

[ Post a follow-up to this message ]

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 a
n
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

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]

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: examnotes <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

Attachment:
This has been downloaded 0 time(s).

[ Post a follow-up to this message ]

Haven't thought about that, and to be honest my exeperience and knowledege o
f
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 right
s.
>  You assume all risk for your use. © 2002 Microsoft Corporation. All ri
ghts
>  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.  Plea
se
>  reply to the newsgroups only
>
>
> --------------------
> Thread-Topic: Multiple storages in CS2007
> thread-index: AcaUcWhYYUhKHuLPQSmuIpEFFJ4bVA==
> X-WBNR-Posting-Host: 194.18.224.139
> From: examnotes <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 ca
n
> 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 kno
w
> if that makes sence?
>
> Thanks
>

[ Post a follow-up to this message ]

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... 
>
>
>

[ Post a follow-up to this message ]

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:
> 

[ Post a follow-up to this message ]

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: examnotes <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

Attachment:
This has been downloaded 0 time(s).

[ Post a follow-up to this message ]

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... 
>
>
>

[ Post a follow-up to this message ]

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:
> 

[ Post a follow-up to this message ]