Re: shipping with weigth
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21991
interpreted = N
texte = >I want to calculate the shipping cost according to the weight of the >product. > >In the manual it says I have to have a perunitcost set in the formulas.db. > >But how exactly does it apply? I mean I have >unitShipCost [lookup >db=products.db&lookInField=sku&value=[sku]&returnField=weigth]I see in your formula that you are returning a weight for the unitShipCost. Since weight is not a currency, I suggest you instead return a dollar value. For instance, a bowling ball mmight cost $75 to ship, while a feather might cost $0.50 -- WebCatalog automatically multiplies the unitShipCost by the quantity (2 bowling balls will be $150) for you.This of course gets more complicated if you charge different amounts for different methods of shipping (FedX, UPS, Turtle).Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I want to calculate the shipping cost according to the weight of the >product. > >In the manual it says I have to have a perunitcost set in the
formulas.db. > >But how exactly does it apply? I mean I have >unitShipCost [lookup >db=products.db&lookInField=sku&value=[sku]&returnField=weigth]I see in your formula that you are returning a weight for the unitShipCost. Since weight is not a currency, I suggest you instead return a dollar value. For instance, a bowling ball mmight cost $75 to ship, while a feather might cost $0.50 -- WebCatalog automatically multiplies the unitShipCost by the quantity (2 bowling balls will be $150) for you.This of course gets more complicated if you charge different amounts for different methods of shipping (FedX, UPS, Turtle).Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
free shipping (2000)
Mass Mail (2000)
Rhapsody? (1997)
[WebDNA] Comparing fields in a search (2010)
Multiple Newcarts (1996)
WebCatalog for guestbook ? (1997)
MacAuthorize order data fields WAS:How To question... (1997)
WebTV, IPAddress, Cookies, IDEAS?? (1998)
WebCatalog2 Feature Feedback (1996)
Download Question (1997)
RE: E-mailer error codes (1997)
[WebDNA] How to create a MD5 hash & decrypt it (2011)
Newbie questions (1999)
[Sum] function? (1997)
Requiring that certain fields be completed (1997)
psst (1997)
Dumb Question about Docs (1997)
Harvesting invalid email addresses from bounced emails??? (2000)
Strange Search Results (2004)
webcat NT (1998)