OrderDiscount Does Not Apply Correct Discounts to Basket When the Quantity Is Greater than the Discount Buy Set (304605)

The information in this article applies to:

Microsoft Commerce Server 2000 SP1

This article was previously published under Q304605

SYMPTOMS

When you configure a Discount campaign so that a user who buys three products, receives the fourth product free, if more than four items are added to the basket, the item with the lowest price does not have a new cost of $0.00. Everything works correctly when the user selects four items.

CAUSE

There are default sort orders for the condition sort and award sort. The default sort order for condition sort is PQBI (highest price first, then quantity, and then basket index). The default sort order for award sort is the same, except items that are in both the condition set and the award set are last.

WORKAROUND

You can control the sort order by adding columns for condition_sort and award_sort to the discount contentlist cache. You can do this by overriding the query used by CSFLoadDiscounts and setting a value for query on the config dictionary for the discount cache loader. The values currently defined are:

0 = Decreasing by price, decreasing by quantity, basket index
1 = Version 2.0 compatibility sort
2 = Items in both condition and award last, then PQBI sort

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Commerce Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

297216 INFO: How to Obtain the Latest Commerce Server 2000 Service Pack

The English version of this fix should have the following file attributes or later:

   Date         Time   Version        File name
   -------------------------------------------------
   10-Sep-2001  21:28  04.00.2056.00  Stdretcomp.dll

STATUS

Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000. This problem was first corrected in Microsoft Commerce Server 2000 Service Pack 2.

MORE INFORMATION

This hotfix adds a new award sort order.

To use this hotfix, you must place the Global_cache_lib.asp file that is packaged with this fix into the include directory for the site that is using this feature.

Modification Type:	Minor	Last Reviewed:	9/23/2005
Keywords:	kbHotfixServer kbQFE kbbug kbCommServ2000preSP2fix kbCommServ2000SP2fix kbfix KB304605