Line Level Customer Price Group Pricing | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Customer Price Group Best Price Comparison |
Customer Price Group Price Code Pricing
If a customer price group is defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value and the Price Codes (D93) system control value is selected, the system reevaluates the entire order during repricing to find the best price code price to apply to each qualifying order line.
See When Repricing Occurs for more information on when repricing occurs during interactive order entry.
Source code setting: To do end of order customer price group pricing, the Price method field for the source code on the order header must be set to Reg Plus Reprice.
Note: If the Customer Price Group Code for CPG Pricing Only (L58) system control value does not contain a customer price group code, the system performs Regular Price Code Pricing instead of Customer Price Group Price Code Pricing.
The system performs the following steps during customer price group price code pricing.
• Determine Whether the Order Qualifies for a Price Code
• Apply the Price Code to the Order
• Apply Discounts and Promotions to the Order
Important: Order lines that are assigned to a price code do not qualify for the discount defined for the customer price group assigned to the sold to customer on the order. To apply the customer price group discount to order lines that are assigned to a price code, embed the customer price group discount in the price defined for the price code. Example: If the customer price group provides a 30% discount, create the price code discount so that it includes the 30% discount.
Determine Whether the Order Qualifies for a Price Code
To qualify for a price code:
1. |
The date on the Order Header must fall within the Start date and End date defined for the price code in the Price Code table. You can review the start and end dates for price codes on the Work with Price Codes Screen. |
2. |
The sold to customer on the order must be defined for the price code in the Price Code Customer table. You can review the customers and customer price groups that qualify for a price code on the Work with Qualifying Customer/Price Groups Screen. Note: If you do not define any sold to customers or customer price groups for a price code, then ALL sold to customers and customer price groups qualify for the price code. |
3. |
The items on the order must be assigned to the price code and meet the price code requirements. Which items are assigned to the price code? The system looks at the Price Code Details table to determine which items on the order are assigned to the price code. When assigning an item to a price code, you assign the item to the price code by offer or source code. The system uses the source code on the order header to determine whether the item on the order qualifies for the price code. • If the item contains SKUs and a SKU is not defined in the Price Code Details table, all SKUs for the item qualify for the price code. • If the item contains SKUs and a SKU is defined in the Price Code Details table, only the specified SKUs qualify for the price code. |
|
Price code requirements: The system looks at the Price Code table to determine if the items on the order that are assigned to the price code meet the price code requirements. Quantity required: The total quantity the customer must order of all qualifying items to get the price break. Note: The system evaluates price code quantity by ship-to address. Allow multiples? • Unselected = Once an order qualifies for the price code based on the price code quantity requirement, the system applies the price code discount to all qualifying items on the order that are not already assigned to a price code. • Selected = Once an order qualifies for the price code based on the price code quantity requirement, the remaining items on the order that are not already assigned to a price code must meet the price code quantity requirement again in order to qualify for the price code. The Distinct By setting defines how the system determines whether the order meets the price code multiple requirement. Distinct By: • Blank = The order must meet the price code quantity requirement again in order to qualify. Example: If the Quantity required is 3, the order must contain three items/SKUs defined for the price code in order to qualify. If the order contains 7 items that qualify, the system applies the price code to 6 of the items. • Item = The quantity requirement for the price code requires separate items in order to qualify. Example: If the Quantity required is 3, the order must contain three separate items defined for the price code in order to qualify. • SKU = The quantity requirement for the price code requires separate SKUs in order to qualify. Example: If the Quantity required is 3, the order must contain three separate SKUs defined for the price code in order to qualify. • Category = The quantity requirement for the price code requires separate item categories in order to qualify. Example: If the Quantity required is 3, the order must contain three separate item categories for the items defined for the price code in order to qualify. For more information: See Examples: Customer Price Group Price Code Pricing for examples of how price codes are applied to an order based on the price code requirements. |
Apply the Price Code to the Order
You can apply only one price code to an order line.
Best way price code hierarchy: If an order qualifies for more than one price code and you are using Customer Price Group Price Code Pricing, the system calculates the discount that each price code provides and:
1. Applies the price code that provides the greatest discount to the qualifying items on the order.
2. If more than one price code offers the same discount, the system uses the price code with the lowest Sequence number.
3. If more than one price code has the same sequence number, the system uses the price code with the lowest numeric price code.
The system applies the price code to the lines on an order in ascending price, order line number sequence.
Once you apply a price code to an order line, it no longer qualifies for another price code.
Starting price: When calculating the price code discount, the system starts with the initial price defined for the order line. This is the price of the item determined during Line Level Customer Price Group Pricing and stored in the ODT Price field.
After the system applies the first price code to the order, the system reevaluates the order to determine if it qualifies for another price code. The system applies the next price code that provides the greatest discount to the order in ascending price, order line number sequence.
The system continues to apply price codes to the order, using the best way price code hierarchy, in ascending price, order line number sequence, until all of the eligible lines on the order are assigned to a price code.
Applying a price code to a portion of an order line: To easily determine the price code discount applied to the lines on an order, enter each order line for a quantity of 1. If an order line contains a quantity greater than 1 and only part of the quantity on the order line qualifies for the discount, the system applies the discount to the quantity that qualifies for the discount and leaves the remaining quantity on the order line at its initial price. The extended price of the order line represents the discounted quantity price + the non-discounted quantity price.
Partial price code line example: An order line qualifies for a price code discount: $3.00 off 2. The Multiples field is selected for the price code, indicating the order must meet the price code requirement again to apply the price code to the order multiple times. The order line quantity is 3 with a unit price of 10.00. The system applies the price code discount to 2 units of the item (10.00 - 3.00 = 7.00). The third unit remains priced at 10.00. The extended price for the order line is 24.00 (7.00 + 7.00 + 10.00) and the unit price for the order line is 8.00 (24.00 / 3).
Note: There may be a rounding discrepancy if the extended price of an order line does not divide evenly by the order quantity. This discrepancy should be no more than a few pennies. Example: Change the discount in the example above from $3.00 off 2 to $2.00 off 2. The order line quantity is 3 with a unit price of 10.00. The system applies the price code discount to 2 units of the item (10.00 - 2.00 = 8.00). The third unit remains priced at 10.00. The extended price for the order line is 26.01 and the unit price is 8.67 (26.00 / 3 = 8.666, which rounds to 8.67; 8.67 + 8.67 + 8.67 = 26.01).
Price method: The system updates the Price method for any order line whose price was updated during customer price group price code pricing to E Price Code.
Order lines not eligible for price code discounts:
• Price code repricing does not apply to manually priced order lines associated with a price override reason code.
• Order lines that are assigned to the price override reason code defined in the Price Override Reason Code for CPG Pricing (L59) system control value cannot be further discounted except by order-level coupons or source% discounts. However, the system includes the dollar amount and quantity for order lines assigned to the Customer Price Group price override reason code in the eligibility calculations as qualifiers for promotions and price code pricing that may apply to other items on the order.
Apply Discounts and Promotions to the Order
Discounts and promotions: Once the system completes customer price group price code pricing, the system applies any non-freight discounts, detail-level coupon promotions, and any other promotions to the lines on the order.
Determining the best price: If the Best Price Comparison field for the customer price group assigned to the sold to customer is selected, the system performs Customer Price Group Best Price Comparison to determine if the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value provides a better price than the customer price group assigned to the sold to customer on the order.
Order-level coupon promotions: When using customer price group pricing, the system applies order-level coupon promotions, as defined in Working with Coupon Promotions (WCPR), as the last discount applied to the lines on the order. See Order-Level Coupon Promotions when using Customer Price Group Pricing for further details.
Examples: Customer Price Group Price Code Pricing
• Example: Price Code Special Price Discount
• Example: Price Code Dollar Off Discount
• Example: Price Code Percent Off Discount
• Example: Price Code Group Price Discount
• Example: Applying Multiple Price Codes to the Order
• Example: Item Qualifies for More than One Price Code
• Example: Price Code Multiples and Distinct By
Example: Price Code Special Price Discount
On 2/17/12, you take an order for sold to customer 10.
Source Code |
Line# |
Item |
Quantity |
Price |
7 |
1 |
A1 |
1 |
$10.00 |
2 |
B1 |
2 |
$20.00 |
|
3 |
C1 |
3 |
$30.00 |
|
4 |
D1 |
4 |
$40.00 |
Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:
Price Code |
Seq |
Start |
End |
Qty |
Type of Price Code Discount |
101 |
4 |
2/1/12 |
4/1/12 |
1 |
Dollar off: $2 off 1 |
202 |
3 |
2/1/12 |
4/1/12 |
2 |
Percent off: 10% off 2 |
303 |
2 |
2/1/12 |
4/1/12 |
3 |
Special price: $20.00 each for 3 |
404 |
1 |
2/1/12 |
4/1/12 |
3 |
Group price: $60.00 total for 3 |
Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:
Price Code |
Customer# |
Customer Price Group |
303 |
10 |
|
Determine price code item assignment: The item on the order that qualifies for price code 303 in the Price Code Details table is:
Price Code |
Item |
SKU |
Source Code |
303 |
C1 |
|
7 |
Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:
Line# |
Item |
Initial Price |
Price Code |
Reprice |
1 |
A1 |
$10.00 |
none |
Price remains $10.00 |
2 |
B1 |
$20.00 |
none |
Price remains $20.00 |
3 |
C1 |
$30.00 |
303 |
Special price: $20.00 each for 3 Price changes from $30.00 to $20.00 |
4 |
D1 |
$40.00 |
none |
Price remains $40.00 |
Because the calculated order line price for item C1 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 3:Offer = 30.00 Actual = 20.00 Discount = 10.00 :33.33%
Example: Price Code Dollar Off Discount
On 2/17/12, you take an order for sold to customer 10.
Source Code |
Line# |
Item |
Quantity |
Price |
7 |
1 |
A1 |
1 |
$10.00 |
2 |
B1 |
2 |
$20.00 |
|
3 |
C1 |
3 |
$30.00 |
|
4 |
D1 |
4 |
$40.00 |
Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:
Price Code |
Seq |
Start |
End |
Qty |
Type of Price Code Discount |
101 |
4 |
2/1/12 |
4/1/12 |
1 |
Dollar off: $2 off 1 |
202 |
3 |
2/1/12 |
4/1/12 |
2 |
Percent off: 10% off 2 |
303 |
2 |
2/1/12 |
4/1/12 |
3 |
Special price: $20.00 each for 3 |
404 |
1 |
2/1/12 |
4/1/12 |
3 |
Group price: $60.00 total for 3 |
Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:
Price Code |
Customer# |
Customer Price Group |
101 |
10 |
|
Determine price code item assignment: The item on the order that qualifies for price code 101 in the Price Code Details table is:
Price Code |
Item |
SKU |
Source Code |
101 |
A1 |
|
7 |
Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:
Line# |
Item |
Initial Price |
Price Code |
Reprice |
1 |
A1 |
$10.00 |
101 |
Dollar off: $2.00 off 1 Price changes from $10.00 to $8.00 |
2 |
B1 |
$20.00 |
none |
Price remains $20.00 |
3 |
C1 |
$30.00 |
none |
Price remains $30.00 |
4 |
D1 |
$40.00 |
none |
Price remains $40.00 |
Because the calculated order line price for item A1 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 1:Offer = 10.00 Actual = 8.00 Discount = 2.00 :20.00%
Example: Price Code Percent Off Discount
On 2/17/12, you take an order for sold to customer 10.
Source Code |
Line# |
Item |
Quantity |
Price |
7 |
1 |
A1 |
1 |
$10.00 |
2 |
B1 |
2 |
$20.00 |
|
3 |
C1 |
3 |
$30.00 |
|
4 |
D1 |
4 |
$40.00 |
Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:
Price Code |
Seq |
Start |
End |
Qty |
Type of Price Code Discount |
101 |
4 |
2/1/12 |
4/1/12 |
1 |
Dollar off: $2 off 1 |
202 |
3 |
2/1/12 |
4/1/12 |
2 |
Percent off: 10% off 2 |
303 |
2 |
2/1/12 |
4/1/12 |
3 |
Special price: $20.00 each for 3 |
404 |
1 |
2/1/12 |
4/1/12 |
3 |
Group price: $60.00 total for 3 |
Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:
Price Code |
Customer# |
Customer Price Group |
202 |
10 |
|
Determine price code item assignment: The item on the order that qualifies for price code 202 in the Price Code Details table is:
Price Code |
Item |
SKU |
Source Code |
202 |
B1 |
|
7 |
Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:
Line# |
Item |
Initial Price |
Price Code |
Reprice |
1 |
A1 |
$10.00 |
none |
Price remains $10.00 |
2 |
B1 |
$20.00 |
202 |
Percent off: 10% off 2 Price changes from $20.00 to 18.00 |
3 |
C1 |
$30.00 |
none |
Price remains $30.00 |
4 |
D1 |
$40.00 |
none |
Price remains $40.00 |
Because the calculated order line price for item A1 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 2:Offer = 20.00 Actual = 18.00 Discount = 2.00 :10.00%
Example: Price Code Group Price Discount
On 2/17/12, you take an order for sold to customer 10.
Source Code |
Line# |
Item |
SKU |
Quantity |
Price |
7 |
1 |
SKA |
RED |
1 |
$40.00 |
2 |
SKB |
BLUE |
1 |
$20.00 |
|
3 |
SKC |
GRN |
1 |
$30.00 |
|
4 |
SKD |
GREY |
1 |
$40.00 |
Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:
Price Code |
Seq |
Start |
End |
Qty |
Type of Price Code Discount |
101 |
4 |
2/1/12 |
4/1/12 |
1 |
Dollar off: $2 off 1 |
202 |
3 |
2/1/12 |
4/1/12 |
2 |
Percent off: 10% off 2 |
303 |
2 |
2/1/12 |
4/1/12 |
3 |
Special price: $20.00 each for 3 |
404 |
1 |
2/1/12 |
4/1/12 |
3 |
Group price: $60.00 total for 3 |
Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:
Price Code |
Customer# |
Customer Price Group |
404 |
10 |
|
Determine price code item assignment: The items on the order that qualify for price code 404 in the Price Code Details table are:
Price Code |
Item |
SKU |
Source Code |
404 |
SKA |
|
7 |
404 |
SKB |
|
7 |
404 |
SKC |
|
7 |
404 |
SKD |
|
7 |
Note: If an item contains SKUs and no SKUs are defined for the item in the Price Code Details table, all SKUs for the item qualify for the price code.
Reprice the order: When you select Reprice at the Order Detail screen, the system reprices in ascending price, order line number sequence
Line# |
Item |
SKU |
Initial Price |
Price Code |
Reprice |
2 |
SKB |
BLUE |
$20.00 |
404 |
Group price: $60.00 total for 3 Price changes from $20.00 to $13.33 |
3 |
SKC |
GRN |
$30.00 |
404 |
Group price: $60.00 total for 3 Price changes from $30.00 to $20.00 |
1 |
SKA |
RED |
$40.00 |
404 |
Group price: $60.00 total for 3 Price changes from $40.00 to $26.67 |
4 |
SKD |
GREY |
$40.00 |
none |
Price remains $40.00 |
merchandise total for lines assigned to price code 404 = $90.00 $90.00 merchandise total - $60.00 group price = $30.00 discount amount to prorate |
Note: Order line 4 does not qualify for the price code 404 discount because you must order the qualifying items in groups of 3. If the customer ordered 2 more qualifying items, the order would qualify for the price code 404 discount two times because it would have two qualifying groups of 3 on the order.
The system applies the group price discount to each qualifying order line on a pro-rata basis.
Order line 2 calculations:
20.00 extended amount of the detail line before applying discounts / 90.00 discountable order merchandise total = .2222 discount percentage
20.00 pre-discount unit price of the detail line - [(30.00 total discount amount to prorate * .2222 discount percentage from above calculation) / 1 line unit quantity] = 13.33 unit selling price
Order line 3:
30.00 extended amount of the detail line before applying discounts / 90.00 discountable order merchandise total = .3333 discount percentage
30.00 pre-discount unit price of the detail line - [(30.00 total discount amount to prorate * .3333 discount percentage from above calculation) / 1 line unit quantity] = 20.00 unit selling price
Order line 1:
40.00 extended amount of the detail line before applying discounts / 90.00 discountable order merchandise total = .4444 discount percentage
40.00 pre-discount unit price of the detail line - [(30.00 total discount amount to prorate * .4444 discount percentage from above calculation) / 1 line unit quantity] = 26.67 unit selling price
Discount message: Because the calculated order line price for lines 1-3 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 3:Offer = 30.00 Actual = 20.00 Discount = 10.00 :33.33%
Example: Applying Multiple Price Codes to the Order
On 2/17/12, you take an order for sold to customer 10.
Source Code |
Line# |
Item |
Quantity |
Price |
7 |
1 |
A1 |
1 |
$10.00 |
2 |
B1 |
2 |
$20.00 |
|
3 |
C1 |
3 |
$30.00 |
|
4 |
D1 |
3 |
$40.00 |
Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:
Price Code |
Seq |
Start |
End |
Qty |
Type of Price Code Discount |
101 |
4 |
2/1/12 |
4/1/12 |
1 |
Dollar off: $2 off 1 |
202 |
3 |
2/1/12 |
4/1/12 |
2 |
Percent off: 10% off 2 |
303 |
2 |
2/1/12 |
4/1/12 |
3 |
Special price: $20.00 each for 3 |
404 |
1 |
2/1/12 |
4/1/12 |
3 |
Group price: $60.00 total for 3 |
Determine price code customer assignment: The sold to customer on the order qualifies for the following price codes in the Price Code Customer table:
Price Code |
Customer# |
Customer Price Group |
101 |
10 |
|
202 |
10 |
|
303 |
10 |
|
404 |
10 |
|
Determine price code item assignment: The details in the Price Code Details table for the items on the order are:
Price Code |
Item |
SKU |
Source Code |
101 |
A1 |
|
7 |
202 |
B1 |
|
7 |
303 |
C1 |
|
7 |
404 |
D1 |
|
7 |
Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:
Line# |
Item |
Initial Price |
Price Code |
Reprice |
1 |
A1 |
$10.00 |
101 |
Dollar off: $2 off 1 Price changes from $10.00 to $8.00 |
2 |
B1 |
$20.00 |
202 |
Percent off: 10% off 2 Price changes from $20.00 to 18.00 |
3 |
C1 |
$30.00 |
303 |
Special price: $20.00 each for 3 Price changes from $30.00 to $20.00 |
4 |
D1 |
$40.00 |
404 |
Group price: $60.00 total for 3 Price changes from $40.00 to $20.00 |
Example: Item Qualifies for More than One Price Code
On 2/17/12, you take an order for sold to customer 10.
Source Code |
Line# |
Item |
SKU |
Quantity |
Price |
7 |
1 |
SKA |
RED |
1 |
$40.00 |
2 |
SKA |
BLUE |
1 |
$40.00 |
|
3 |
SKB |
GRN |
1 |
$20.00 |
|
4 |
SKC |
GREY |
1 |
$30.00 |
|
5 |
SKD |
BLCK |
1 |
$40.00 |
Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:
Price Code |
Seq |
Start |
End |
Qty |
Type of Price Code Discount |
101 |
4 |
2/1/12 |
4/1/12 |
1 |
Dollar off: $2 off 1 |
202 |
3 |
2/1/12 |
4/1/12 |
2 |
Percent off: 10% off 2 |
404 |
1 |
2/1/12 |
4/1/12 |
3 |
Group price: $60.00 total for 3 |
Determine price code customer assignment: The sold to customer on the order qualifies for the following price codes in the Price Code Customer table:
Price Code |
Customer# |
Customer Price Group |
101 |
10 |
|
202 |
10 |
|
404 |
10 |
|
Determine price code item assignment: The details in the Price Code Details table for the items on the order are:
Price Code |
Item |
SKU |
Source Code |
101 |
SKA |
|
7 |
101 |
SKB |
|
7 |
101 |
SKC |
|
7 |
101 |
SKD |
|
7 |
202 |
SKA |
|
7 |
202 |
SKB |
|
7 |
202 |
SKC |
|
7 |
202 |
SKD |
|
7 |
404 |
SKA |
|
7 |
404 |
SKB |
|
7 |
404 |
SKC |
|
7 |
404 |
SKD |
|
7 |
Note: If an item contains SKUs and no SKUs are defined for the item in the Price Code Details table, all SKUs for the item qualify for the price code.
Important: You can apply only one price code to an order line. If an order line qualifies for more than one price code and you are using Customer Price Group Price Code Pricing, the system uses the price code that provides the greatest discount. If more than one price code offers the same discount, the system uses the price code with the lowest Sequence number. If more than one price code has the same sequence number, the system uses the price code with the lowest numeric price code.
Reprice the order: When you select Reprice at the Order Detail screen, the system reprices the lines on the order in ascending price, order line number sequence.
Of the price codes that were eligible to apply to the order, price code 404 provided the greatest discount. Because the Multiples field for price code 404 was selected, only the first 3 order lines in ascending price, order line number sequence were eligible for the price code; the remaining order lines did not meet the quantity requirement for price code 404. The system assigned the next price code with the greatest discount (price code 202) to the two remaining items on the order.
Line# |
Item |
SKU |
Initial Price |
Price Code |
Reprice |
The system applies price code 404 to order lines 3, 4 and 1. See Prorating the Group Price for the calculations the system uses to determine the price of each order line assigned to the group price. |
|||||
3 |
SKB |
GRN |
$20.00 |
404 |
Group price: $60.00 total for 3 Price changes from $20.00 to $13.33 |
4 |
SKC |
GREY |
$30.00 |
404 |
Group price: $60.00 total for 3 Price changes from $30.00 to $20.00 |
1 |
SKA |
RED |
$40.00 |
404 |
Group price: $60.00 total for 3 Price changes from $40.00 to $26.67 |
The system applies price code 202 to order lines 2 and 5: |
|||||
2 |
SKA |
BLUE |
$40.00 |
202 |
Percent off: 10% off 2 Price changes from $40.00 to 36.00 |
5 |
SKD |
BLCK |
$40.00 |
202 |
Percent off: 10% off 2 Price changes from $40.00 to 36.00 |
Discount message: Because the calculated order line price for the order lines is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 4:Offer = 30.00 Actual = 20.00 Discount = 10.00 :33.33%
Example: Price Code Multiples and Distinct By
On 2/17/12, you take an order for sold to customer 10.
Source Code |
Line# |
Item |
SKU |
Item Category |
Quantity |
Price |
7 |
1 |
SKA |
SML |
A |
1 |
$10.00 |
2 |
SKA |
SML |
A |
1 |
$10.00 |
|
3 |
SKB |
SML |
B |
1 |
$10.00 |
|
4 |
SKC |
SML |
C |
1 |
$10.00 |
|
5 |
SKD |
SML |
D |
1 |
$10.00 |
|
6 |
SKD |
MED |
D |
1 |
$10.00 |
|
7 |
SKD |
LRG |
D |
1 |
$10.00 |
Determine eligible price codes: The order and customer qualify for price code 202 in the Price Code table:
Price Code |
Seq |
Start |
End |
Qty |
Price Code Discount |
202 |
3 |
2/1/12 |
4/1/12 |
2 |
Percent off: 10% off 2 |
Determine price code item assignment: The details in the Price Code Details table for the items on the order are:
Price Code |
Item |
SKU |
Source Code |
202 |
SKA |
|
7 |
202 |
SKB |
|
7 |
202 |
SKC |
|
7 |
202 |
SKD |
|
7 |
Reprice the order: When you select Reprice at the Order Detail screen, the system reprices the lines on the order in ascending price, order line number sequence.
• Multiples Selected, Distinct By Blank
• Multiples Selected, Distinct By Item
• Multiples Selected, Distinct By SKU
• Multiples Selected, Distinct By Item Category
Because Multiples for price code 202 is unselected, once the order qualifies for the price code based on the price code quantity requirement, the system applies price code 202 to all qualifying items on the order that are not already assigned to a price code.
Line# |
Item |
SKU |
Initial Price |
Price Code |
Reprice |
The system applies price code 202 to order lines 1 and 2: |
|||||
1 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
2 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
Now that the order qualifies for price code 202, the system applies price code 202 to all qualifying items on the order that are not already assigned to a price code: |
|||||
3 |
SB |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
4 |
SC |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
5 |
SD |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
6 |
SD |
MED |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
7 |
SD |
LRG |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
Multiples Selected, Distinct By Blank
Because Multiples for price code 202 is selected and the Distinct By is blank, the order must meet the price code quantity requirement again in order to qualify.
Line# |
Item |
SKU |
Initial Price |
Price Code |
Reprice |
The system applies price code 202 to order lines 1 and 2: |
|||||
1 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
2 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
The system then applies price code 202 to order lines 3 and 4: |
|||||
3 |
SB |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
4 |
SC |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
The system then applies price code 202 to order lines 5 and 6: |
|||||
5 |
SD |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
6 |
SD |
MED |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
Order line 7 does not qualify since it does not meet the price code quantity requirement of 2. |
|||||
7 |
SD |
LRG |
$10.00 |
none |
Remains $10.00 |
Multiples Selected, Distinct By Item
Because Multiples for price code 202 is selected and the Distinct By is Item, the price code requires separate items in the required quantity in order to qualify.
Line# |
Item |
SKU |
Initial Price |
Price Code |
Reprice |
The system applies price code 202 to order lines 1 and 3: |
|||||
1 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
3 |
SB |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
The system then applies price code 202 to order lines 2 and 4: |
|||||
2 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
4 |
SC |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
Order lines 5, 6 and 7 do not qualify for price code 202 since they do not meet the price code quantity requirement of 2 by item. |
|||||
5 |
SD |
SML |
$10.00 |
none |
Remains $10.00 |
6 |
SD |
MED |
$10.00 |
none |
Remains $10.00 |
7 |
SD |
LRG |
$10.00 |
none |
Remains $10.00 |
Multiples Selected, Distinct By SKU
Because Multiples for price code 202 is selected and the Distinct By is SKU, the price code requires separate SKUs in the required quantity in order to qualify.
Line# |
Item |
SKU |
Initial Price |
Price Code |
Reprice |
The system applies price code 202 to order lines 1 and 3: |
|||||
1 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
3 |
SB |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
The system then applies price code 202 to order lines 2 and 4: |
|||||
2 |
SA |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
4 |
SC |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
The system then applies price code 202 to order lines 5 and 6: |
|||||
5 |
SD |
SML |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
6 |
SD |
MED |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
Order line 7 does not qualify since it does not meet the price code quantity requirement of 2 by SKU. |
|||||
7 |
SD |
LRG |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
Multiples Selected, Distinct By Item Category
Because Multiples for price code 202 is selected and the Distinct By is Item Category, the price code requires separate item categories in the required quantity in order to qualify.
Line |
Item |
SKU |
Category |
Initial Price |
Price Code |
Reprice |
The system applies price code 202 to order lines 1 and 3: |
||||||
1 |
SA |
SML |
A |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
3 |
SB |
SML |
B |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
The system then applies price code 202 to order lines 2 and 4: |
||||||
2 |
SA |
SML |
A |
$10.00 |
none |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
4 |
SC |
SML |
C |
$10.00 |
202 |
Percent off: 10% off 2 Price changes from $10.00 to $9.00 |
Order lines 5, 6 and 7 do not qualify for price code 202 since they do not meet the price code quantity requirement of 2 by item category. |
||||||
5 |
SD |
SML |
D |
$10.00 |
none |
Remains $10.00 |
6 |
SD |
MED |
D |
$10.00 |
none |
Remains $10.00 |
7 |
SD |
LRG |
D |
$10.00 |
none |
Remains $10.00 |