Re: Prices coming up 0.00
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39991
interpreted = N
texte = > > > You need price in only one place. > >But there is no harm in having it both places. I gotta differ with you on that one, JP.Aside from a duplication of effort, there's always some chance that a price may be changed in one place, but not in the other. IMHO, it's not good practice to do stuff twice when once is enough.Using a formula to calculate a different price from that in the product db is useful, but unless there is a reason to change it, let the price in the product db stand on its own and forget using a formula.>From the PDF docs:>Every time a product is added to the shopping cart, WebCatalog calculates >the item's price, unit ship cost, ship cost, and tax rate in the following >manner: >WebCatalog first looks for a file called Formulas.db in the same folder as >the shopping cart template itself, and looks there for a formula named >price. If the Formulas.db database has a price formula, WebCatalog evaluates >the WebDNA expression comprising the formula *****within the context >of the current shopping cart file****, so that the value of tags such as [zip] and >[SKU] are available for the calculation. Then it sets the price of the product >based on the calculated formula, or if no formula is found, simply uses the >value of the price field corresponding to the item's SKU from the product >database. WebCatalog repeats the same steps for unitShipCost as well.------------------------------------------------------------- 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:
> > > You need price in only one place. > >But there is no harm in having it both places. I gotta differ with you on that one, JP.Aside from a duplication of effort, there's always some chance that a price may be changed in one place, but not in the other. IMHO, it's not good practice to do stuff twice when once is enough.Using a formula to calculate a different price from that in the product db is useful, but unless there is a reason to change it, let the price in the product db stand on its own and forget using a formula.>From the PDF docs:>Every time a product is added to the shopping cart, WebCatalog calculates >the item's price, unit ship cost, ship cost, and tax rate in the following >manner: >WebCatalog first looks for a file called formulas.db in the same folder as >the shopping cart template itself, and looks there for a formula named >price. If the formulas.db database has a price formula, WebCatalog evaluates >the WebDNA expression comprising the formula *****within the context >of the current shopping cart file****, so that the value of tags such as [zip] and >[SKU] are available for the calculation. Then it sets the price of the product >based on the calculated formula, or if no formula is found, simply uses the >value of the price field corresponding to the item's SKU from the product >database. WebCatalog repeats the same steps for unitShipCost as well.------------------------------------------------------------- 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/
Glenn Busbin
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:
[OT] Security in general [Was] WebDNA security (2004)
back button loses cart (2000)
Upgrading old WebCat Database Files (1997)
Email problem.. (2004)
emailer (1997)
web merchant (2000)
Shoppingcart passing price (2000)
In Digest Dijon (2000)
[Case] on OS X (2000)
WebCatalog2 Feature Feedback (1996)
Multiple prices (1997)
remotely creating and populating a stock inventory db - almost there! (1999)
SPAM (OT) (2004)
Error Log.db --however (1997)
So, does anyone have developer editon running on Win XP Pro? (2006)
Return records from another (1997)
Nested tags count question (1997)
Re:no template caching (1997)
this works sometimes and sometimes not (1997)
replacing items in a db (2000)