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 more explanation:Use showifs to see if the grandtotal is within a range that warrants a discount. If so then add a special discount product. You can keep that special product in the main products db (or else put it in a special db?) Use the price formula to set its price according to the level of discount needed. This way you don't have to mess with overruling webcat's default behaviour in handling subtotal, grandtotal , etc.I haven't done that much ecommerce, but until you hear from other more expert-like folks, 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:

    
  1. Re: [WebDNA] [SETLINEITEM] Price Change Not Working (Lawrence 2010)
  2. [WebDNA] [SETLINEITEM] Price Change Not Working ("Ki Song - Knifecenter.com" 2010)
  3. Re: Price Change Password ( Stuart Tremain 2003)
  4. Re: Price Change Password ( Stuart Tremain 2003)
  5. Price Change Password ( Brian Wachter 2003)
  6. Re: Price Change (John Butler 2000)
  7. Re: Price Change (Stephen Russo 2000)
  8. Re: Price Change (Stephen Russo 2000)
  9. Re: Price Change (Glenn Busbin 2000)
  10. Re: Price Change (John Jakovich 2000)
  11. Re: Price Change (Stephen Russo 2000)
  12. Re: Price Change (Glenn Busbin 2000)
  13. Re: Price Change (Glenn Busbin 2000)
  14. Re: Price Change (Stephen Russo 2000)
  15. Re: Price Change (Glenn Busbin 2000)
  16. Re: Price Change (dale 2000)
  17. Re: Price Change (John Butler 2000)
  18. Price Change (Stephen Russo 2000)
  19. Re: Price Change (Glenn Busbin 2000)
  20. Re: Price Change (PCS Technical Support 1999)
  21. Price Change (Bob Minor 1999)
  22. Re: price change help (PCS Technical Support 1998)
  23. price change help (Scott Szretter 1998)
yeah, since there is no formula for grandtotal as such. I would only add more explanation:Use showifs to see if the grandtotal is within a range that warrants a discount. If so then add a special discount product. You can keep that special product in the main products db (or else put it in a special db?) Use the price formula to set its price according to the level of discount needed. This way you don't have to mess with overruling webcat's default behaviour in handling subtotal, grandtotal , etc.I haven't done that much ecommerce, but until you hear from other more expert-like folks, 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)