How to Easily Setup a Promotion Where One Buys 6 Items Get 1 Item Free, Buy 12 Items Get 2 Items Free, Buy 65 Items Get 10 Items Free (Doc ID 2012889.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Goal

Note: In the images bellow and/or the attached document, user details / company name / address / email / telephone number represents fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

How can one setup a modifier that provides free get quantity based on the following business requirements?
If customer buy 6 quantity of x product then he/she will get 1 item y free
similarly if customer buys 12 quantity then he/she will get 2 item y free
and if customer buy 65 quantity of x product then he/she will get 10 item y free

One would like to have a setup that is not resource intensive whereas it requires many ranges to be entered to
account for the buy items. For example does not want to have to enter buy   from 1 to 6 get 1 item free, buy 7 to 12 get 2 items free, etc.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.