Re: Quantity discount on some items?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36243
interpreted = N
texte = John, I set up a similar pricing system and used the Formulas.db to determine the value of [price].I have a value in my database that can be used for [price]. Which one is used depends on the quantity ordered. In my case, the price ranges are set for: Quantity Price 1-2 items price1to2 3-5 items price3to5 6-11 items price6to11 12 items price12 Over 12 items priceover12Here's some of my Formulas.db:Name Formula price [showif [quantity]<3][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price1to2][/showif][hideif [quantity]>5][showif [quantity]>2][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price3to5][/showif][/hideif][hi deif [quantity]>11][showif [quantity]>5][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price6to11][/showif][/hideif][s howif [quantity]=12][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price12][/showif][showif [quantity]>12][lookup db=my.db&lookInField=sku&value=[sku]&returnField=priceover12][/showif]Note that this is all one long formula. Using a cr to clarify it will foul it up tremendously in real use.Maybe you can adapt it to your situation.Glenn >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. > ------------------------------------------------------------- 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:
John, I set up a similar pricing system and used the formulas.db to determine the value of [price].I have a value in my database that can be used for [price]. Which one is used depends on the quantity ordered. In my case, the price ranges are set for: Quantity Price 1-2 items price1to2 3-5 items price3to5 6-11 items price6to11 12 items price12 Over 12 items priceover12Here's some of my formulas.db:Name Formula price [showif [quantity]<3][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price1to2][/showif][hideif [quantity]>5][showif [quantity]>2][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price3to5][/showif][/hideif][hi deif [quantity]>11][showif [quantity]>5][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price6to11][/showif][/hideif][s howif [quantity]=12][lookup db=my.db&lookInField=sku&value=[sku]&returnField=price12][/showif][showif [quantity]>12][lookup db=my.db&lookInField=sku&value=[sku]&returnField=priceover12][/showif]Note that this is all one long formula. Using a cr to clarify it will foul it up tremendously in real use.Maybe you can adapt it to your situation.Glenn >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. > ------------------------------------------------------------- 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/
Glenn Busbin
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:
Limit to Field Length in DB (1998)
Recalculating Shipping Costs (1997)
2.0.1 new commands and contexts (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Re2: frames & carts (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
[WebDNA] Sending emails (2010)
Help name our technology! I found it (1997)
ShowNext for method=POST (1997)
[WebDNA] php/mySQL version of WebDNA Speed Test? (2009)
[WebDNA] WebDNA crash and now emailer not working (2009)
emailer on Windows Beta 18 (1997)
can we get string variables? (1998)
Not really WebCat - need HTML Grider (1997)
WebMerchant when CC network is down (1998)
RequiredFields template (1997)
Frames and WebCat (1997)
Multiple download orders of the same product? (1997)
I've had it! (1999)