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:
remotely creating and populating a stock inventory db -almost there! (1999)
show all problem (1997)
Re1000001: Setting up shop (1997)
Just Testing (1997)
Price Not Appearing (2000)
Forbidden CGI Error (1997)
OT: Processor Speed (2002)
Search design (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
Trouble installing WebCat on OSX apache .. (2001)
[WebDNA] Installing 6.0 onto Server 2008 (2011)
Shoppingcart passing price (2000)
Max Record length (1997)
List Address Changed! (1998)
webdelivery.html and webna (1997)
TCP connect, how long does it take (PCS please) (1999)
Error.html (1997)
problems with 2 tags (1997)
Separate SSL Server (1997)
WebCatalog 4.0 has been released! (2000)