Re2: Calculating multiple shipping...
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10379
interpreted = N
texte = >WebCat2 can evaluate a formula of your choice for price, unitShipCost, >taxRate, and shipCost -- the GeneralStore gives an example that chooses >different base shipCosts based on a Ground/Air/NextDay popup. If no >formula is present (for price, let's say), then the amount is simply >looked up in the product database under that SKU's price field. > >You would put something like the following into the Formulas.db file, and >make sure the visitor chooses Air/Ground/NextDay before putting stuff in >the cart: > >shipCost
[showif [shipVia]=Ground]5.00[/showif][showif >[shipVia]=Air]7.00[/showif] >unitShipCost [showif [shipVia]=Ground]0.30[/showif][showif >[shipVia]=Air]0.80[/showif] > >This is a simple example; you can do [lookups] and [math] in those >formulas too. Any WebDNA script will work. For example, if you wanted to >look up that particular SKU's unitShipCost instead of fixing it at $.30, >you could use the following formula: > >unitShipCost [lookup >db=catalog.txt&lookInField=SKU&value=[sku]&returnField=unitShipCost] > >You could throw some [math] around that formula, or look in a different >field based on what [shipVia] was set in the shopping cart. ROCK & ROLL!!!!!!Cool....even simpler to do than I thought. I was trying to make it really hard to do. Thanks!I didn't even know there was a Formulas.db file or how to use the more advanced features of WebDNA. Do you have any docs on this yet (even beta docs would help)? I know it's probably in the downloaded files I have but if you could push me in the right direction...--BenWebWright, Inc. Make a Presence. (409) 268-3022------------------------------------ To leave this talk list send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Associated Messages, from the most recent to the oldest:
| |
- Re2: Calculating multiple shipping... (ben 1997)
|
>WebCat2 can evaluate a formula of your choice for price, unitShipCost, >taxRate, and shipCost -- the GeneralStore gives an example that chooses >different base shipCosts based on a Ground/Air/NextDay popup. If no >formula is present (for price, let's say), then the amount is simply >looked up in the product database under that SKU's price field. > >You would put something like the following into the formulas.db file, and >make sure the visitor chooses Air/Ground/NextDay before putting stuff in >the cart: > >shipCost [showif [shipVia]=Ground]5.00[/showif][showif >[shipVia]=Air]7.00[/showif] >unitShipCost [showif [shipVia]=Ground]0.30[/showif][showif >[shipVia]=Air]0.80[/showif] > >This is a simple example; you can do [lookups] and [math] in those >formulas too. Any WebDNA script will work. For example, if you wanted to >look up that particular SKU's unitShipCost instead of fixing it at $.30, >you could use the following formula: > >unitShipCost [lookup >db=catalog.txt&lookInField=SKU&value=[sku]&returnField=unitShipCost] > >You could throw some [math] around that formula, or look in a different >field based on what [shipVia] was set in the shopping cart. ROCK & ROLL!!!!!!Cool....even simpler to do than I thought. I was trying to make it really hard to do. Thanks!I didn't even know there was a formulas.db file or how to use the more advanced features of WebDNA. Do you have any docs on this yet (even beta docs would help)? I know it's probably in the downloaded files I have but if you could push me in the right direction...--BenWebWright, Inc. Make a Presence. (409) 268-3022------------------------------------ To leave this Talk List send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
ben
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:
Problems with [Applescript] (1997)
RE: [REPLACE] inside [FOUNDITEMS] (1998)
Pulling Captions from JPGs (2003)
[LOOKUP] (1997)
[OT]Co-Location of a Server (2002)
Re:2nd WebCatalog2 Feature Request (1996)
cookies (2001)
Code sample - links.tpl (2002)
StoreBuilder UPS/XML code question ... (2003)
REPOST: How do _you_ back up your db? (2000)
Problems with [Applescript] (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
searching for items that begin with a number (2004)
WebCatalog for guestbook ? (1997)
For those of you not on the WebCatalog Beta... (1997)
Version 4? (2000)
Merchant account (1998)
RE: Forcing Paragraph Breaks on Results (1998)
Search Engine questions ... (2002)
HomePage Caution (1997)