Re: [web2py] Re: How would one design a promotion for products using web2py?

2015-01-07 Thread Richard Vézina
There is also to consider the rules of particular provinces, states, etc. Sometimes they ask that the promotion applies even stock are over... Richard On Wed, Jan 7, 2015 at 2:30 PM, Derek wrote: > I suppose it could be if you have many different types of sales (ex: buy > this specific item, ge

[web2py] Re: How would one design a promotion for products using web2py?

2015-01-07 Thread Derek
I suppose it could be if you have many different types of sales (ex: buy this specific item, get another specific item half off) but supposing you stick to certain themes it wouldn't be too difficult (buy 5 get 50% off, or get 12%off all electronics) On Wednesday, January 7, 2015 11:42:50 AM UT

[web2py] Re: How would one design a promotion for products using web2py?

2015-01-07 Thread Dave S
On Wednesday, January 7, 2015 10:25:05 AM UTC-8, Derek wrote: > > I think I would handle it by creating a controller function which > calculates a price given the objectid and quantity, it returns the line > item price per single item and price total together as well as the > percentage saved

[web2py] Re: How would one design a promotion for products using web2py?

2015-01-07 Thread Derek
I think I would handle it by creating a controller function which calculates a price given the objectid and quantity, it returns the line item price per single item and price total together as well as the percentage saved (if any). the code in that function would probably change for every promo

[web2py] Re: How would one design a promotion for products using web2py?

2015-01-01 Thread 黄祥
thank you so much dave and massimo, i'll try the simple first, handle the time base promotion (using start_date and end_date comparison) and then goes to quantity base promotion (using the sample code by massimo). for the scheduler i don't think it can be set by Marketing division user, it must

[web2py] Re: How would one design a promotion for products using web2py?

2014-12-30 Thread Dave S
On Monday, December 29, 2014 6:06:04 PM UTC-8, Dave S wrote: > > > Just a thought: > > On Saturday, December 27, 2014 7:25:01 AM UTC-8, 黄祥 wrote: >> >> [...] >> > > >> i'd love to learn from another products and implement it on web2py, but >> still have no idea how to do it in web2py ways. the

[web2py] Re: How would one design a promotion for products using web2py?

2014-12-29 Thread Dave S
Just a thought: On Saturday, December 27, 2014 7:25:01 AM UTC-8, 黄祥 wrote: > > [...] > > i'd love to learn from another products and implement it on web2py, but > still have no idea how to do it in web2py ways. the reason is if it set on > the table, the user (non technical) perhaps in marke

[web2py] Re: How would one design a promotion for products using web2py?

2014-12-27 Thread 黄祥
a, i c, the controller do the job, i've searched on the google that the others (magento, prestashop, oracle, etc) using tables (promotion, pricing rules, cart rules, etc) to handle it. put the condition on table and then compare it using controller, please correct me if i'm wrong. i'd love to l

[web2py] Re: How would one design a promotion for products using web2py?

2014-12-27 Thread Massimo Di Pierro
db.define_table('product', Field('name'), Field('price')) pen = db.product.insert(name="Pen", price="8 if cart[pen]>4 else 10 if cart[pen]>2 else 12") cart = {pen: 3} # 3 pens in cart cart_total = sum(eval(p.price, cart) for p in db(db.product.name.belongs(cart.keys())).select()) On

[web2py] Re: How would one design a promotion for products using web2py?

2014-12-26 Thread 黄祥
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 : quanti

[web2py] Re: How would one design a promotion for products using web2py?

2013-05-01 Thread Anthony
> > - Since the timer is ticking down on the client-side (using a javascript > countdown timer), how will the server know when a promotion has ended so > that it can immediately update the site's html to hide any signs of the > expired promotion? The server will also have to reset to its origin