User Guide
Chapter 9202
Add flat adjustment [type] from [Recordset] schedule based on
[ShoppingCart] data
This is an extension of the related ShoppingCart activation that adds a flat
adjustment to the cart based on how the specified order data parameter compares
to the threshold parameter. In this case, however, the Shopping Cart interacts with
a recordset that contains ranges of the specified order data and associated
adjustment rates. The contract takes the current value of the order data and finds a
corresponding order data range in the recordset. If a corresponding range is found,
the adjustment for that range is applied. This allows you to implement a scaled
adjustment schedule where the adjustment can vary based on multiple ranges in
the order data. As an example, you could allow a $10 discount if someone
purchased between $200 and $500, $20 if they purchase between $500 and
$1000, and $30 if they purchase between $1000 and $10,000.
DrumNote_504 provides examples of this contract in action.
An adjustment in this context represents a fee or discount on the total order. The
threshold parameter represents the amount to which the order data is compared to
determine whether the adjustment is applied, where the order data parameter can
be the total purchase, total weight, or total quantity of the shopping cart. Applied
adjustments can be displayed in the ShoppingCart display.
This contract applies a flat adjustment. A related contract is available to apply
percentage adjustments in this manner. Note that these adjustments are global
to the order and are not relevant to specific line-items in the shopping cart.
Additional contracts are available to provide discounts at the product (that is,
line-item) level.
Parameters:
AdjustmentCol is the column name in the recordset that contains the value of
the flat adjustment for a given range.
AdjustmentName is the name of the adjustment
Type specifies whether the adjustment is a discount or a fee
ShoppingCartData is the shopping cart data used to compare against the
threshold value. This can be total weight, purchase or quantity
MaximumCol is the name of the column in the recordset that stores the
maximum value of the order data for a given adjustment range
MinimumCol is the name of the column in the recordset that stores the
minimum value of the order data for a given adjustment range
Participants:
Recordset
ShoppingCart