Re: Shipping still a problem!!
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21850
interpreted = N
texte = What wrong numbers are you getting right now? Judging from what you've gotset up now, it looks like there's going to be an extra charge of $15 perorder, because the shipCost formula (think of it has *handling*) is addingan extra base cost onto your already-correct unitShipCost calculation. I'dset the shipCost formula to 0.0 and let the unitShipCost do the work foryou, because it sounds like that's your model for shipping charges.>SKU Title Price Domestic Canada Intnl>001 PhotoScripter - Single User 299.00 7 15 25>002 Scripter 2 199.00 7 15 25>003 ScriptBase 59.00 7 15 25>>in Formulas.db ->Name Formula>shipCost [lookup>db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]>>unitShipCost [lookup>db=mainevent.db&lookInField=sku&value=[sku]&returnField=[shipVia]]>>in ShipCosts.db ->ShipMethod ShipCost>Domestic 7.00>Canada 15.00>Intnl 25.00Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
What wrong numbers are you getting right now? Judging from what you've gotset up now, it looks like there's going to be an extra charge of $15 perorder, because the shipCost formula (think of it has *handling*) is addingan extra base cost onto your already-correct unitShipCost calculation. I'dset the shipCost formula to 0.0 and let the unitShipCost do the work foryou, because it sounds like that's your model for shipping charges.>SKU Title Price Domestic Canada Intnl>001 PhotoScripter - Single User 299.00 7 15 25>002 Scripter 2 199.00 7 15 25>003 ScriptBase 59.00 7 15 25>>in
formulas.db ->Name Formula>shipCost [lookup>db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]>>unitShipCost [lookup>db=mainevent.db&lookInField=sku&value=[sku]&returnField=[shipVia]]>>in ShipCosts.db ->ShipMethod ShipCost>Domestic 7.00>Canada 15.00>Intnl 25.00Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/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:
Date Range Sorting (1997)
Emailer (1997)
NT vs Mac (1997)
WebCat cannot handle compatible search parameters? (1997)
hiding links (1999)
quick setheader questions... (2000)
serial number not working-fixed (1998)
Listserver problem (1997)
[searchString] (1997)
any suggestions for creating a multi-lingual site? (1999)
Taxable Shipping (2003)
WebCatalog Hosting (1996)
[Sum] function? (1997)
Help! WebCat2 bug (Ben's input) (1997)
Windows 2.1b4 WebCatalog available (1997)
[what] [am] [I] [missing]? (2003)
shipcost (1997)
WebCat hosting providers? (1997)
[WebDNA] 301 redirect on linux (2010)
Exclude by date - multiple (1997)