Re: Price Change
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35566
interpreted = N
texte = yeah, since there is no formula for grandtotal as such. I would only add moreexplanation:Use showifs to see if the grandtotal is within a range that warrants a discount. If sothen add a special discount product. You can keep that special product in the mainproducts db (or else put it in a special db?) Use the price formula to set its priceaccording to the level of discount needed. This way you don't have to mess withoverruling webcat's default behaviour in handling subtotal, grandtotal , etc.I haven't done that much ecommerce, but until you hear from other more expert-likefolks, maybe this gives you some ideas...-JohnGlenn Busbin wrote:> >Here is the scenario.> >If a user's subtotal is between 299-499 I want to subtract $50 from the> >price.> >If a user's subtotal is over 500 I want to subtract $55 from the price.> >How do I do this? I tried changing the price in the formula.db file and no> >luck.> >> >Where do I do the math?> >>> Create a database. Maybe like:> Name Discount> Disco0 0> Disco1 -50> Disco2 -55>> Then, use [showif]'s on the Invoice or ThankYou page to determine the> discount to be given and add it to the Subtotal.>> How's that?>> Glenn>> -------------------------------------------------------------> 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:
yeah, since there is no formula for grandtotal as such. I would only add moreexplanation:Use showifs to see if the grandtotal is within a range that warrants a discount. If sothen add a special discount product. You can keep that special product in the mainproducts db (or else put it in a special db?) Use the price formula to set its priceaccording to the level of discount needed. This way you don't have to mess withoverruling webcat's default behaviour in handling subtotal, grandtotal , etc.I haven't done that much ecommerce, but until you hear from other more expert-likefolks, maybe this gives you some ideas...-JohnGlenn Busbin wrote:> >Here is the scenario.> >If a user's subtotal is between 299-499 I want to subtract $50 from the> >price.> >If a user's subtotal is over 500 I want to subtract $55 from the price.> >How do I do this? I tried changing the price in the formula.db file and no> >luck.> >> >Where do I do the math?> >>> Create a database. Maybe like:> Name Discount> Disco0 0> Disco1 -50> Disco2 -55>> Then, use [showif]'s on the Invoice or ThankYou page to determine the> discount to be given and add it to the Subtotal.>> How's that?>> Glenn>> -------------------------------------------------------------> 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 Butler
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:
Heads up, cookies *may* be outlawed in Europe (2001)
Parse question (2005)
WC2b15 File Corruption (1997)
Searchable WebCat (etc.) Docs ? (1997)
New Command prefs ... (1997)
server not running. (2003)
Re:2nd WebCatalog2 Feature Request (1996)
code to phantom spacing (2001)
Include files (1998)
Re:Emailer and encryption (1997)
garbage on page (2000)
[OT] (waaaay OT) further off topic than before (2004)
the comparison character \ (2000)
It's working (1997)
TCP Connect/send and CGI (2003)
[ShowNext] feature in 2.0 (1997)
Country & Ship-to address & other fields ? (1997)
syntax question, not in online refernce (1997)
Price and Formula.db (2002)
help with duplicate records posted (1998)