We have a catalog of publications and have setup multiple quantity
discounts for each publication type.

Discount $1 if user orders 2-10 of pub type A
Discount #2 if user orders 11-50 of pub type A
etc....

Each of the discounts is setup using an expression that contains
criteria that identifies the 'publication type' (i.e. certain
publisher, etc...).

The discounts are currently functioning such that the discount defined
(as above) applies to each publication that matches criteria in the
expression.  For example, if the user orders 1 of book C and 1 of book
D then the discount #1 (defined above) will apply to both books (if
the order total between the two totals 2-10) since they both match
criteria specified in the expression.

What we need is for the discount to apply to individual titles, so
that the user has to order 2 of book C or 2 of book D for the discount
to apply.  I realize we can do this by setting up a group of quantity
discounts for each title, but that would be tedious using BizDesk or
via SQL considering the number of publications we have, any
suggestions on how to do this?  Is there a simpler way to accomplish
quantity discounts by item?

Thanks,
Jennifer

[ Post a follow-up to this message ]

No.

I ran into that problem a few months ago.  There isn't an easy way around
this short of creating thousands of quantity discount rules in CS2002.  What
we ended up doing was this:

We have hundreds of products but only a few quantity discount rules.  So we
added a product definition to the catalog for each item called
"QuantityDiscountGroup".

Then we created a sql table Called QuantityDiscounts.  The table columns
were basically:
DiscountGroupID
Quantity
Discount

Then we created a C# pipeline component to adjust the price of the items
depending on quantity ordered.  The component read the discountgroupid from
the catalog for the given item, got the quantity from the basket and then
looked up what the quantity discount should be based on the
QuantityDiscounts table rules.

We found that this was the best method to solve our problem.  It allowed us
to easily manage the discount rules without affecting any of the other
CS2002 discounting modules.

Hope this helps.

-Randy


"Jennifer" <jdickson@beacontec.com> wrote in message
news:4195d87c.0403151128.82d3cfc@posting.google.com...
> We have a catalog of publications and have setup multiple quantity
> discounts for each publication type.
>
> Discount $1 if user orders 2-10 of pub type A
> Discount #2 if user orders 11-50 of pub type A
> etc....
>
> Each of the discounts is setup using an expression that contains
> criteria that identifies the 'publication type' (i.e. certain
> publisher, etc...).
>
> The discounts are currently functioning such that the discount defined
> (as above) applies to each publication that matches criteria in the
> expression.  For example, if the user orders 1 of book C and 1 of book
> D then the discount #1 (defined above) will apply to both books (if
> the order total between the two totals 2-10) since they both match
> criteria specified in the expression.
>
> What we need is for the discount to apply to individual titles, so
> that the user has to order 2 of book C or 2 of book D for the discount
> to apply.  I realize we can do this by setting up a group of quantity
> discounts for each title, but that would be tedious using BizDesk or
> via SQL considering the number of publications we have, any
> suggestions on how to do this?  Is there a simpler way to accomplish
> quantity discounts by item?
>
> Thanks,
> Jennifer

[ Post a follow-up to this message ]

That's a really good suggestion Randy.

I wonder, if the discount system simply added an option such as "Where all
condition items must be the same product", would that have solved your
problem?

E.g. Buy 100 or more items with publication type = 'XYZ' where all
condition items must be the same product, then get $5 off publication type
'XYZ'.

Would this feature be useful?

-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.
--------------------
Reply-To: "Randy Jeppesen" <randywalker75@hotmail.com>
From: "Randy Jeppesen" <randywalker75@hotmail.com>
References: <4195d87c.0403151128.82d3cfc@posting.google.com>
Subject: Re: Quantity discounts per item
Date: Wed, 17 Mar 2004 16:48:54 -0500
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <OgMVnmGDEHA.2404@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.commerceserver.campaigns_csf
NNTP-Posting-Host: 207.59.44.13
Path:
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.commerceserver.campaigns_csf:2576
X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf

No.

I ran into that problem a few months ago.  There isn't an easy way around
this short of creating thousands of quantity discount rules in CS2002.  What
we ended up doing was this:

We have hundreds of products but only a few quantity discount rules.  So we
added a product definition to the catalog for each item called
"QuantityDiscountGroup".

Then we created a sql table Called QuantityDiscounts.  The table columns
were basically:
DiscountGroupID
Quantity
Discount

Then we created a C# pipeline component to adjust the price of the items
depending on quantity ordered.  The component read the discountgroupid from
the catalog for the given item, got the quantity from the basket and then
looked up what the quantity discount should be based on the
QuantityDiscounts table rules.

We found that this was the best method to solve our problem.  It allowed us
to easily manage the discount rules without affecting any of the other
CS2002 discounting modules.

Hope this helps.

-Randy


"Jennifer" <jdickson@beacontec.com> wrote in message
news:4195d87c.0403151128.82d3cfc@posting.google.com...
> We have a catalog of publications and have setup multiple quantity
> discounts for each publication type.
>
> Discount $1 if user orders 2-10 of pub type A
> Discount #2 if user orders 11-50 of pub type A
> etc....
>
> Each of the discounts is setup using an expression that contains
> criteria that identifies the 'publication type' (i.e. certain
> publisher, etc...).
>
> The discounts are currently functioning such that the discount defined
> (as above) applies to each publication that matches criteria in the
> expression.  For example, if the user orders 1 of book C and 1 of book
> D then the discount #1 (defined above) will apply to both books (if
> the order total between the two totals 2-10) since they both match
> criteria specified in the expression.
>
> What we need is for the discount to apply to individual titles, so
> that the user has to order 2 of book C or 2 of book D for the discount
> to apply.  I realize we can do this by setting up a group of quantity
> discounts for each title, but that would be tedious using BizDesk or
> via SQL considering the number of publications we have, any
> suggestions on how to do this?  Is there a simpler way to accomplish
> quantity discounts by item?
>
> Thanks,
> Jennifer

[ Post a follow-up to this message ]

Hi,

How would I go about adding criteria to the current discount system
provided with Commerce Server 'where all condition items must be met
by the same product'?  That would be a perfect solution and Randy's
suggestion would be great as well.  I just want the quickest and
easiest approach.  I am going to have to implement a solution very
soon.

Thanks,
Jennifer


davidme@online.microsoft.com (David Messner [MSFT]) wrote in message news:<wxRjsV4GEHA.
3568@cpmsftngxa06.phx.gbl>...
> That's a really good suggestion Randy.
>
> I wonder, if the discount system simply added an option such as "Where all
> condition items must be the same product", would that have solved your
> problem?
>
> E.g. Buy 100 or more items with publication type = 'XYZ' where all
> condition items must be the same product, then get $5 off publication type
> 'XYZ'.
>
> Would this feature be useful?
>
> -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 right
s
> reserved.
> --------------------
> Reply-To: "Randy Jeppesen" <randywalker75@hotmail.com>
> From: "Randy Jeppesen" <randywalker75@hotmail.com>
> References: <4195d87c.0403151128.82d3cfc@posting.google.com>
> Subject: Re: Quantity discounts per item
> Date: Wed, 17 Mar 2004 16:48:54 -0500
> Lines: 63
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> Message-ID: <OgMVnmGDEHA.2404@TK2MSFTNGP11.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.campaigns_csf
> NNTP-Posting-Host: 207.59.44.13
> Path:
> cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP
08
> .phx.gbl!TK2MSFTNGP11.phx.gbl
> Xref: cpmsftngxa06.phx.gbl
> microsoft.public.commerceserver.campaigns_csf:2576
> X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf
>
> No.
>
> I ran into that problem a few months ago.  There isn't an easy way around
> this short of creating thousands of quantity discount rules in CS2002.  Wh
at
> we ended up doing was this:
>
> We have hundreds of products but only a few quantity discount rules.  So w
e
> added a product definition to the catalog for each item called
> "QuantityDiscountGroup".
>
> Then we created a sql table Called QuantityDiscounts.  The table columns
> were basically:
>     DiscountGroupID
>     Quantity
>     Discount
>
> Then we created a C# pipeline component to adjust the price of the items
> depending on quantity ordered.  The component read the discountgroupid fro
m
> the catalog for the given item, got the quantity from the basket and then
> looked up what the quantity discount should be based on the
> QuantityDiscounts table rules.
>
> We found that this was the best method to solve our problem.  It allowed u
s
> to easily manage the discount rules without affecting any of the other
> CS2002 discounting modules.
>
> Hope this helps.
>
> -Randy
>
>
> "Jennifer" <jdickson@beacontec.com> wrote in message
> news:4195d87c.0403151128.82d3cfc@posting.google.com... 
>
>
>
> --

[ Post a follow-up to this message ]

We looked into that solution.  And we did test a few scenarios.  The problem
with that solution was that you were still forced to create a number of
discount rules for each product which would result in thousands of rules.
Adding and maintaining new and old rules would be very time consuming.  Say
you finally enter all your rules (potentially thousands).  And 3 months
later you want to change a discount level for 300 products.  That's three
hundred rules you have to change verses one simple change in my system.

The solution that I came up with really is a very elegant way to solve a
cumbersome problem.

I hope that Microsoft builds a better mechanism for handling quantity
discounts in the future.  But then again, what is the future of CS2002?  It
doesn't seem to be a "growth" industry for MS right now...

I've built a number of CS2002 pipeline components (from discounts to complex
shipping method selectors to billing) and at one time I thought I would be
able to sell them to other developers.  But lately it seems like the demand
for CS2002 is low that it might not even be worth marketing them!  Is
Microsoft ever going to re-energize this product?

-Randy


"Jennifer" <jdickson@beacontec.com> wrote in message
news:4195d87c.0404071121.2efe6e43@posting.google.com...
> Hi,
>
> How would I go about adding criteria to the current discount system
> provided with Commerce Server 'where all condition items must be met
> by the same product'?  That would be a perfect solution and Randy's
> suggestion would be great as well.  I just want the quickest and
> easiest approach.  I am going to have to implement a solution very
> soon.
>
> Thanks,
> Jennifer
>
>
> davidme@online.microsoft.com (David Messner [MSFT]) wrote in message
news:<wxRjsV4GEHA.3568@cpmsftngxa06.phx.gbl>... 
all 
type 
rights. 
rights 
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
 
around 
What 
we 
from 
then 
us 

[ Post a follow-up to this message ]

It seems like David's proposed solution would eliminate the need, at least
in Jennifer's scenario, for writing discount rules for each product. She
could write a set of discount rules - one for each quantity breakpoint - for
each publisher and include the requirement that the conditions be met by
instances of the same product. It might not meet all scenarios, but it seems
like it would meet a lot of common business requirements. In your scenario,
with David's proposed solution, couldn't you just define discounts per
discount group - products that share a common quantity discount scheme?

Zoe

"Randy Jeppesen" <randywalker75@hotmail.com> wrote in message
news:eA2DpcZHEHA.308@tk2msftngp13.phx.gbl...
> We looked into that solution.  And we did test a few scenarios.  The
problem
> with that solution was that you were still forced to create a number of
> discount rules for each product which would result in thousands of rules.
> Adding and maintaining new and old rules would be very time consuming.
Say
> you finally enter all your rules (potentially thousands).  And 3 months
> later you want to change a discount level for 300 products.  That's three
> hundred rules you have to change verses one simple change in my system.
>
> The solution that I came up with really is a very elegant way to solve a
> cumbersome problem.
>
> I hope that Microsoft builds a better mechanism for handling quantity
> discounts in the future.  But then again, what is the future of CS2002?
It
> doesn't seem to be a "growth" industry for MS right now...
>
> I've built a number of CS2002 pipeline components (from discounts to
complex
> shipping method selectors to billing) and at one time I thought I would be
> able to sell them to other developers.  But lately it seems like the
demand
> for CS2002 is low that it might not even be worth marketing them!  Is
> Microsoft ever going to re-energize this product?
>
> -Randy
>
>
> "Jennifer" <jdickson@beacontec.com> wrote in message
> news:4195d87c.0404071121.2efe6e43@posting.google.com... 
> news:<wxRjsV4GEHA.3568@cpmsftngxa06.phx.gbl>... 
> all 
> type 
> rights. 
> rights 
>
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
 
> around 
> What 
So[vbcol=seagreen]
> we 
columns[vbcol=seagreen] 
items[vbcol=seagreen] 
> from 
> then 
allowed[vbcol=seagreen]
> us 
defined[vbcol=seagreen] 
book[vbcol=seagreen] 
discount[vbcol=seagreen] 
quantity[vbcol=seagreen] 
>
>

[ Post a follow-up to this message ]

Unfortunately you cannot specify 'where all condition items must be met by
the same product' in the current CS2002 discount system.  I was querying if
you (and others) thought that would be a useful feature to deliver in the
future.  You have clearly answered that!

Thanks and good luck
-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: jdickson@beacontec.com (Jennifer)
Newsgroups: microsoft.public.commerceserver.campaigns_csf
Subject: Re: Quantity discounts per item
Date: 7 Apr 2004 12:21:06 -0700
Organization: http://groups.google.com
Lines: 117
Message-ID: <4195d87c.0404071121.2efe6e43@posting.google.com>
References: <4195d87c.0403151128.82d3cfc@posting.google.com>
<OgMVnmGDEHA.2404@TK2MSFTNGP11.phx.gbl>
<wxRjsV4GEHA.3568@cpmsftngxa06.phx.gbl>
NNTP-Posting-Host: 208.0.118.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1081365667 7490 127.0.0.1 (7 Apr 2004 19:21:07
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 7 Apr 2004 19:21:07 +0000 (UTC)
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!news.glorb.com!postnews1.google.com!not-for-mail
Xref: cpmsftngxa06.phx.gbl
microsoft.public.commerceserver.campaigns_csf:2606
X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf

Hi,

How would I go about adding criteria to the current discount system
provided with Commerce Server 'where all condition items must be met
by the same product'?  That would be a perfect solution and Randy's
suggestion would be great as well.  I just want the quickest and
easiest approach.  I am going to have to implement a solution very
soon.

Thanks,
Jennifer


davidme@online.microsoft.com (David Messner [MSFT]) wrote in message
news:<wxRjsV4GEHA.3568@cpmsftngxa06.phx.gbl>...
> That's a really good suggestion Randy.
>
> I wonder, if the discount system simply added an option such as "Where
all
> condition items must be the same product", would that have solved your
> problem?
>
> E.g. Buy 100 or more items with publication type = 'XYZ' where all
> condition items must be the same product, then get $5 off publication
type
> 'XYZ'.
>
> Would this feature be useful?
>
> -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.
> --------------------
> Reply-To: "Randy Jeppesen" <randywalker75@hotmail.com>
> From: "Randy Jeppesen" <randywalker75@hotmail.com>
> References: <4195d87c.0403151128.82d3cfc@posting.google.com>
> Subject: Re: Quantity discounts per item
> Date: Wed, 17 Mar 2004 16:48:54 -0500
> Lines: 63
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> Message-ID: <OgMVnmGDEHA.2404@TK2MSFTNGP11.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.campaigns_csf
> NNTP-Posting-Host: 207.59.44.13
> Path:
>
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
> .phx.gbl!TK2MSFTNGP11.phx.gbl
> Xref: cpmsftngxa06.phx.gbl
> microsoft.public.commerceserver.campaigns_csf:2576
> X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf
>
> No.
>
> I ran into that problem a few months ago.  There isn't an easy way around
> this short of creating thousands of quantity discount rules in CS2002.
What
> we ended up doing was this:
>
> We have hundreds of products but only a few quantity discount rules.  So
we
> added a product definition to the catalog for each item called
> "QuantityDiscountGroup".
>
> Then we created a sql table Called QuantityDiscounts.  The table columns
> were basically:
>     DiscountGroupID
>     Quantity
>     Discount
>
> Then we created a C# pipeline component to adjust the price of the items
> depending on quantity ordered.  The component read the discountgroupid
from
> the catalog for the given item, got the quantity from the basket and then
> looked up what the quantity discount should be based on the
> QuantityDiscounts table rules.
>
> We found that this was the best method to solve our problem.  It allowed
us
> to easily manage the discount rules without affecting any of the other
> CS2002 discounting modules.
>
> Hope this helps.
>
> -Randy
>
>
> "Jennifer" <jdickson@beacontec.com> wrote in message
> news:4195d87c.0403151128.82d3cfc@posting.google.com... 
>
>
>
> --

[ Post a follow-up to this message ]