Promotion Table Schema Design
-
Dear All, I've designed the basic retail management solution. Now my client is asking me include the promotion management into the system by each product or all. I hoping some guidance from whoever have already designed before. Mostly I'm looking at the database perspective (table design). the design should be flexible, it should cater for the following conditions: * Buy X at a Discount (% or value) * Buy X, Get Y at a Discount (% or Value) or for Free * Buy N Qty X, Get Y at a Discount (% or Value) or for Free * Buy X &Y, Get X at a Discount (% or Value) or for Free * Buy X, Get X, Y & Z for Free Hope somebody will give flexible design for the above mentioned combinations, there can be many more combinations, but i can only think of this for the moment.. If i missed out, kindly add up for my knowledge. Regards Yamiho
-
Dear All, I've designed the basic retail management solution. Now my client is asking me include the promotion management into the system by each product or all. I hoping some guidance from whoever have already designed before. Mostly I'm looking at the database perspective (table design). the design should be flexible, it should cater for the following conditions: * Buy X at a Discount (% or value) * Buy X, Get Y at a Discount (% or Value) or for Free * Buy N Qty X, Get Y at a Discount (% or Value) or for Free * Buy X &Y, Get X at a Discount (% or Value) or for Free * Buy X, Get X, Y & Z for Free Hope somebody will give flexible design for the above mentioned combinations, there can be many more combinations, but i can only think of this for the moment.. If i missed out, kindly add up for my knowledge. Regards Yamiho
Have you come up with any good ideas?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon