Hi,
I have defined a discount based on categoryname. We have a set up,
where one product can exists in multiple categoires. The discount works
fine if the product exists only in one category. If the product exists
in more than one category, then in some  cases it works and in some
cases it is not working.

Has Any one created this kind of discount ?

Thanks,

Ravi

[ Post a follow-up to this message ]

Hmm, that should work.  The QueryCatalogInfo pipeline component (QCI) will
retrieve the list of all AncestorCategories for the product.  Can you check
that the Ancestor categories as returned by the product catalog API are as
expected (e.g. IProduct3::AncestorCategories property or
Category.AncestorCategoryNames in .NET)?

Also a pipeline log where you have set context._trace_discounts = true
before OrderDiscount executes would be helpful.

-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation.  All rights
reserved.

--------------------
From: "Ravi" <ravisesh_in@indiatimes.com>
Newsgroups:
microsoft.public.commerceserver.campaigns_csf,microsoft.public.commerceserve
r.general,microsoft.public.commerceserver.businessdesk
Subject: Products exisiting in Multiple Categories - Promotion not working.
Date: 9 Mar 2005 11:04:17 -0800
Organization: http://groups.google.com
Lines: 13
Message-ID: <1110395057.695286.165890@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 192.127.94.7
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1110395061 13958 127.0.0.1 (9 Mar 2005 19:04:21
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 9 Mar 2005 19:04:21 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=192.127.94.7;
posting- account=doneMwwAAAAggnovcZGV1dAzRy4LBO8k

Path:
TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fas
twebnet.it!tiscali!newsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.go
ogle.com!g14g2000cwa.googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.commerceserver.general:15737
microsoft.public.commerceserver.businessdesk:6613
microsoft.public.commerceserver.campaigns_csf:3085
X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf

Hi,
I have defined a discount based on categoryname. We have a set up,
where one product can exists in multiple categoires. The discount works
fine if the product exists only in one category. If the product exists
in more than one category, then in some  cases it works and in some
cases it is not working.

Has Any one created this kind of discount ?

Thanks,

Ravi

[ Post a follow-up to this message ]

Thanks for your reply David,
I did set context._trace_discounts = true  before OrderDiscount
executes and was able to view the log files. The reason the discount
was not applied was, the order discount component makes the query to
database using Productid alone. So if the productid is available in
multiple categories, it randomly selects one and that was the reason,
the discount gets applied some time and fails at some time.
I was able to achieve this by doing the following. In the Pipeline,
just before the order discount component, i created a component in
which i make the query to the database by passing the productid and the
categoryname. Based on this i update my discount criteria that i have
defined in Bizdesk. Now it is working perfectly and it is in
Production.

Thanks,

Ravi

[ Post a follow-up to this message ]

Hmmm

OrderDiscount never queries the catalog database.  QueryCatalogInfo (QCI)
does this.  It uses the AncestorCategoryNames of the product to populate
the product._product_categories property in the line item dictionary.  This
is what the discount expressions are then evaluated against.

So I'm not really sure what you're seeing, but I'm glad you were able to
resolve it!

best regards
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation.  All rights
reserved.

--------------------
From: "Ravi" <ravisesh_in@indiatimes.com>
Newsgroups: microsoft.public.commerceserver.campaigns_csf
Subject: Re: Products exisiting in Multiple Categories - Promotion not
working.
Date: 22 Mar 2005 05:51:53 -0800
Organization: http://groups.google.com
Lines: 18
Message-ID: <1111499513.175518.244920@l41g2000cwc.googlegroups.com>
References: <1110395057.695286.165890@g14g2000cwa.googlegroups.com>
<PXtoaYkLFHA.2644@TK2MSFTNGXA02.phx.gbl>
NNTP-Posting-Host: 192.127.94.7
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1111499518 27632 127.0.0.1 (22 Mar 2005
13:51:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 22 Mar 2005 13:51:58 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: l41g2000cwc.googlegroups.com; posting-host=192.127.94.7;
posting- account=doneMwwAAAAggnovcZGV1dAzRy4LBO8k

Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP
08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu
!news.maxwell.syr.edu!postnews.google.com!l41g2000cwc.googlegroups.com!not-f
or-mail
Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.commerceserver.campaigns_csf:3102
X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf

Thanks for your reply David,
I did set context._trace_discounts = true  before OrderDiscount
executes and was able to view the log files. The reason the discount
was not applied was, the order discount component makes the query to
database using Productid alone. So if the productid is available in
multiple categories, it randomly selects one and that was the reason,
the discount gets applied some time and fails at some time.
I was able to achieve this by doing the following. In the Pipeline,
just before the order discount component, i created a component in
which i make the query to the database by passing the productid and the
categoryname. Based on this i update my discount criteria that i have
defined in Bizdesk. Now it is working perfectly and it is in
Production.

Thanks,

Ravi

[ Post a follow-up to this message ]