Re: Formulas.db
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40007
interpreted = N
texte = 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 atsome 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 pricecalculation (so it is available both at time of insertion into the cart aswell as later).It would be really useful to have a new context [RecalcCart] which would gothrough all of the cart lines and redo the original price calculation.HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------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:
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 atsome 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 pricecalculation (so it is available both at time of insertion into the cart aswell as later).It would be really useful to have a new context [RecalcCart] which would gothrough all of the cart lines and redo the original price calculation.HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------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 Peacock
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:
ShowNext Questions (2000)
Using "/" for path to virtual host root ? (2003)
Paths, relative paths, webstar server setup and security (1997)
Store Builder, technical infos (1998)
Date Problems (2000)
Log-in Scheme (2003)
Bit off subject -- Faxing orders (1997)
Slightly off-topic hits to purchase ratio? (1999)
ShippingCosts (1998)
Stumpted Again (1997)
Upgrading old WebCat Database Files (1997)
AccountAuthorizer doesn't seem to work (1997)
Need help with search title (1998)
Multiple Users.db Possible? (1997)
Solve the Problem, get the code! (2001)
[OT] MacWorld Expo (2004)
Navigator 4.01 (1997)
Apache suffix mapping for .tpl (2000)
WebCat2 beta 11 - new prefs ... (1997)
Webcat no longer supported? (2006)