Re: shipping costs

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26723
interpreted = N
texte = I did have success with showif and hideif finally. but taxes got screwy, since those are added to achieve the Grandtotal and I was hiding grandtotal and substituting subtotal in its place if subtotal was >50.00I'll try the new formula----- Original Message ----- From: PCS Technical Support To: WebCatalog Talk Sent: Saturday, January 29, 2000 7:34 PM Subject: Re: shipping costs > >I have a unitShipCost for each item in the database > >In formulas.db I have the shipcost set to 0.00 > > > >This works out fine . . . . but one the total order equals $50.00 shipping > >will be free. > > This one is a little bit complex, because you're basically asking it > to throw out the old shipCost calculation and replace it with a new > one 'after the fact'. I think the following formula should work: > > -- Formulas.db -- > Name Formula > shipCost [math > show=f]tempSC=[lineitems][quantity]*[unitshipcost]+[/lineitems]0[/math > ][showif [subtotal]>50]-[tempSC][/showif][hideif > [subtotal]>50][tempSC][/hideif] > > This email will have a linebreak in the middle of the formula > somewhere; you should make sure this is all on one line to work > properly in your formulas.db. > > What we're doing with this formula is to first loop thru all the > lineitems and use math to compute the qty*unitshipcost total for all > items, then we decide if the order is more than $50. If so, we send > back a *negative* shipCost, which sort of 'removes' the original > shipping cost from the grand total. If the order is more than $50, > we simply return the shipCost we just computed. > > Technical Support ********************************** > Smith Micro, Internet Solutions Div | Formerly, Pacific Coast Software > 16855 West Bernardo Drive | ------------------------- > Suite 380 | eCommerce (WebCatalog) > San Diego, CA 92127 | Software & Site Development > 858.675.1106 | http://www.smithmicro.com > 858.675.0372 (fax) ********************************** > > ------------------------------------------------------------- > 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 > > ------------------------------------------------------------- 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:

    
  1. Re: Shipping costs question (Donovan 2002)
  2. Re: Shipping costs question - update (Mark Derrick 2002)
  3. Re: Shipping costs question (Mark Derrick 2002)
  4. Re: Shipping costs question (Donovan Brooke 2002)
  5. Re: Shipping costs question (lb Lawrence 2002)
  6. Shipping costs question (Mark Derrick 2002)
  7. Shipping costs... (…©rßa 2000)
  8. Re: shipping costs (Richard 2000)
  9. Re: shipping costs (PCS Technical Support 2000)
  10. Re: shipping costs (Chris Vargas 2000)
  11. Re: shipping costs (Richard 2000)
  12. Re: shipping costs (Stuart Tremain 2000)
  13. shipping costs (Richard 2000)
  14. Re: Zeroing out shipping costs (Sam Lewis 2000)
  15. Re: Zeroing out shipping costs (Chris Vargas 2000)
  16. Re: Zeroing out shipping costs (Sam Lewis 2000)
  17. Zeroing out shipping costs (Chris Vargas 2000)
  18. Re: shipping costs (Chris Vargas 1999)
  19. shipping costs (Steve Chun 1999)
  20. Re: calculating shipping costs by a sum of weights (Tim Taylor 1999)
  21. calculating shipping costs by a sum of weights (John Butler 1999)
  22. Shipping Costs (hubert marczuk 1999)
  23. Re: shipping costs (Kenneth Grome 1998)
  24. shipping costs (charles kline 1998)
  25. Re: Shipping costs again (PCS Technical Support 1998)
  26. Shipping costs again (greg 1998)
  27. Recalculating Shipping Costs (McDonald, Jim 1997)
  28. Shipping Costs Not Updating When Adding Items (McDonald, Jim 1997)
  29. Re: Adding Shipping Costs based on percent of subtotal (Grant Hulbert 1997)
  30. Adding Shipping Costs based on percent of subtotal (McDonald, Jim 1997)
  31. Re: Help with Shipping Costs (bob 1997)
  32. Re: Help with Shipping Costs (Ken Kohn 1997)
  33. Re: Help with Shipping Costs (Grant Hulbert 1997)
  34. Help with Shipping Costs (Ken Kohn 1997)
  35. Re: shipping costs (Richard Wylie 1997)
  36. shipping costs (Kevin Furuta 1997)
I did have success with showif and hideif finally. but taxes got screwy, since those are added to achieve the Grandtotal and I was hiding grandtotal and substituting subtotal in its place if subtotal was >50.00I'll try the new formula----- Original Message ----- From: PCS Technical Support To: WebCatalog Talk Sent: Saturday, January 29, 2000 7:34 PM Subject: Re: shipping costs > >I have a unitShipCost for each item in the database > >In formulas.db I have the shipcost set to 0.00 > > > >This works out fine . . . . but one the total order equals $50.00 shipping > >will be free. > > This one is a little bit complex, because you're basically asking it > to throw out the old shipCost calculation and replace it with a new > one 'after the fact'. I think the following formula should work: > > -- formulas.db -- > Name Formula > shipCost [math > show=f]tempSC=[lineitems][quantity]*[unitshipcost]+[/lineitems]0[/math > ][showif [subtotal]>50]-[tempSC][/showif][hideif > [subtotal]>50][tempSC][/hideif] > > This email will have a linebreak in the middle of the formula > somewhere; you should make sure this is all on one line to work > properly in your formulas.db. > > What we're doing with this formula is to first loop thru all the > lineitems and use math to compute the qty*unitshipcost total for all > items, then we decide if the order is more than $50. If so, we send > back a *negative* shipCost, which sort of 'removes' the original > shipping cost from the grand total. If the order is more than $50, > we simply return the shipCost we just computed. > > Technical Support ********************************** > Smith Micro, Internet Solutions Div | Formerly, Pacific Coast Software > 16855 West Bernardo Drive | ------------------------- > Suite 380 | eCommerce (WebCatalog) > San Diego, CA 92127 | Software & Site Development > 858.675.1106 | http://www.smithmicro.com > 858.675.0372 (fax) ********************************** > > ------------------------------------------------------------- > 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 > > ------------------------------------------------------------- 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 Richard

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:

[WebDNA] Error: Can't open order file. Ignoring [OrderFile] context Error: Error: expected [/APPLICATION], but found [/!] instead[/!] (2011) Post arguments problem mac? (1997) Secure server question (1997) [movefile] prob (2005) PCS Frames (1997) Reversed words (1997) SiteEditPro (1996) Drop Down Menus (2002) searching with groups (1997) linetiems in thankyou.tpl (1997) Searching an Email database (1997) TaxTotal Problem (1997) [referrer] tag (1997) web delivery (1997) getmimeheader host on my local machine (2003) RAM variables (1997) Multiple security dbs (1997) Dumb Question about Docs (1997) [OT] KeepItUp for Windows (2003) Migrating to NT (1997)