Re: Quantity discount on some items?

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 36246
interpreted = N
texte = The trick here is to put a [lineitems] loop at the top of the page after you add an item to the cart and walk through each line item and test your criteria. In your case, you would need to walk through the lines twice: once to see if the quantities purchased justify special handling; once to reset the prices.Remember that you might have to reduce their price as well as increase it; say they bought 1000 of A and 20 of B, then delete the 1000 of A. You need to reset the B prices to be the 10-99 price.HTHJohn PeacockJohn Davies wrote: > > Here is a tough one, > > Let's say we have 3 products: > > A - $10.00 qty 10-99 & $9.00 qty >99 > B - $20.00 qty 10-99 & $18.00 qty >99 > H - $1.00 > > The price of item H never changes, but the if more than 100 of items A, B, > or A+B is ordered the customer gets a 10% discount on items A and B. (I > really have A,B,C,D, and E that need to be discounted if any combination > adds up to more than 100) > > I picture it like so: > If the user orders more that 100 of A or B individually the price is set to > the discount value. - no problem. If the user orders 50 of A and 50 of B, > the prices of A and B need to be changed to the discount value. But how do I > do this after they have been added to the cart? I can't just to a general > 10% discount, because if the user add any H it gets the discount added, and > it shouldn't. > > HELP! > > John Davies > jd@professionalideas.com > _____________________________________________ > Martin Associates Design Agency > http://www.professionalideas.com > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Quantity discount on some items? (John Peacock 2000)
  2. Re: Quantity discount on some items? (Glenn Busbin 2000)
  3. Quantity discount on some items? (John Davies 2000)
The trick here is to put a [lineitems] loop at the top of the page after you add an item to the cart and walk through each line item and test your criteria. In your case, you would need to walk through the lines twice: once to see if the quantities purchased justify special handling; once to reset the prices.Remember that you might have to reduce their price as well as increase it; say they bought 1000 of A and 20 of B, then delete the 1000 of A. You need to reset the B prices to be the 10-99 price.HTHJohn PeacockJohn Davies wrote: > > Here is a tough one, > > Let's say we have 3 products: > > A - $10.00 qty 10-99 & $9.00 qty >99 > B - $20.00 qty 10-99 & $18.00 qty >99 > H - $1.00 > > The price of item H never changes, but the if more than 100 of items A, B, > or A+B is ordered the customer gets a 10% discount on items A and B. (I > really have A,B,C,D, and E that need to be discounted if any combination > adds up to more than 100) > > I picture it like so: > If the user orders more that 100 of A or B individually the price is set to > the discount value. - no problem. If the user orders 50 of A and 50 of B, > the prices of A and B need to be changed to the discount value. But how do I > do this after they have been added to the cart? I can't just to a general > 10% discount, because if the user add any H it gets the discount added, and > it shouldn't. > > HELP! > > John Davies > jd@professionalideas.com > _____________________________________________ > Martin Associates Design Agency > http://www.professionalideas.com > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ John Peacock

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

GuestBook example (1997) WebCatb15 Mac CGI -- [purchase] (1997) Fwd: virtual domain and [listfile] paths and aliases (1998) Closing db's & caching templates (was: Shippingcalculations) (1997) [WriteFile] problems (1997) Date Formats (1997) Unknown error: OrderNotCreated (1997) Review comparison by PC Magazine: Open for On-line Business (1997) Show shoppingcart after remove last item (1997) Nested tags count question (1997) system crashes, event log (1997) sorting question... (2001) WebCat2b13MacPlugIn - More limits on [include] (1997) StoreBuilder Q's (2003) [WebDNA] Snow Leoopard and v7 (2011) List archive status? (1999) Searching multiple Databases (1997) [dos] command question (1997) Single Link browsing (1997) FileMaker and WebCat - .hdr OK Merge not OK (1999)