shipcost and Formulas.db
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26840
interpreted = N
texte = After seeing a recent posting with a similar situation, I'm back to trying to use Formulas.db to solve my shipping situation, which is:* use a flat rate depending on user-selected shipping method (stored in [shipvia]) * charge that flat rate for one shippable item * charge $2 more per additional shippable item * charge $0 for any downloadables * therefore, if all ordered items are DLable only, shipcost should be $0 instead of whatever was selected as a shipping method.Here is my Formulas.db. I apologize for bad breaks: Yahoo mail really stinks in that regard... Name Formula shipCost [math show=f]temptotship=[lineitems][unitShipCost]+[/lineitems]0[/math][math show=f]baserate=[lookup db=admin/shippers.db&lookinfield=SHR_ID&value=[shipVia]&returnfield=SHR_AMT]-2[/math][hideif temptotship=0][baserate][/hideif][showif temptotship=0]0[/showif]What happens is that the baserate is being charged, even if all the lineitems are downloadable and thus have unitshipcost of 0.So I'm still having a problem zeroing out shipcost. What am I doing wrong or leaving out? Thanks for any guidance.__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
After seeing a recent posting with a similar situation, I'm back to trying to use formulas.db to solve my shipping situation, which is:* use a flat rate depending on user-selected shipping method (stored in [shipvia]) * charge that flat rate for one shippable item * charge $2 more per additional shippable item * charge $0 for any downloadables * therefore, if all ordered items are DLable only, shipcost should be $0 instead of whatever was selected as a shipping method.Here is my formulas.db. I apologize for bad breaks: Yahoo mail really stinks in that regard... Name Formula shipCost [math show=f]temptotship=[lineitems][unitShipCost]+[/lineitems]0[/math][math show=f]baserate=[lookup db=admin/shippers.db&lookinfield=SHR_ID&value=[shipVia]&returnfield=SHR_AMT]-2[/math][hideif temptotship=0][baserate][/hideif][showif temptotship=0]0[/showif]What happens is that the baserate is being charged, even if all the lineitems are downloadable and thus have unitshipcost of 0.So I'm still having a problem zeroing out shipcost. What am I doing wrong or leaving out? Thanks for any guidance.__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Chris Vargas
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:
California Tax Rates (1998)
[orderfile Orders/[cart]] (2000)
OK, here goes... (1997)
Time to opensource? was [SMSI] WebDNA is too good to go (2006)
[WebDNA] Looking for WebDNA help (2013)
authenticating a second user, the sequel (1997)
OT: Website Promotion (1998)
Upload and WebCat (1998)
Unexceling (was I need a smart quote...) (1999)
Webmerchant/Cybercash (2000)
[WebDNA] WebDNA Not Sending Email (2009)
[LOOKUP] (1997)
OT: Google image search results (2004)
WebCat editing, SiteGuard & SiteEdit (1997)
Fwd: Problem with order (1998)
More on the email templates (1997)
[SHOWIF]s and empty arguments (1997)
Emailer Q (2002)
WebCatalog-NT?'s (1996)
Grouping search fields, etc. (1997)