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:

[isfile] ? (1997) test (2000) shownext & math (1997) WCf2 and nested tags (1997) New Command prefs ... (1997) ReturnRaw and redirect one last question (1997) Encrypt/decrypt bug in 3.0.5b12 (1999) Emailer (1997) Can someone help? (2000) Odd request (2003) Upgrade to 4.0 (2001) [SearchString] usage (1997) syntax question, not in online refernce (1997) My slower response (1997) failure to encrypt (or maybe decrypt) (1999) WebCat2 beta 11 - new prefs ... (1997) server2003 isolation mode (2004) Running subtotal? (1998) [WebDNA] New request for websites that currently run WebDNA (2009) WebCatalog for WebStar V (2001)