hi, i face the similar problem (even more complex) designing the table for it.
condition 1 : time base promotion promotion price will occured during the valid date (start, end) e.g. on 1 dec 2014 - 31 dec 2014 the price for product B will be $10, usually normal price is $12 condition 2 : quantity base promotion promotion price will occured when the quantity order is more than quantity that have been set e.g. buy 3 products B the price will be $10, when buy 1 of product B the price is $12 or buy 5 products B the price will be $8, when buy 1 of product B the price is $12 condition 3 : product base promotion promotion that offer free product when another product is ordered. e.g. buy 3 products B get 1 product C or buy 5 products B get 2 product C and 1 product D condition 4 : combination of all 3 aboves e.g. on 1 dec 2014 - 31 dec 2014 buy 3 products B get 1 product C my question is how do i design my table relation for that in web2py way? i've seen examples of presta shop add ons for that, but don't know how to do it using web2py way, any idea how to achieve that? thanks and best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
