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:

    
  1. Re: Shipping still a problem!! (John W 1998)
  2. Re: Shipping still a problem!! (PCS Technical Support 1998)
  3. Shipping still a problem!! (Jim O'Connor 1998)
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:

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)