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:
[sendmail]- bcc? (1998)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
Just Testing (1997)
Server crash (1997)
no emailfolder errors? (2000)
Banner DNA (1997)
Grouping search fields, etc. (1997)
how to know the [LineIndex] number webcat generated during a [AddLineItem]? (2000)
verify online (1997)
[WebDNA] Image resizing on the fly (2012)
emailer (1997)
NT vs Mac (1997)
Document Contains No Data (1998)
Text Areas, Sendmail and returns.... (2002)
WC2.0 Memory Requirements (1997)
checksum for Discover credit cards (1999)
Modifying order output (1997)
b12 cannot limit records returned and more. (1997)
[applescript] (1999)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)