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:

Free WebDNA snippets (Extending WebCatalog) (1997) suffix mapping, use of cache, etc. (1997) New public beta available (1997) Nested vs conditional (1997) Banners (1997) Ampersand (1997) RE: Loss in form (1998) WebCatalog2 Feature Feedback (1996) Upgrading old WebCat Database Files (1997) Clean Code: Rules for inserting keyboard returns? (1997) [REPLACE] inside [FOUNDITEMS] (1998) WebMerchant 3.0 for Mac shipping now (1998) Search design (1997) international time (1997) WebDNA Solutions ... (1997) HELP WITH DATES (1997) RE: protect tag not working (1998) Live server problems (1999) WebCat2: Items xx to xx shown, etc. (1997) Languages (1997)