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:

[WebDNA] Credit card processing (2012) Comments in db? (1997) New Weird Behavior (bug report) (2000) WebCatalog seems to choke on large (2meg) html files. (1998) please anybody help (2005) More on the email templates (1997) syntax question, not in online refernce (1997) Problems when user hit back (2000) Uh...can someone help me out with the b10? (1997) HELP! 10K hits per hour for pages that no longer exist! (2000) [include] and not found (2005) with Link i need to (1997) Pithy questions on webcommerce & siteedit (1997) Pricing based on quantity (2000) Looking for a host (1997) Micro-managing External Links (2006) formatting a number (1999) Re:Merging databases (1997) log files (1998) Multiple catalog databases and showcart (1997)