Oracle Retail Price Management (RPM) – Various Possible Promotions & Clearances Supported by RPM

Hello again Oracle Retail fans. This article is the continuation of our parent article on Oracle Retail Pricing Management (RPM – Deep Dive Tutorial). In any RPM Implementation or in regular support too, many a time, we come across to a situation where we ask ourselves that whether any particular type of Promotion or Clearance is supported by RPM or not. It is more frequently discussed particularly for Promotions. And that has prompted me to write this article.

I this article, I’m going to list down various possible types of Promotions and Clearances that RPM supports and can be created through the base application (out of the box). Please do let me know if I missed any specific scenario and needs to be added here. This article also answers, how to set up each of those promotions and clearances in RPM so you need not to look any further. 

Please do note that the promotions listed here are from RPM point of view, not for any downstream applications. If Oracle POS or any other POS, Store Applications are used, we need to check the integration compatibility and support viability of all below promotions according to those application's specifications.

I've listed down all scenarios  mainly into below 4 categories:

1.     Simple Promotions

2.     Multi-Buy Promotions

3.     Threshold Promotions

4.     Clearances

#	Promotion Type	POS Promotion Type	Example	The Price Management System Setup	Supported by RPM?
1	Simple	Fixed Price	Buy X, get X for $15	Fixed Amount	Yes
2	Simple	Percent Off	Buy X, get X for 10% off	% off	Yes
3	Simple	Amount Off	Buy X, get $10 off of X	Amount off	Yes
4	Multi-Buy	Buy N of X, Get Y at Z% off regular Price.	Buy two pairs of jeans, get a sweater at 50% off.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type=Reward List	Yes
5	Multi-Buy	Buy N of X, Get Y at Z$ off regular Price	Buy two pairs of jeans, get $10 off of a sweater.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type=Reward List	Yes
6	Multi-Buy	Buy N of X, Get Y at Z$ .	Buy two pairs of jeans, get a sweater for $20	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type=Reward List	Yes
7	Multi-Buy	Buy $N of X, Get Y at Z% off regular Price	Buy $40 worth of jeans, get a sweater at 50% off.	Buy Type = Amount, Reward % Off, Buy Value = N, Reward List Type=Reward List	Yes
8	Multi-Buy	Buy $N of X, Get Y at Z$ off regular Price.	Buy $40 worth of jeans, get $10 off of a sweater.	Buy Type = Amount, Reward Amount Off, Buy Value = N, Reward List Type=Reward List	Yes
9	Multi-Buy	Buy $N of X, Get Y at Z$.	Buy $40 worth of jeans, get a sweater for $20	Buy Type = Amount, Reward Fixed Price, Buy Value = N, Reward List Type = Reward List	Yes
10	Multi-Buy	Buy N of All Items in X Item List, Get Y at Z% off regular Price.	Buy two pairs of jeans and shirt, get a sweater at 50% off.	Buy Type = All Reward %off, Buy Value = N, Reward List Type=Reward List	Yes
11	Multi-Buy	Buy N of All Items in X Item List, Get Y at Z$ off regular Price	Buy two pairs of jeans and shirt, get $10 off of a sweater.	Buy Type = All, Reward Amount off, Buy Value = N, Reward List Type=Reward List	Yes
12	Multi-Buy	Buy N of All Items in X Item List, Get Y at Z$ .	Buy two pairs of jeans and shirt, get a sweater for $20	Buy Type = All, Reward Fixed Amount, Buy Value = N, Reward List Type=Reward List	Yes
13	Multi-Buy	Buy N of All Items in X Item List, Get Cheapest in Y Free	Buy Four pairs of jeans and shirt, get cheapest free	Buy Type = All, Reward Cheapest Free, Buy Value = N, Reward List Type=Reward List	Yes
14	Multi-Buy	Buy N of All Items in X Item List, Get $M Value Y Free	Buy Four pairs of jeans and shirt, get $10 Cap free	Buy Type = All, Reward Cheapest Free, Buy Value = N, Reward List Type=Reward List, Reward Type=Amount, Reward Value=M or Buy Type = All, Reward % Off (100), Buy Value = N, Reward List Type=Reward List, Reward Type=Amount, Reward Value=M	Yes
15	Multi-Buy	Buy $N of All items in X Item List, Get Y at Z% off regular Price	Buy $40 worth of jeans and shirt, get a sweater at 50% off.	Buy Type = Amount, Reward % Off, Buy Value = N, Reward List Type=Reward List	Yes
16	Multi-Buy	Buy $N of All Items in X Item List, Get Y at Z$ off regular Price.	Buy $40 worth of jeans and shirt, get $10 off of a sweater.	Buy Type = Amount, Reward Amount Off, Buy Value = N, Reward List Type=Reward List	Yes
17	Multi-Buy	Buy $N of All Items in X Item List, Get Y at Z$.	Buy $40 worth of jeans and shirt, get a sweater for $20	Buy Type = Amount, Reward Fixed Price, Buy Value = N, Reward List Type = Reward List	Yes
18	Multi-Buy	Buy $N of All Items in X Item List, Get Cheapest in Y Free	Buy $100 worth of jeans and shirt, get cheapest free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
19	Multi-Buy	Buy $N of All Items in X Item List, Get $M Value Y Free	Buy $100 worth of jeans and shirt, get $10 cap free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Amount, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
20	Multi-Buy	Buy N of X, Get Lowest Priced X at Z%off.	Buy 4 Jeans and get lowest priced jeans 10% off		No
21	Multi-Buy	Buy N of X, Get Lowest Priced Y at Z%off.	Buy 4 Jeans and get lowest priced shirt 10% off		No
22	Multi-Buy	Buy $N of X, Get Lowest Priced X at Z%off.	Buy $100 worth of Jeans and get lowest priced jeans 10% off		No
23	Multi-Buy	Buy $N of X, Get Lowest Priced Y at Z%off.	Buy $100 worth of Jeans and get lowest priced shirt 10% off		No
24	Multi-Buy	Buy N of A and N of B, Get Y at Z% off	Buy a cap and a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
25	Multi-Buy	Buy N of A and N of B, Get Y at $Z off	Buy a cap and a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
26	Multi-Buy	Buy N of A and N of B, Get Y for $Z.	Buy a cap and a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
27	Multi-Buy	Buy N of A and N of B, Get Cheapest in Y for Free	Buy a cap and a tie get cheapest in glove free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
28	Multi-Buy	Buy N of A and N of B, Get $M Value Y for Free	Buy a cap and a tie get $10 cap free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Qty, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
29	Multi-Buy	Buy N of A and N of B, Get Z% off	Buy a cap and a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
30	Multi-Buy	Buy N of A and N of B, Get $Z off	Buy a cap and a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
31	Multi-Buy	Buy N of A and N of B, For $Z.	Buy a cap and a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
32	Multi-Buy	Buy N of A and N of B, Get Cheapest Free.	Buy a cap and a glove, get cheapest free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
33	Multi-Buy	Buy N of A and N of B, Get $M Value of A and B Free	Buy a cap and a glove, get $10 item in Cap and Glove free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Qty, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
34	Multi-Buy	Buy N of A OR N of B, Get Y at Z% off	Buy a cap or a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
35	Multi-Buy	Buy N of A OR N of B, Get Y at $Z off	Buy a cap or a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
36	Multi-Buy	Buy N of A OR N of B, Get Y for $Z.	Buy a cap or a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
37	Multi-Buy	Buy N of A OR N of B, Get Cheapest in Y for Free	Buy a cap or a glove, get cheapest in scarf free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
38	Multi-Buy	Buy N of A OR N of B, Get Z% off	Buy a cap or a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
39	Multi-Buy	Buy N of A OR N of B, Get $Z off	Buy a cap or a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Qty, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
40	Multi-Buy	Buy N of A OR N of B, For $Z.	Buy a cap or a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Qty, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
41	Multi-Buy	Buy N of A OR N of B, Get Cheapest Free	Buy a cap or a glove, get cheapest free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
42	Multi-Buy	Buy N of A OR N of B, Get $M Value of A or B for Free	Buy a cap or a glove, get $10 item in Cap and Glove free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M Or Buy Type = Qty, Reward % Off (100), Buy Value = N, Reward List Type = Reward List, Reward Type=Amount, Reward Value=M	Yes
43	Multi-Buy	Buy $N of A and N of B, Get Y at Z% off	Buy $20 of a cap and a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
44	Multi-Buy	Buy $N of A and N of B, Get Y at $Z off	Buy $20 a cap and a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
45	Multi-Buy	Buy $N of A and N of B, Get Y for $Z.	Buy $20 a cap and a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
46	Multi-Buy	Buy $N of A and N of B, Get Cheapest in Y for Free	Buy $50 a cap and a glove, get cheapest in scarf for free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
47	Multi-Buy	Buy $N of A and N of B, Get $M Value of A and B Free	Buy $50 a cap and a glove, get $10 Cap or Glove free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward Type=Amount, Reward List Type = Reward List , Reward Value=M Or Buy Type = Amount, Reward $Off (100), Buy Value = N, Reward Type=Amount, Reward List Type = Reward List, Reward Value=M	Yes
48	Multi-Buy	Buy $N of A and N of B, Get Z% off	Buy $20 of a cap and a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
49	Multi-Buy	Buy $N of A and N of B, Get $Z off	Buy $20 of a cap and a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
50	Multi-Buy	Buy $N of A and N of B, For $Z.	Buy $20 of a cap and a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
51	Multi-Buy	Buy $N of A and N of B, Get Cheapest for Free	Buy $50 of a cap and a glove, get cheapest free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
52	Multi-Buy	Buy $N of A OR N of B, Get Y at Z% off	Buy $20 of a cap or a glove, get a scarf 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = Reward List	Yes
53	Multi-Buy	Buy $N of A OR N of B, Get Y at $Z off	Buy $20 of a cap or a glove, get a scarf $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = Reward List	Yes
54	Multi-Buy	Buy $N of A OR N of B, Get Y for $Z.	Buy $20 of a cap or a glove, get a scarf for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = Reward List	Yes
55	Multi-Buy	Buy $N of A OR N of B, Get Cheapest in Y for Free	Buy $50 of a cap or a glove, get get cheapest free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = Reward List	Yes
56	Multi-Buy	Buy $N of A OR N of B, Get $M Value of A or B Free	Buy $50 of a cap or a glove, get $10 cap or glove free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward Type=Amount, Reward List Type = Reward List , Reward Value=M Or Buy Type = Amount, Reward $Off (100), Buy Value = N, Reward Type=Amount, Reward List Type = Reward List, Reward Value=M	Yes
57	Multi-Buy	Buy $N of A OR N of B, Get Z% off	Buy $20 of a cap or a glove, get 10% off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward %off, Buy Value = N, Reward List Type = All Buy List	Yes
58	Multi-Buy	Buy $N of A OR N of B, Get $Z off	Buy $20 of a cap or a glove, $2 off. The buy and reward lists may use a combination of AND and OR conditions.	Buy Type = Amount, Reward Amount off, Buy Value = N, Reward List Type = All Buy List	Yes
59	Multi-Buy	Buy $N of A OR N of B, For $Z.	Buy $20 of a cap or a glove, for $10.00. The buy and reward lists may use a combination of AND and OR conditions	Buy Type = Amount, Reward Fixed Amount, Buy Value = N, Reward List Type = All Buy List	Yes
60	Multi-Buy	Buy $N of A OR N of B, Get Cheapest for Free	Buy $50 of a cap or a glove, get cheapest free	Buy Type = Amount, Cheapest Free, Buy Value = N, Reward List Type = All Buy List	Yes
61	Multi-Buy	Buy N of X, get the cheapest free	Buy four pair of shoes, get the cheapest pair free	Buy Type = Qty, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List or Each Buy List (when only single List)
62	Multi-Buy	Buy $N of X, get the cheapest free	Buy four pair of shoes, get the cheapest pair free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward List Type = All Buy List or Each Buy List (when only single List)
63	Multi-Buy	Buy $N of X, get $M X free	Buy four pair of shoes, get the $10 shoe free	Buy Type = Amount, Reward Cheapest Free, Buy Value = N, Reward Type=Amount, Reward List Type = Reward List , Reward Value=M, Reward List Items contains same items as Buy List Or Buy Type = Amount, Reward $Off (100), Buy Value = N, Reward Type=Amount, Reward List Type = Reward List, Reward Value=M, Reward List Items contains same items as Buy List
64	Multi-Buy	Buy N of A, Get B of $Z or less for free	Buy one pair of jeans at regular price over $45 and get a T-Shirt regular priced at $25 or less for free	Buy Type = Qty, Reward 100% Off, Buy Value = N, Reward List Type=Reward List, Reward Type = Amount	May Be. This same scenario could be executed by building specific item lists and selecting them for the buy and get scenarios within RPM.
65	Multi-Buy	Buy $N of A, Get B of $Z or less for free	Buy one pair of jeans at regular price over $45 and get a T-Shirt regular priced at $25 or less for free	Buy Type = Amount, Reward 100% Off, Buy Value = N, Reward List Type=Reward List, Reward Type = Amount	May Be. This same scenario could be executed by building specific item lists and selecting them for the buy and get scenarios within RPM.
66	Multi-buy	Buy N of X1, N of X2, N of X3 for a flat price $Z.	Buy hamburger, Coke and fries for 5.00	Qualification Type = Multi-buy Multi-buy = Quantity (with AND connector) Reward Type = Fixed Price	Yes
67	Multi-buy	Buy N of X1, N of X2, N of X3 for $Z off of purchase.	Buy hamburger, Coke and fries, receive 1.00 off purchase	Qualification Type = Multi-buy Multi-buy = Quantity (with AND connector) Reward Type = Amount Off	Yes
68	Multi-buy	Buy N of X1, N of X2, N of X3 for Z% off of purchase.	Buy hamburger, Coke and fries, save 15% off purchase	Qualification Type = Multi-buy Multi-buy = Quantity (with AND connector) Reward Type = % off	Yes
69	Threshold	Buy N of X, get Z% off ( Threshold Level)	Buy any six pairs of jeans, get 10% off each of the jeans	Qualification Type = Threshold Level Threshold Type = Quantity Reward Type = % off	No
70	Threshold	Buy N of X, get Z% off (Item Level)	Buy six pairs of Levi's jeans, get 10% off each of the jeans.	Qualification Type = Item Level Threshold Type = Quantity Reward Type = % off	Yes
71	Threshold	Buy N of X, Get $Z off ( Threshold Level)	Buy six pairs of jeans, get $10 off each of the jeans	Qualification Type = Threshold Level Threshold Type = Quantity Reward Type = Amount off	No
72	Threshold	Buy N of X, get $Z off (Item Level)	Buy six pairs of jeans, get $10 off each of the jeans.	Qualification Type = Item Level Threshold Type = Quantity Reward Type = Amount off	Yes
73	Threshold	Buy N of X, Get items for $Z ( Threshold Level)	Buy two pairs of jeans and get them for $45 each	Qualification Type = Threshold Level Threshold Type = Quantity Reward Type = Fixed Amount	No
74	Threshold	Buy $N of X, get items for $Z  (Item Level)	Buy $100 worth of jeans and get them for $45 each.	Qualification Type = Threshold Level Threshold Type = Amount Reward Type = Fixed Amount	Yes
75	Threshold	Buy $N of X, get Z% off ( Threshold Level)	Buy $100 worth of jeans, get 10% off each pair of jeans	Qualification Type = Threshold Level Threshold Type = Amount Reward Type = % off	Yes
76	Threshold	Buy $N of X, get Z% off (Item Level)	Buy $100 worth of jeans, get 10% off each pair of jeans	Qualification Type = Item Level Threshold Type = Amount Reward Type = % off	Yes
77	Threshold	Buy $N of X, Get $Z off ( Threshold Level)	Buy $100 worth of jeans, get $10 off each pair of jeans	Qualification Type = Threshold Level Threshold Type = Amount Reward Type = Amount off	Yes
78	Threshold	Buy $N of X, Get $Z off  (Item Level)	Buy $100 worth of jeans, get $10 off each pair of jeans	Qualification Type = Item Level Threshold Type = Amount Reward Type = Amount off	Yes
79	Threshold	Buy N1 of X Get Z1% off, Buy N2 of X Get Z2% Off, Buy N3 for X Get Z3% Off	Buy 2 jeans, get 10% off, Buy 4 jeans get 15% off, Buy 6 jeans get 20% off	Qualification Type = Item Level Threshold Type = Quantity Reward Type = % off	Yes. Multilevel Threshold Promotion
80	Threshold	Buy N1 of X Get $Z1 off, Buy N2 of X Get $Z2 Off, Buy N3 for X Get $Z3 Off	Buy 2 jeans, get $5 off, Buy 4 jeans get $10 off, Buy 6 jeans get $15 off	Qualification Type = Item Level Threshold Type = Quantity Reward Type = Amount off	Yes. Multilevel Threshold Promotion
81	Threshold	Buy N1 of X Get Eac for $Z1, Buy N2 of X Get Each for $Z2, Buy N3 for X Get Each for $Z3	Buy 2 jeans, get each for $20, Buy 4 jeans get each for $18, Buy 6 jeans get each for $16	Qualification Type = Item Level Threshold Type = Quantity Reward Type = Fixed Amount	Yes. Multilevel Threshold Promotion
82	Threshold	Buy $N1 of X Get Z1% off, Buy $N2 of X Get Z2% Off, Buy $N3 for X Get Z3% Off	Buy $50 worth of jeans, get 10% off, Buy $100 worth of jeans get 15% off, Buy $200 worth of jeans get 20% off	Qualification Type = Item Level Threshold Type = Amount Reward Type = % off	Yes. Multilevel Threshold Promotion
83	Threshold	Buy $N1 of X Get Z1% off, Buy $N2 of X Get $Z2 Off, Buy $N3 for X Get $Z3 Off	Buy $50 worth of jeans, get 10% off, Buy $100 worth of jeans get 15% off, Buy $200 worth of jeans get 20% off	Qualification Type = Item Level Threshold Type = Amount Reward Type = Amount off	Yes. Multilevel Threshold Promotion
84	Finance	Buy N of X with promoted card, get promotional interest % for Z duration	Purchase $1,000 of Electronics using Visa and receive promotion percentage of 0%, with a duration of 18 months (for no interest payments if paid in full within 18 months).	Card Details Threshold Amount $ Promotion Amount % Duration in Months Items	No
85	Clearance	Items within clearance retail range $A-$B are set to fixed price of $A All clearance are considered as Price Change in ORPOS	Items within clearance retail 100-130$ are set to fixed price of 108$	Clearance	Yes
86	Clearance	Items within regular price $A-$B are set to fixed price of $N	Items within regular price 90-100$ are set to fixed price of $92	Clearance	Yes
87	Clearance	All clearance items are set to a fixed price of $N	All clearance items are set to a fixed price of $120.	Clearance	Yes
88	Clearance	Additional X% of all clearance items	Price Change (% off - 10%) on Clearance item (Clearance = 10$ Amount off)	Price Change on Clearance	Yes
89	Clearance	All clearance items in specific department is $X	All clearance items are set to a fixed price of $120.	Clearance	Yes

Please do let me know in case you have any question or comments. Also, let me know if any other specific scenario is missed here, I would definitely add.

— Share It —

• Facebook
• Twitter
• Google+
• Linkedin
• Pin It

About Nagesh Mishra

Nagesh Mishra - A Passionate Oracle Retail Certified Professional with more than 17 years of overall experience in IT industry and more than 15 years of domain expertise in Oracle Retail Applications. Worked extensively in diversified fields of Product Implementation, Business Consulting, Pre-Sales, Application Software Development, Maintenance and Support and Re-Engineering Oracle Retail projects.