Re: Discounts

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46462
interpreted = N
texte = Yes, I would think so,... You can initially set it there.You can either keep the percent discount or the actual price after the percent discount in the products.db. Then you will refrence this field every time a product is entered. something like:[if [lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER]!][then][!] [/!][math][lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE]*[lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER][/math][/then][else][!][/!][else][lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE][/else][/if]---code above might have false line breaks from email.---It gets tricky when you start to give tabled discounts based on quantity ordered of items within a particular category. ;-)DonovanClint Davis wrote:> Donovan, > > I should have specified that these are per-item sale prices calculated as a > percentage of the original price. It sounds like the formulas.db route is in > my best interest, true? > >-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= ( Clint Davis 2004)
  2. Re: Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= ( Donovan Brooke 2004)
  3. Re: Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= ( Clint Davis 2004)
  4. Re: Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= ( Donovan Brooke 2004)
  5. Re: Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= ( Clint Davis 2004)
  6. Re: Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= ( Donovan Brooke 2004)
  7. Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= ( Clint Davis 2004)
  8. Re: Discounts ( John Peacock 2004)
  9. Re: Discounts (Donovan 2002)
  10. Re: Discounts (Clint Davis 2002)
  11. Re: Discounts (Donovan 2002)
  12. Re: Discounts (Jay Van Vark 2002)
  13. Discounts (Clint Davis 2002)
  14. Re: Discounts (John Peacock 2001)
  15. Re: Discounts (Rob Marquardt 2001)
  16. Re: Need help with Shipping/Price discounts (PCS Technical Support 1998)
  17. Need help with Shipping/Price discounts (bradeisenberg@iname.com 1998)
  18. Re: Discounts (PCS Technical Support 1998)
  19. Discounts (greg 1998)
  20. Re: Secure Server not remembering discounts (Grant Hulbert 1998)
  21. Secure Server not remembering discounts (Christine Crane 1998)
  22. Re: Tracking inbound links for discounts (Olin 1997)
  23. Tracking inbound links for discounts (Gil Poulsen 1997)
  24. Re: .. more on sliding discounts... (Jeremy Pocock 1997)
  25. Re: .. more on sliding discounts... (Grant Hulbert 1997)
  26. .. more on sliding discounts... (Jeremy Pocock 1997)
  27. Applying discounts as more items are added... (Jeremy Pocock 1997)
Yes, I would think so,... You can initially set it there.You can either keep the percent discount or the actual price after the percent discount in the products.db. Then you will refrence this field every time a product is entered. something like:[if [lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER]!][then][!] [/!][math][lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE]*[lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER][/math][/then][else][!][/!][else][lookup db=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE][/else][/if]---code above might have false line breaks from email.---It gets tricky when you start to give tabled discounts based on quantity ordered of items within a particular category. ;-)DonovanClint Davis wrote:> Donovan, > > I should have specified that these are per-item sale prices calculated as a > percentage of the original price. It sounds like the formulas.db route is in > my best interest, true? > >-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- 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://webdna.smithmicro.com/ Donovan

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:

WebCat2 - storing unformatted date data? (1997) downloadable txt file (2001) RequiredFields parameter (1998) ShipCosts database (1997) Upgrading old WebCat Database Files (1997) [WebDNA] New request for websites that currently run WebDNA (2009) Can this be done? (1997) [WebDNA] User sessions - cookies only or cookies and a (2016) re:WebCatalog and Filemaker (1996) suggestions for a Windows based text editor? (2004) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Forms Search Questions (1997) hiding hyperlink info in URL field (1999) Quit revisited (1997) WebCat virtual postcard is done! Thanks for the help! (1998) wild question (1998) Plugin or CGI or both (1997) FYI: virus alert (1996) About [Loop] (2000) emailer (1997)