promotion - Creative Computing Wiki

since we now can support branch wild promotion, the following is all the possible major combination of setting in proaad to set up promotions. It has two part one part explain how to set up discount and price, the other part explain how to set up coupons,

it is ok to define both in a promotion, but please be ware that the amount used to calculate coupon is the discounted amount.

for discounted price related with promotion

if there is two promotion both with promotion discount which effecting the promotion item/cat itself, the effect is accumulative

if there is two promotion both with promotion price effecting the promotion item/cat itself, the lowest price will be used.

the discount on benefit items are accumulative .

For setting discount and price

cell text	cell text spanning 2 columns
location/location group	Item/category	Threshold qty/amount	Benefit item/category	Promotion discount/price	Desctiption
L	I	Q	I	D	Buy a item for x qty get y qty of another item with a discount in one location
L	I	Q	I	P	Invalid
L	I	Q	I	NA	Invalid
L	I	Q	C	D	Buy a item for x qty get y qty of item from a category with a discount in one location
L	I	Q	C	P	Invalid
L	I	Q	C	NA	Invalid
L	I	Q	NA	D	Buy a item for x qty all this item will receive discount in one location
L	I	Q	NA	P	Buy x qty of item for an amount in a location
L	I	Q	NA	NA	Invalid
L	I	A	I	D	Buy a item for x amount get y qty of another item with a discount in one location
L	I	A	I	P	Invalid
L	I	A	I	NA	Invalid
L	I	A	C	D	Buy a item for x amount get y qty of item from a category with a discount in one location
L	I	A	C	P	Invalid
L	I	A	C	NA	Invalid
L	I	A	NA	D	Buy a item for x amount all this item will receive discount in one location
L	I	A	NA	P	Buy x amount of item for another amount in a location
L	I	A	NA	NA	Invalid
L	I	NA	I	D	Invalid
L	I	NA	I	P	Invalid
L	I	NA	I	NA	Invalid
L	I	NA	C	D	Invalid
L	I	NA	C	P	Invalid
L	I	NA	C	NA	Invalid
L	I	NA	NA	D	All item x will have discount in a location
L	I	NA	NA	P	All item x will be sold at discount price in a location it the discount price is lower then the item's original price
L	I	NA	NA	NA	Invalid
L	C	Q	I	D	Buy any item from a category for x qty get y qty of another item with a discount in one location
L	C	Q	I	P	Invalid
L	C	Q	I	NA	Invalid
L	C	Q	C	D	Buy any item from a category for x qty get y qty of item from a category with a discount in one location
L	C	Q	C	P	Invalid
L	C	Q	C	NA	Invalid
L	C	Q	NA	D	Buy any item from a category for x qty all item of this category will receive discount in one location
L	C	Q	NA	P	Buy x qty of item from a category for an amount in a location,*must set discount item code
L	C	Q	NA	NA	Invalid
L	C	A	I	D	Buy any item from a category for x amount get y qty of another item with a discount in one location
L	C	A	I	P	Invalid
L	C	A	I	NA	Invalid
L	C	A	C	D	Buy any item from a category for x amount get y qty of item from a category with a discount in one location
L	C	A	C	P	Invalid
L	C	A	C	NA	Invalid
L	C	A	NA	D	Buy any item from a category for x amount all this item will receive discount in one location
L	C	A	NA	P	Buy x amount of any item from a category for another amount in a location,*must set discount item code
L	C	A	NA	NA	Invalid
L	C	NA	I	D	Invalid
L	C	NA	I	P	Invalid
L	C	NA	I	NA	Invalid
L	C	NA	C	D	Invalid
L	C	NA	C	P	Invalid
L	C	NA	C	NA	Invalid
L	C	NA	NA	D	All item x will have discount in a location
L	C	NA	NA	P	All item from a category x will be sold at discount price in a location if the discound price is lowered then the item's original price
L	C	NA	NA	NA	Invalid
L	NA	Q	I	D	Buy any item for x qty get y qty of another item with a discount in one location
L	NA	Q	I	P	Invalid
L	NA	Q	I	NA	Invalid
L	NA	Q	C	D	Buy any item for x qty get y qty of item from a category with a discount in one location
L	NA	Q	C	P	Invalid
L	NA	Q	C	NA	Invalid
L	NA	Q	NA	D	Buy any item for x qty all item will receive discount in one location
L	NA	Q	NA	P	Buy x qty of any item for an amount in a location,*must set discount item code
L	NA	Q	NA	NA	Invalid
L	NA	A	I	D	Buy any item for x amount get y qty of another item with a discount in one location
L	NA	A	I	P	Invalid
L	NA	A	I	NA	Invalid
L	NA	A	C	D	Buy any item for x amount get y qty of item from a category with a discount in one location
L	NA	A	C	P	Invalid
L	NA	A	C	NA	Invalid
L	NA	A	NA	D	Buy any item for x amount all items will receive discount in one location
L	NA	A	NA	P	Buy x amount of any item for another amount in a location,*must set discount item code
L	NA	A	NA	NA	Invalid
L	NA	NA	I	D	Invalid
L	NA	NA	I	P	Invalid
L	NA	NA	I	NA	Invalid
L	NA	NA	C	D	Invalid
L	NA	NA	C	P	Invalid
L	NA	NA	C	NA	Invalid
L	NA	NA	NA	D	All item x will have discount in a location
L	NA	NA	NA	P	All item x will be sold at discount price in a location if the discounted price is lower than the original price
L	NA	NA	NA	NA	Invalid
G	I	Q	I	D	Buy a item for x qty get y qty of another item with a discount in all location belong to a group
G	I	Q	I	P	Invalid
G	I	Q	I	NA	Invalid
G	I	Q	C	D	Buy a item for x qty get y qty of item from a category with a discount in all location belong to a group
G	I	Q	C	P	Invalid
G	I	Q	C	NA	Invalid
G	I	Q	NA	D	Buy a item for x qty all this item will receive discount in all location belong to a group
G	I	Q	NA	P	Buy x qty of item for an amount in all location belong to a group
G	I	Q	NA	NA	Invalid
G	I	A	I	D	Buy a item for x amount get y qty of another item with a discount in all location belong to a group
G	I	A	I	P	Invalid
G	I	A	I	NA	Invalid
G	I	A	C	D	Buy a item for x amount get y qty of item from a category with a discount in one all location belong to a group
G	I	A	C	P	Invalid
G	I	A	C	NA	Invalid
G	I	A	NA	D	Buy a item for x amount all this item will receive discount in all location belong to a group
G	I	A	NA	P	Buy x amount of item for another amount in all location belong to a group
G	I	A	NA	NA	Invalid
G	I	NA	I	D	Invalid
G	I	NA	I	P	Invalid
G	I	NA	I	NA	Invalid
G	I	NA	C	D	Invalid
G	I	NA	C	P	Invalid
G	I	NA	C	NA	Invalid
G	I	NA	NA	D	All item x will have discount in all location belong to a group
G	I	NA	NA	P	All item x will be sold at discount price in all location belong to a group it the discount price is lower then the item's original price
G	I	NA	NA	NA	Invalid
G	C	Q	I	D	Buy any item from a category for x qty get y qty of another item with a discount in all location belong to a group
G	C	Q	I	P	Invalid
G	C	Q	I	NA	Invalid
G	C	Q	C	D	Buy any item from a category for x qty get y qty of item from a category with a discount in all location belong to a group
G	C	Q	C	P	Invalid
G	C	Q	C	NA	Invalid
G	C	Q	NA	D	Buy any item from a category for x qty all item of this category will receive discount in all location belong to a group
G	C	Q	NA	P	Buy x qty of item from a category for an amount in all location belong to a group,*must set discount item code
G	C	Q	NA	NA	Invalid
G	C	A	I	D	Buy any item from a category for x amount get y qty of another item with a discount in all location belong to a group
G	C	A	I	P	Invalid
G	C	A	I	NA	Invalid
G	C	A	C	D	Buy any item from a category for x amount get y qty of item from a category with a discount in all location belong to a group
G	C	A	C	P	Invalid
G	C	A	C	NA	Invalid
G	C	A	NA	D	Buy any item from a category for x amount all this item will receive discount in all location belong to a group
G	C	A	NA	P	Buy x amount of any item from a category for another amount in all location belong to a group,*must set discount item code
G	C	A	NA	NA	Invalid
G	C	NA	I	D	Invalid
G	C	NA	I	P	Invalid
G	C	NA	I	NA	Invalid
G	C	NA	C	D	Invalid
G	C	NA	C	P	Invalid
G	C	NA	C	NA	Invalid
G	C	NA	NA	D	All item x will have discount in all location belong to a group
G	C	NA	NA	P	All item from a category x will be sold at discount price in all location belong to a group if the discound price is lowered then the item's original price
G	C	NA	NA	NA	Invalid
G	NA	Q	I	D	Buy any item for x qty get y qty of another item with a discount in all location belong to a group
G	NA	Q	I	P	Invalid
G	NA	Q	I	NA	Invalid
G	NA	Q	C	D	Buy any item for x qty get y qty of item from a category with a discount in all location belong to a group
G	NA	Q	C	P	Invalid
G	NA	Q	C	NA	Invalid
G	NA	Q	NA	D	Buy any item for x qty all item will receive discount in all location belong to a group
G	NA	Q	NA	P	Buy x qty of any item for an amount in all location belong to a group,*must set discount item code
G	NA	Q	NA	NA	Invalid
G	NA	A	I	D	Buy any item for x amount get y qty of another item with a discount in all location belong to a group
G	NA	A	I	P	Invalid
G	NA	A	I	NA	Invalid
G	NA	A	C	D	Buy any item for x amount get y qty of item from a category with a discount in all location belong to a group
G	NA	A	C	P	Invalid
G	NA	A	C	NA	Invalid
G	NA	A	NA	D	Buy any item for x amount all items will receive discount in all location belong to a group
G	NA	A	NA	P	Buy x amount of any item for another amount in all location belong to a group,*must set discount item code
G	NA	A	NA	NA	Invalid
G	NA	NA	I	D	Invalid
G	NA	NA	I	P	Invalid
G	NA	NA	I	NA	Invalid
G	NA	NA	C	D	Invalid
G	NA	NA	C	P	Invalid
G	NA	NA	C	NA	Invalid
G	NA	NA	NA	D	All item x will have discount in all location belong to a group
G	NA	NA	NA	P	All item x will be sold at discount price in all location belong to a group if the discounted price is lower than the original price
G	NA	NA	NA	NA	Invalid
NA	I	Q	I	D	Buy a item for x qty get y qty of another item with a discount in all location
NA	I	Q	I	P	Invalid
NA	I	Q	I	NA	Invalid
NA	I	Q	C	D	Buy a item for x qty get y qty of item from a category with a discount in all location
NA	I	Q	C	P	Invalid
NA	I	Q	C	NA	Invalid
NA	I	Q	NA	D	Buy a item for x qty all this item will receive discount in all location
NA	I	Q	NA	P	Buy x qty of item for an amount in all location
NA	I	Q	NA	NA	Invalid
NA	I	A	I	D	Buy a item for x amount get y qty of another item with a discount in all location
NA	I	A	I	P	Invalid
NA	I	A	I	NA	Invalid
NA	I	A	C	D	Buy a item for x amount get y qty of item from a category with a discount in one all location
NA	I	A	C	P	Invalid
NA	I	A	C	NA	Invalid
NA	I	A	NA	D	Buy a item for x amount all this item will receive discount in all location
NA	I	A	NA	P	Buy x amount of item for another amount in all location
NA	I	A	NA	NA	Invalid
NA	I	NA	I	D	Invalid
NA	I	NA	I	P	Invalid
NA	I	NA	I	NA	Invalid
NA	I	NA	C	D	Invalid
NA	I	NA	C	P	Invalid
NA	I	NA	C	NA	Invalid
NA	I	NA	NA	D	All item x will have discount in all location
NA	I	NA	NA	P	All item x will be sold at discount price in all location it the discount price is lower then the item's original price
NA	I	NA	NA	NA	Invalid
NA	C	Q	I	D	Buy any item from a category for x qty get y qty of another item with a discount in all location
NA	C	Q	I	P	Invalid
NA	C	Q	I	NA	Invalid
NA	C	Q	C	D	Buy any item from a category for x qty get y qty of item from a category with a discount in all location
NA	C	Q	C	P	Invalid
NA	C	Q	C	NA	Invalid
NA	C	Q	NA	D	Buy any item from a category for x qty all item of this category will receive discount in all location
NA	C	Q	NA	P	Buy x qty of item from a category for an amount in all location ,*must set discount item code
NA	C	Q	NA	NA	Invalid
NA	C	A	I	D	Buy any item from a category for x amount get y qty of another item with a discount in all location
NA	C	A	I	P	Invalid
NA	C	A	I	NA	Invalid
NA	C	A	C	D	Buy any item from a category for x amount get y qty of item from a category with a discount in all location
NA	C	A	C	P	Invalid
NA	C	A	C	NA	Invalid
NA	C	A	NA	D	Buy any item from a category for x amount all this item will receive discount in all location
NA	C	A	NA	P	Buy x amount of any item from a category for another amount in all location ,*must set discount item code
NA	C	A	NA	NA	Invalid
NA	C	NA	I	D	Invalid
NA	C	NA	I	P	Invalid
NA	C	NA	I	NA	Invalid
NA	C	NA	C	D	Invalid
NA	C	NA	C	P	Invalid
NA	C	NA	C	NA	Invalid
NA	C	NA	NA	D	All item x will have discount in all location
NA	C	NA	NA	P	All item from a category x will be sold at discount price in all location if the discound price is lowered then the item's original price
NA	C	NA	NA	NA	Invalid
NA	NA	Q	I	D	Buy any item for x qty get y qty of another item with a discount in all location
NA	NA	Q	I	P	Invalid
NA	NA	Q	I	NA	Invalid
NA	NA	Q	C	D	Buy any item for x qty get y qty of item from a category with a discount in all location
NA	NA	Q	C	P	Invalid
NA	NA	Q	C	NA	Invalid
NA	NA	Q	NA	D	Buy any item for x qty all item will receive discount in all location
NA	NA	Q	NA	P	Buy x qty of any item for an amount in all location ,*must set discount item code
NA	NA	Q	NA	NA	Invalid
NA	NA	A	I	D	Buy any item for x amount get y qty of another item with a discount in all location
NA	NA	A	I	P	Invalid
NA	NA	A	I	NA	Invalid
NA	NA	A	C	D	Buy any item for x amount get y qty of item from a category with a discount in all location
NA	NA	A	C	P	Invalid
NA	NA	A	C	NA	Invalid
NA	NA	A	NA	D	Buy any item for x amount all items will receive discount in all location
NA	NA	A	NA	P	Buy x amount of any item for another amount in all location ,*must set discount item code
NA	NA	A	NA	NA	Invalid
NA	NA	NA	I	D	Invalid
NA	NA	NA	I	P	Invalid
NA	NA	NA	I	NA	Invalid
NA	NA	NA	C	D	Invalid
NA	NA	NA	C	P	Invalid
NA	NA	NA	C	NA	Invalid
NA	NA	NA	NA	D	All item x will have discount in all location
NA	NA	NA	NA	P	All item x will be sold at discount price in all location if the discounted price is lower than the original price
NA	NA	NA	NA	NA	Invalid

For coupon printing

location/location group	Item/category	Threshold qty/amount	Description
L	I	Q	A coupon for every x qty of an item in a location
L	I	A	A coupon for every x dollars of an item in a location
L	I	NA	A coupon for everyone of an item in a location
L	C	Q	A coupon for every x qty of any items belong to a category in a location
L	C	A	A coupon for every x dollars of any items belong to a category in a location
L	C	NA	A coupon for every unit of any items belong to a category in a location
L	NA	Q	A coupon for every x qty of any items in a location
L	NA	A	A coupon for every x dollars of any items in a location
L	NA	NA	A coupon for every unit of any items in a location
G	I	Q	A coupon for every x qty of an item in any location belong to a group
G	I	A	A coupon for every x dollars of an item in any location belong to a group
G	I	NA	A coupon for everyone of an item in any location belong to a group
G	C	Q	A coupon for every x qty of any items belong to a category in any location belong to a group
G	C	A	A coupon for every x dollars of any items belong to a category in any location belong to a group
G	C	NA	A coupon for every unit of any items belong to a category in any location belong to a group
G	NA	Q	A coupon for every x qty of any items in any location belong to a group
G	NA	A	A coupon for every x dollars of any items in any location belong to a group
G	NA	NA	A coupon for every unit of any items in any location belong to a group
NA	I	Q	A coupon for every x qty of an item in any location
NA	I	A	A coupon for every x dollars of an item in any location
NA	I	NA	A coupon for everyone of an item in any location
NA	C	Q	A coupon for every x qty of any items belong to a category in any location
NA	C	A	A coupon for every x dollars of any items belong to a category in any location
NA	C	NA	A coupon for every unit of any items belong to a category in any location
NA	NA	Q	A coupon for every x qty of any items in any location
NA	NA	A	A coupon for every x dollars of any items in any location
NA	NA	NA	A coupon for every unit of any items in any location