Re: Formulas.db

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40008
interpreted = N
texte = thanks.John Peacock wrote:> Donovan Brooke wrote: > > > > Hello, Our company has somewhat complex discounting for its products depending on sku, quantity etc... My question is should I > > do > > all the discount formulas in a formulas.db so that price is entered including the discounts > > in each item added to the cart? Since this has to be one line in a database the script could get long I think. > > Are there other solutions to complex discounting. > > thanks. > > If you do not do the discount calculations at the time of entering the item > into the cart, you will need to do a [lineitems] loop and set the price at > some time later in the transaction. If you allow the user to change the > quantities at some later time, you will need to do that too, to recalculate > the price (since the price formula is ONLY used when add a lineitem to the > cart). > > I believe people have in the past used include files to encapsulate the price > calculation (so it is available both at time of insertion into the cart as > well as later). > > It would be really useful to have a new context [RecalcCart] which would go > through all of the cart lines and redo the original price calculation. > > HTH > > John > > -- >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics------------------------------------------------------------- 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: Formulas.db not working ( Donovan Brooke 2006)
  2. Re: Formulas.db not working ( Brian Fries 2006)
  3. Re: Formulas.db not working ( Charles Kline 2006)
  4. Re: Formulas.db not working ( Donovan Brooke 2006)
  5. Re: Formulas.db not working ( Donovan Brooke 2006)
  6. Re: Formulas.db not working ( Charles Kline 2006)
  7. Re: Formulas.db not working ( Donovan Brooke 2006)
  8. Re: Formulas.db not working ( Charles Kline 2006)
  9. Re: Formulas.db not working ( "Dan Strong" 2006)
  10. Re: Formulas.db not working ( Charles Kline 2006)
  11. Re: Formulas.db not working ( Donovan Brooke 2006)
  12. Re: Formulas.db not working ( Charles Kline 2006)
  13. Re: Formulas.db not working ( Donovan Brooke 2006)
  14. Re: Formulas.db not working ( Donovan Brooke 2006)
  15. Re: Formulas.db not working ( Donovan Brooke 2006)
  16. Re: Formulas.db not working ( Gary Krockover 2006)
  17. Formulas.db not working ( Charles Kline 2006)
  18. Re: formulas.db [feature request] ( Donovan 2003)
  19. Re: formulas.db ( Stuart Tremain 2003)
  20. Re: formulas.db ( Kenneth Grome 2003)
  21. formulas.db ( Tim Robinson 2003)
  22. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  23. Re: [shippingtotal] & Formulas.db prob (Gary Krockover 2003)
  24. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  25. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  26. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  27. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  28. [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  29. Re: Formulas.db (dbrooke 2003)
  30. Re: Formulas.db (John Peacock 2003)
  31. Formulas.db (dbrooke 2003)
  32. [Mac 3.0.8] Formulas.db Question (Jesse Williams-Proudman 2003)
  33. Re: UnitShipCost, Formulas.db and passwords (John Peacock 2003)
  34. Re: UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  35. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  36. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  37. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  38. UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  39. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  40. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  41. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  42. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  43. [shippingtotal] in Formulas.db (WJ Starck 2002)
  44. Re: Formulas.db question (Donovan 2002)
  45. Formulas.db question (charles kline 2002)
  46. Re: Formulas.db (Donovan Brooke 2001)
  47. Re: Formulas.db (Brian Fries 2001)
  48. Re: Formulas.db (John Peacock 2001)
  49. Formulas.db (Donovan Brooke 2001)
  50. Re: Formulas.db (John Peacock 2001)
  51. Re: Formulas.db (Donovan Brooke 2001)
  52. Re: Formulas.db (Glenn Busbin 2001)
  53. Re: Formulas.db (Donovan Brooke 2001)
  54. Re: Formulas.db (John Peacock 2001)
  55. Formulas.db (Donovan Brooke 2001)
  56. Re: where's Formulas.db? (Samuel Renkert 2001)
  57. Re: where's Formulas.db? (John Peacock 2001)
  58. Re: where's Formulas.db? (Charles Kline 2001)
  59. where's Formulas.db? (Brian Wachter 2001)
  60. Re: formvars available in formulas.db? (John Butler 2000)
  61. formvars available in formulas.db? (John Butler 2000)
  62. Re: shipcost and Formulas.db (John Butler 2000)
  63. Re: shipcost and Formulas.db (Chris Vargas 2000)
  64. Re: shipcost and Formulas.db (Chris Vargas 2000)
  65. Re: shipcost and Formulas.db (John Butler 2000)
  66. shipcost and Formulas.db (Chris Vargas 2000)
  67. Re: Formulas.db (Jesse Williams Proudman 2000)
  68. Re: Formulas.db (PCS Technical Support 2000)
  69. Formulas.db (Jesse Williams Proudman 2000)
  70. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  71. Re: Frustration with formulas.db (Kevin Lippert 1999)
  72. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  73. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  74. Re: Frustration with formulas.db (Kenneth Grome 1999)
  75. Frustration with formulas.db (Kevin Lippert 1999)
  76. Re: Problem with Formulas.db (Brian Boegershausen 1999)
  77. Problem with Formulas.db (Karim Ardalan 1999)
  78. Re: Calculate UnitShipCost in Formulas.db (Smith Micro Support 1999)
  79. Re: Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  80. Re: Calculate UnitShipCost in Formulas.db (Chris Vargas 1999)
  81. Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  82. Re: formulas.db (Bob Minor 1999)
  83. Re: formulas.db (PCS Technical Support 1999)
  84. formulas.db (Mícheál O Sé 1999)
  85. formulas.db (Mícheál O Sé 1999)
  86. formulas.db and prices (Mike Jones 1999)
  87. Re: Custom formulas.db (PCS Technical Support 1998)
  88. Re: Custom formulas.db (Tim Taylor 1998)
  89. Re: Custom formulas.db (PCS Technical Support 1998)
  90. Re: Custom formulas.db (Kenneth Grome 1998)
  91. Re: Custom formulas.db (Tim Taylor 1998)
  92. Re: Custom formulas.db (Grant Hulbert 1998)
  93. Re: Custom formulas.db (Kenneth Grome 1998)
  94. Re: Custom formulas.db (PCS Technical Support 1998)
  95. Re: Custom formulas.db (Kenneth Grome 1998)
  96. Re: Custom formulas.db (PCS Technical Support 1998)
  97. Custom formulas.db (Tim Taylor 1998)
  98. Re: Problem with Formulas.db (Mike Heininger 1998)
  99. Re: Problem with Formulas.db (Mike Heininger 1998)
  100. Re: Problem with Formulas.db (Kenneth Grome 1998)
  101. Re: Problem with Formulas.db (PCS Technical Support 1998)
  102. Re: Problem with Formulas.db (Mícheál O Sé 1998)
  103. Problem with Formulas.db (Mike Heininger 1998)
  104. Re: formulas.db problem solved (Mark Mesenko 1998)
  105. Re: formulas.db ?? (Peter Ostry 1998)
  106. Re: formulas.db ?? (Kenneth Grome 1998)
  107. Re: formulas.db ?? (Mark Mesenko 1998)
  108. Re: formulas.db ?? (Kenneth Grome 1998)
  109. formulas.db ?? (Mark Mesenko 1998)
  110. Re: Allowed fields in formulas.db (Paul Willis 1998)
  111. Re: Formulas.db / Quantity Discount problem (PCS Technical Support 1998)
  112. Re:Formulas.db / Quantity Discount problem (PCS Technical Support 1998)
  113. Re: Allowed fields in formulas.db (PCS Technical Support 1998)
  114. Allowed fields in formulas.db (Paul Willis 1998)
  115. Re:Formulas.db / Quantity Discount problem (Paul Uttermohlen 1998)
  116. Re:Formulas.db / Quantity Discount problem (Jay Van Vark 1998)
  117. Formulas.db / Quantity Discount problem (Paul Uttermohlen 1998)
  118. Re: Formulas.db (Grant Hulbert 1997)
  119. Formulas.db (Ray Hatch 1997)
  120. Re: [search] in formulas.db (Grant Hulbert 1997)
  121. [search] in formulas.db (Mike Heininger 1997)
  122. Looking up two prices in Formulas.db ( 1997)
  123. Looking up two prices in Formulas.db ( 1997)
  124. RE: Formulas.db + Users.db (A. Waldeck 1997)
  125. RE: Formulas.db + Users.db (Grant Hulbert 1997)
  126. RE: Formulas.db + Users.db (Kenneth Grome 1997)
  127. RE: Formulas.db + Users.db (Kenneth Grome 1997)
  128. RE: Formulas.db + Users.db (grichter@panavise.com (Gary Richter) 1997)
  129. RE: Formulas.db + Users.db (Marc Eagle 1997)
  130. Re: Formulas.db + Users.db (Sven U. Grenander 1997)
  131. Re: Formulas.db + Users.db (Express Communications 1997)
  132. Re: Formulas.db + Users.db (Richard Wylie 1997)
  133. Formulas.db + Users.db (Paul Keen 1997)
  134. Re: Variable prices and Formulas.db (Grant Hulbert 1997)
  135. Variable prices and Formulas.db (Austin H. Spiegelman 1997)
  136. Re: WebCat2: Formulas.db question (Grant Hulbert 1997)
  137. WebCat2: Formulas.db question (Ed Trefzger 1997)
  138. Re: WC2b12: Yes, Formulas.db is for real (Kenneth Grome 1997)
  139. WC2b12: Yes, Formulas.db is for real (Grant Hulbert 1997)
  140. formulas.db (Terry Wilson The )
thanks.John Peacock wrote:> Donovan Brooke wrote: > > > > Hello, Our company has somewhat complex discounting for its products depending on sku, quantity etc... My question is should I > > do > > all the discount formulas in a formulas.db so that price is entered including the discounts > > in each item added to the cart? Since this has to be one line in a database the script could get long I think. > > Are there other solutions to complex discounting. > > thanks. > > If you do not do the discount calculations at the time of entering the item > into the cart, you will need to do a [lineitems] loop and set the price at > some time later in the transaction. If you allow the user to change the > quantities at some later time, you will need to do that too, to recalculate > the price (since the price formula is ONLY used when add a lineitem to the > cart). > > I believe people have in the past used include files to encapsulate the price > calculation (so it is available both at time of insertion into the cart as > well as later). > > It would be really useful to have a new context [RecalcCart] which would go > through all of the cart lines and redo the original price calculation. > > HTH > > John > > -- >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics------------------------------------------------------------- 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/ Donovan Brooke

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:

Nested search index (2000) WebCat editing, SiteGuard & SiteEdit (1997) Setting up shop (1997) unique ascending numbers (2003) WebCat2 beta 11 - new prefs ... (1997) WebCatalog Plug-in for Webstar. (1997) typhoon vs. webcatalog (1997) WebCat2 beta FTP site (1997) WebDNA within the shell (2004) Sku numbers (1997) template includes encrypted template (1999) Another bug -- in the docs ... (2002) _ in front of field name (1998) [WebDNA] help with [ReturnRaw] - why is it killing the parse of the [include] file? (2009) [cart] (1998) Shopping Cart ID (1998) Uh...can someone help me out with the b10? (1997) Online reference (1997) Banner Ads (2000) bug in [SendMail] (1997)