|
Home > Archive > Commerce Server Catalog > June 2005 > Prices and quantities per region
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Prices and quantities per region
|
|
| Alexander Yushchenko 2005-04-01, 7:47 am |
| Hello!
We use CS2002 + SP3 + FP1.
Our customer wants the following.
We have one catalog containing categories and products.
Sales are only possible to customers who entered their zip code and
are located in one of the preset "regions" (we find out in what region
the customer is from zip code).
For each region each product has its quantity and price, and also a
"default" price shown for customers who didn't enter any zip code or are
out of delivery area (not in any region).
The list of regions is not fixed. of course, it is not changed
daily, but there must be a non-complicated way to modify it.
How to implement this?
1. We can use one base catalog with "default" prices and one
virtual catalog for each region. In this case we have no problems with
setting prices for each product, but what about quantities?
2. We can use one catalog for each region. In this case we have no
problems with setting different prices and quantities, but we need to
apply any changes to each catalog. And, of course, the amount of data is
enlarged greatly.
3. Any other suggestions?
--
Yours faithfully,
Alexander Yushchenko
| |
| Vinayak Tadas[MSFT] 2005-04-07, 6:03 pm |
| Have you considered using the external join table feature.
You can create a table QuantityPriceTable(id int, quantity, price)
where id is some unique identifier.
Cretae a property name quantityid in catalog system
Assign it to all the product definitions
Set the values to the property based on the corresponding values in the
QuantityPriceTable
At runtime you can do a join with the QuantityPriceTable and the products
in the catalog
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/secur_ity.
Please
reply to the newsgroups only. Thanks
--------------------
Date: Fri, 01 Apr 2005 16:47:09 +0400
From: Alexander Yushchenko <sasha-yoush@mtu-net.ru>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: ru-ru, ru
MIME-Version: 1.0
Subject: Prices and quantities per region
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <OMOBujrNFHA.2736@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: mipt.server.ru 194.67.183.7
Lines: 1
Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.commerceserver.catalog:5348
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Hello!
We use CS2002 + SP3 + FP1.
Our customer wants the following.
We have one catalog containing categories and products.
Sales are only possible to customers who entered their zip code and
are located in one of the preset "regions" (we find out in what region
the customer is from zip code).
For each region each product has its quantity and price, and also a
"default" price shown for customers who didn't enter any zip code or are
out of delivery area (not in any region).
The list of regions is not fixed. of course, it is not changed
daily, but there must be a non-complicated way to modify it.
How to implement this?
1. We can use one base catalog with "default" prices and one
virtual catalog for each region. In this case we have no problems with
setting prices for each product, but what about quantities?
2. We can use one catalog for each region. In this case we have no
problems with setting different prices and quantities, but we need to
apply any changes to each catalog. And, of course, the amount of data is
enlarged greatly.
3. Any other suggestions?
--
Yours faithfully,
Alexander Yushchenko
| |
| Alexander Yushchenko 2005-04-18, 5:51 pm |
| Thanks for your answer!
But, as far as I understand, this does not solve the problem.
The problem is: for each product we must have quantity and price
fields for each region (about 7 times); the decision what exact fields
to use is made on the customer location basis.
The list of regions (and customer assignment criteria as well) is
subject to change, so we cannot just create 7 quantity and 7 price
properties for each product.
The solution you provided just explains how to manage one price and
one quantity per product.
We need something like virtual catalogs, but in virtual catalogs we
can only set alternative prices, and we need also to set quantities.
Vinayak Tadas[MSFT] wrote:
> Have you considered using the external join table feature.
> You can create a table QuantityPriceTable(id int, quantity, price)
> where id is some unique identifier.
> Cretae a property name quantityid in catalog system
> Assign it to all the product definitions
> Set the values to the property based on the corresponding values in the
> QuantityPriceTable
> At runtime you can do a join with the QuantityPriceTable and the products
> in the catalog
>
> 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/secur_ity.
> Please
> reply to the newsgroups only. Thanks
>
>
> --------------------
> Date: Fri, 01 Apr 2005 16:47:09 +0400
> From: Alexander Yushchenko <sasha-yoush@mtu-net.ru>
> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
> X-Accept-Language: ru-ru, ru
> MIME-Version: 1.0
> Subject: Prices and quantities per region
> Content-Type: text/plain; charset=KOI8-R; format=flowed
> Content-Transfer-Encoding: 7bit
> Message-ID: <OMOBujrNFHA.2736@TK2MSFTNGP09.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.catalog
> NNTP-Posting-Host: mipt.server.ru 194.67.183.7
> Lines: 1
> Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.commerceserver.catalog:5348
> X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
> Hello!
>
> We use CS2002 + SP3 + FP1.
>
> Our customer wants the following.
> We have one catalog containing categories and products.
> Sales are only possible to customers who entered their zip code and
> are located in one of the preset "regions" (we find out in what region
> the customer is from zip code).
> For each region each product has its quantity and price, and also a
> "default" price shown for customers who didn't enter any zip code or are
> out of delivery area (not in any region).
> The list of regions is not fixed. of course, it is not changed
> daily, but there must be a non-complicated way to modify it.
>
> How to implement this?
>
> 1. We can use one base catalog with "default" prices and one
> virtual catalog for each region. In this case we have no problems with
> setting prices for each product, but what about quantities?
>
> 2. We can use one catalog for each region. In this case we have no
> problems with setting different prices and quantities, but we need to
> apply any changes to each catalog. And, of course, the amount of data is
> enlarged greatly.
>
> 3. Any other suggestions?
>
--
Yours faithfully,
Alexander Yushchenko
| |
| Vinayak Tadas[MSFT] 2005-06-09, 5:51 pm |
| Unfortunately this is a limitation of virtual catalogs in CS2002. In future
releases we might allow the ability to override other properties in virtual
catalogs also
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
--------------------
Date: Mon, 18 Apr 2005 20:05:07 +0400
From: Alexander Yushchenko <sasha-yoush@mtu-net.ru>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: ru-ru, ru
MIME-Version: 1.0
Subject: Re: Prices and quantities per region
References: <OMOBujrNFHA.2736@TK2MSFTNGP09.phx.gbl>
<vCHekd8OFHA.3892@TK2MSFTNGXA01.phx.gbl>
In-Reply-To: <vCHekd8OFHA.3892@TK2MSFTNGXA01.phx.gbl>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 8bit
Message-ID: <OmFllBDRFHA.2132@TK2MSFTNGP14.phx.gbl>
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: mipt.server.ru 194.67.183.7
Lines: 1
Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
4.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.commerceserver.catalog:5392
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Thanks for your answer!
But, as far as I understand, this does not solve the problem.
The problem is: for each product we must have quantity and price
fields for each region (about 7 times); the decision what exact fields
to use is made on the customer location basis.
The list of regions (and customer assignment criteria as well) is
subject to change, so we cannot just create 7 quantity and 7 price
properties for each product.
The solution you provided just explains how to manage one price and
one quantity per product.
We need something like virtual catalogs, but in virtual catalogs we
can only set alternative prices, and we need also to set quantities.
Vinayak Tadas[MSFT] wrote:
> Have you considered using the external join table feature.
> You can create a table QuantityPriceTable(id int, quantity, price)
> where id is some unique identifier.
> Cretae a property name quantityid in catalog system
> Assign it to all the product definitions
> Set the values to the property based on the corresponding values in the
> QuantityPriceTable
> At runtime you can do a join with the QuantityPriceTable and the products
> in the catalog
>
> 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/secur_ity.
> Please
> reply to the newsgroups only. Thanks
>
>
> --------------------
> Date: Fri, 01 Apr 2005 16:47:09 +0400
> From: Alexander Yushchenko <sasha-yoush@mtu-net.ru>
> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
> X-Accept-Language: ru-ru, ru
> MIME-Version: 1.0
> Subject: Prices and quantities per region
> Content-Type: text/plain; charset=KOI8-R; format=flowed
> Content-Transfer-Encoding: 7bit
> Message-ID: <OMOBujrNFHA.2736@TK2MSFTNGP09.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.catalog
> NNTP-Posting-Host: mipt.server.ru 194.67.183.7
> Lines: 1
> Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.commerceserver.catalog:5348
> X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
> Hello!
>
> We use CS2002 + SP3 + FP1.
>
> Our customer wants the following.
> We have one catalog containing categories and products.
> Sales are only possible to customers who entered their zip code and
> are located in one of the preset "regions" (we find out in what region
> the customer is from zip code).
> For each region each product has its quantity and price, and also a
> "default" price shown for customers who didn't enter any zip code or are
> out of delivery area (not in any region).
> The list of regions is not fixed. of course, it is not changed
> daily, but there must be a non-complicated way to modify it.
>
> How to implement this?
>
> 1. We can use one base catalog with "default" prices and one
> virtual catalog for each region. In this case we have no problems with
> setting prices for each product, but what about quantities?
>
> 2. We can use one catalog for each region. In this case we have no
> problems with setting different prices and quantities, but we need to
> apply any changes to each catalog. And, of course, the amount of data is
> enlarged greatly.
>
> 3. Any other suggestions?
>
--
Yours faithfully,
Alexander Yushchenko
|
|
|
|
|