Commerce Server General - Is there way to retrieve the number of times a particular discount was applied?

Author

Is there way to retrieve the number of times a particular discount was applied?

Jason Sirota

2004-07-12, 5:51 pm

I apologize if this question has been asked before but our marketing
group would like to be able to tell how many times a particular
discount has been applied. We're using CS2K2 FP1. I'm assuming this is
stored somewhere because the OrderDiscount pipeline stage must use it
to track the limits.

Is there any way to retrieve this data programatically?

Thanks!
Jason

Andy Xu[MSFT]

2004-07-12, 5:51 pm

Jason,

in fact (and unfortunately), CS2K2 doesn't expose this piece of information. It is good to help that business world needs that and it should help us to justify the need to expose more information on discount applied
record.

Using currect discount engine, you can somehow calculate the applied times (in some cases). -- for each basket line item, we stored discount applied information; and for OrderForm, we stored orderlevel
discount information. You can get how much exactly money amount is taken off from that line item. From that and discount defintion, you can do some tricks.

But again, it does NOT work in some scenarios. For example, if different discounts are applied to same basket line item, the latter one, if it is a percentage discount, the money off is hard to predict. (10% does not
mean 10% of item original price, but 10% off the already discounts price after the first discount). And some time is the discounted value is bigger than the remaining price, the real discount amount is not the same
thing as definition. (we won't mark negative prices, right :-)) Hopefully, your scenarios are not those complicated ones.

HTH,
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
From: jasonsirota@gmail.com (Jason Sirota)
Newsgroups: microsoft.public.commerceserver.general
Subject: Is there way to retrieve the number of times a particular discount was applied?
Date: 12 Jul 2004 13:17:16 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <12e66dac.0407121217.148ee94f@posting.google.com>
NNTP-Posting-Host: 216.103.134.129
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1089663437 27211 127.0.0.1 (12 Jul 2004 20:17:17 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 12 Jul 2004 20:17:17 +0000 (UTC)
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!fr.ip.ndsoftware.net!proxad.net!postnews2.google.com!not-for-mail
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.general:14232
X-Tomcat-NG: microsoft.public.commerceserver.general

I apologize if this question has been asked before but our marketing
group would like to be able to tell how many times a particular
discount has been applied. We're using CS2K2 FP1. I'm assuming this is
stored somewhere because the OrderDiscount pipeline stage must use it
to track the limits.

Is there any way to retrieve this data programatically?

Thanks!
Jason

Jason Sirota

2004-07-13, 5:51 pm

They are not as complicated. For the first phase of our discount
system, we're only going to allow 1 discount per variant, so we hope
we don't have to deal with the complicated concepts of interaction.

I ended up using our custom-built inventory system for the discounts,
recording the purchase of a discount as a purchase of a separate
product. Since the Discount ID's start at 1,000,000,000, the ids
shouldn't overlap (thank you for that).

Thanks for the quick response as usual.

Jason

Jason Sirota

2004-07-13, 5:51 pm