Re: Shipping still a problem!!

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21855
interpreted = N
texte = Jim,It looks like you just need to remove the shipCost calculation out of the formulas.db, and just use unitShipCost like so:unitShipCost [lookup db=shipcosts.db&LookInField=shipMethod&value=[shipVia]&returnField=ShipCost¬Found=0](Of course, I am assuming that the shipping costs are identical for each product, is this correct?) Let me know if that helps.JohnJim O'Connor wrote: > > Will someone PLEASE help me out with a straight answer here! > > The situation: > > I have to charge shipping based on this formula - shipVia * total number > of items ordered > > example - Canada UPS $15.00 * 3 copies of software = $45.00 > Example data is: > > in the mainevent.db - > 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.00 > > On the Invoice I cakll for unitShipCost and shippingTotal > > Can someone tell me what's going wrong? > > Thanks, > > Jim 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)
Jim,It looks like you just need to remove the shipCost calculation out of the formulas.db, and just use unitShipCost like so:unitShipCost [lookup db=shipcosts.db&LookInField=shipMethod&value=[shipVia]&returnField=ShipCost¬Found=0](Of course, I am assuming that the shipping costs are identical for each product, is this correct?) Let me know if that helps.JohnJim O'Connor wrote: > > Will someone PLEASE help me out with a straight answer here! > > The situation: > > I have to charge shipping based on this formula - shipVia * total number > of items ordered > > example - Canada UPS $15.00 * 3 copies of software = $45.00 > Example data is: > > in the mainevent.db - > 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.00 > > On the Invoice I cakll for unitShipCost and shippingTotal > > Can someone tell me what's going wrong? > > Thanks, > > Jim John W

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:

Configuring E-mail (1997) Security Issues and WebCommerce Solution (1997) test -- ignore (2000) [WebDNA] WebDNA Showcase? (2008) [WebDNA] Digest (2008) Further tests with the infamous shipCost (1997) ReturnRaw and redirect (1997) Sorting by type=date (1999) [WebDNA] fileinfo question (2016) Secure Web Server (1999) Problems with [Applescript] (1997) WC2b15 File Corruption (1997) [TaxableTotal] - not working with AOL and IE (1997) [WebDNA] Friday's.. WIP thread (2009) SIMS setup (1998) SAVECART (1997) Still having problems with Authen (1997) [date] problem with %d%m%Y (1998) HELP WITH DATES (1997) Pull Down Search (2000)