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 ofthe formulas.db, and just use unitShipCost like so:unitShipCost [lookupdb=shipcosts.db&LookInField=shipMethod&value=[shipVia]&returnField=ShipCost¬Found=0](Of course, I am assuming that the shipping costs are identical for eachproduct, 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:
Jim,It looks like you just need to remove the shipCost calculation out ofthe
formulas.db, and just use unitShipCost like so:unitShipCost [lookupdb=shipcosts.db&LookInField=shipMethod&value=[shipVia]&returnField=ShipCost¬Found=0](Of course, I am assuming that the shipping costs are identical for eachproduct, 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)