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 got set up now, it looks like there's going to be an extra charge of $15 per order, because the shipCost formula (think of it has *handling*) is adding an extra base cost onto your already-correct unitShipCost calculation. I'd set the shipCost formula to 0.0 and let the unitShipCost do the work for you, 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 | Typhoon 619/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 got set up now, it looks like there's going to be an extra charge of $15 per order, because the shipCost formula (think of it has *handling*) is adding an extra base cost onto your already-correct unitShipCost calculation. I'd set the shipCost formula to 0.0 and let the unitShipCost do the work for you, 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 | 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:
NT [delete] (1998)
Help with Shipping Costs (1997)
[WebDNA] Emailer file size limits? (2020)
shownext problems (1998)
Almost a there but..bye bye NetCloak (1997)
Force a search at the default.tmpl page? (1997)
Re2: frames & carts (1997)
[ShowIf] a either fields are blank (1998)
[Search] on Remote Database (2000)
Opinion: [input] should be called [output] ... (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[ModDate] & [ModTime] ? (1997)
Bug Report, maybe (1997)
[WebDNA] Internal [ipaddress] ? (2009)
Pithy questions on webcommerce & siteedit (1997)
[WebDNA] Encode cookies ONLY via "method=Base64" (2008)
Does [Sendmail] create html? (2002)
[username][password] not showing up! HELP! (1999)
Date Sorting (1997)
Duplicate Cart Problem in Netscape (2000)