Working with Price Codes (WPCD)

Price codes allow you to define a price discount for items/SKUs in a specified offer or source code when you order a specified quantity. The price code can offer a dollar or percentage off the price of the item, a special price for the item, or a group price for a defined group of items. The system applies price code pricing to an order during repricing and end-of-order pricing.

Assigning items to price codes: Use Assigning Price Codes (APCD) to assign items to price codes.

Reviewing price code assignments: Use Display Price Code Assignments (DPCA) to review the items/SKUs assigned to a price code by either offer or source code and the requirements that must be met for an order to be eligible for the price code.

Promotions: You can also use price codes as qualifiers for promotions; see Working with Promotions (WPRO) for background.

Types of Price Code Discounting

You can offer the following types of price code discounts:

• Price Code Special Price

• Price Code Dollar Discount

• Price Code Percent Discount

• Price Code Group Price

Price Code Special Price

This discount provides a special price when you order the required quantity of the items/SKUs defined for the price code.

Example: Regular item price is $24.00, but order two or more of the qualifying items and pay $20.00 for each item. See Example: Price Code Special Price Discount for a detailed example.

Price Code Dollar Discount

This discount provides a dollar amount to subtract from the regular item price when you order the required quantity of the items/SKUs defined for the price code.

Example: Order two or more of the qualifying items and receive $2.00 off each item price. See Example: Price Code Dollar Off Discount for a detailed example.

Price Code Percent Discount

This discount provides a percentage to subtract from the regular item price when you order the required quantity of the items/SKUs defined for the price code.

Example: Order two or more of the qualifying items and receive 5% off each item price. See Example: Price Code Percent Off Discount for a detailed example.

Price Code Group Price

This discount provides a group price when you order the required quantity of the items/SKUs defined for the price code. The system prorates the group price across the items on the order that qualify.

Example: Buy a shirt and tie and pay $50.00 total. See Example: Price Code Group Price Discount for a detailed example.

Prorating the group price: The system applies the group price discount to each order line on a pro-rata basis.

extended amount of the detail line before applying discounts / discountable order merchandise total = discount percentage

 

pre-discount unit price of the detail line - [(total discount amounts to prorate * discount percentage from above calculation) / line unit quantity] = unit selling price

 

Example: An order contains the following order lines:

Line#	Quantity	Price	Extended Price
1	1	15.00	15.00
2	1	25.00	25.00

Order lines 1 and 2 qualify for price code 505: $30.00 total for 2.

The merchandise total for the lines before the group price discount is $40.00 (15.00 + 25.00), meaning the group price discount results in $10.00 off the merchandise total.

The system calculates the discount percentage for order line 1: 15.00 order line extended price / 40.00 discountable order merchandise total = .375

The system calculates the unit selling price for order line 1: 15.00 pre-discount unit price - [(10.00 total discount amount to prorate * .375 discount percentage from above calculation) / 1 line unit quantity] = 11.25 unit selling price

The system calculates the discount percentage for order line 2: 25.00 order line extended price / 40.00 discountable order merchandise total = .625

The system calculates the unit selling price for order line 2: 25.00 pre-discount unit price - [(10.00 total discount amount to prorate * .625 discount percentage from above calculation) / 1 line unit quantity] = 18.75 unit selling price

Line#	Quantity	Discounted Price	Extended Price
1	1	11.25	11.25
2	1	18.75	18.75

Allow Multiples?

The Allow Multiples setting defines how an order can qualify for a price code discount multiple times.

• 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 3 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 assigned to the price code in order to qualify. Example: If the Quantity required is 3, the order must contain 3 separate items defined for the price code in order to qualify.

- SKU = The quantity requirement for the price code requires separate SKUs assigned to the price code in order to qualify. Example: If the Quantity required is 3, the order must contain 3 separate SKUs defined for the price code in order to qualify.

- Category = The quantity requirement for the price code requires separate item categories for the items assigned to the price code in order to qualify. Example: If the Quantity required is 3, the order must contain 3 separate item categories for the items defined for the price code in order to qualify.

In this chapter:

• Price Code Setup

• Regular Price Code Pricing

• Regular Price Code Pricing Examples

- 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

• Work with Price Codes Screen

• Create Price Code Screen

• Work with Qualifying Customer/Price Groups Screen

Price Code Setup

Before you can use the price code pricing method, you must:

1. Create a price code.

2. Define the sold to customers and customer price groups that qualify for the price code. If you do not define any sold to customers or customer price groups, then ALL sold to customers and customer price groups qualify for the price code.

3. Assign items, by either offer or source code, to the price code. See Assigning Price Codes (APCD) for more information.

4. Select the Price Codes (D93) system control value to perform price code pricing during repricing and end-of-order pricing.

- If the Customer Price Group Code for CPG Pricing Only (L58) system control value is blank, the system performs Regular Price Code Pricing.

- If the Customer Price Group Code for CPG Pricing Only (L58) system control value contains a customer price group, the system performs Customer Price Group Price Code Pricing.

Price Code upload: The Price Code Upload Table (PriceCdUpload) allows you to upload price code information from an external system. Use the Upload option on the Work with Price Codes Screen to perform the Price Code Upload Process. This process creates, updates, and deletes records in the Price Code, Price Code Customer, and Price Code Details tables. See Price Code Upload for more information.

To manually set up price code information:

1.	Use the Create Price Code Screen to create a price code. • Special Price: Enter the discounted price in the Special price field. If the Tax Included in Price (E70) system control value is selected, define the discounted price for orders subject to VAT in the Tax inclusive price for special price field. • Dollar Off: Enter the dollar off the item price in the Dollar discount field. • Percentage Off: Enter the percentage off the item price in the Percent discount field. • Group Price: Enter the discounted price for the group of items in the Group price field and select the Allow Multiples flag. Use the Distinct By field to define how the system determines whether the order meets the multiple requirement. If the Tax Included in Price (E70) system control value is selected, define the discounted price for orders subject to VAT in the Tax inclusive price for group price field.
2.	Use the Work with Qualifying Customer/Price Groups Screen to define the sold to customers and customer price groups that qualify for the price code. 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.	Use the Work with Price Codes for Offer Screen to assign items, by either offer or source code, to the price code. You can assign more than one price code to each item/offer or item/source combination. If more than one price code applies to an order, the system: • If you use Regular Price Code Pricing, uses the price code with the lowest sequence number. If two price codes have the same sequence number, the system applies the price code with the lowest numeric price code. If order lines remain on the order that are not assigned a price code, the system applies the price code with the next lowest numeric price code, until all of the eligible lines on the order are assigned to a price code. • If you use Customer Price Group Price Code Pricing, uses the price code that provides the greatest discount to the order. If eligible lines remain on the order that are not assigned a price code, the system applies the price code that provides the next greatest discount to the order, until all of the eligible lines on the order are assigned to a price code. Note: Regardless of the sequence number and price code number, price code assignments by source code take precedence over price code assignments by offer. For example, if the items on an order are assigned to price code 10 with a sequence number of 20 by source code, and also assigned to price code 2 with a sequence number of 1 by offer, price code 10 overrides price code 2.