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:

So many lookers, hey smith micro (2003) Damn actions/links...... (2001) WebDNAmonitor running but webcat won't start. (2002) 2.0 Info (1997) ShowNext (1997) Bug or syntax error on my part? (1997) Meet your competition (2000) can WC render sites out? (1997) A multi-processor savvy WebCatalog? (1997) [format] (1998) Moment of Thanks (1997) PIXO support (1997) Navigator 4.0 & tables (1997) RE: ShowNext Command (1997) Kaaaaahhhhhhhnnnnnnn! (1997) Problems setting MIME Headers (1998) Thanks Grant (1997) Ooops-Serial Number for NT (1997) 4D Database (1997) Great product and great job ! (1997)