Re: shipping costs

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12397
interpreted = N
texte = >Some of the products we are going to offer will be via electronic delivery >and will incur no shipping charges. However, they will be on sale with >products that will incur shipping charges. What settings, if any, on the >unitshipcost do I need to do to seperate the two when calculating the total >shipping costs.What about using a canemail field for the item. So if it is email able it is set to True, else false.That means you can put a shipping cost against it for when it's sent via snail mail.So, if the user orders the goods and they want them sent via emial then the shipping is set to $0.00So, I'd still use unitshipcost just incase, and use a series of [showif] commands to determine the calculation if its emailed. Something like this.In your formulae database you would have Name Formula shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost ] in your ship costs database you would haveShipMethod ShipCost Japan 25.00 USA 50.00 EMAIL 0.00This would refernce the selection in your invoice template when people select their prefered shipping choice.Hope this helps.cheers,Rick---------------------------------------------------------------------------Key Options Pty. Ltd. P.O. Box 1150 Castle Hill, NSW, 2154 AustraliaTel:+61-2-9899-9564 Fax:+61-2-9899-9318 Mob: 0412-205-113-----BEGIN PGP PUBLIC KEY BLOCK-----mQBPAzNMLcoAAAECAL5yuN2krMXeMwfcZPvWFJ0d6oMd++Pafsx0MkIGoTmHLz9i LYHOiyZfeWNcLRd4c6xHlPN36lyPe9Uw9jwbaQEAEQEAAbQiUmljaGFyZCBXeWxp ZSA8cmlja3dAbWFnbmEuY29tLmF1PokAVQMFEDNLoSp71TD2PBtpAQEB3kMCAKQ5 zd+aPODE2zw2Rht1duf4kVV6yXdC+ZSGYT0uGmkidgHS/Jw+uJvzHnKvR2ziAFrV pYMY6WMaf06yWFvekvc= =prwK -----END PGP PUBLIC KEY BLOCK----- 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)
>Some of the products we are going to offer will be via electronic delivery >and will incur no shipping charges. However, they will be on sale with >products that will incur shipping charges. What settings, if any, on the >unitshipcost do I need to do to seperate the two when calculating the total >shipping costs.What about using a canemail field for the item. So if it is email able it is set to True, else false.That means you can put a shipping cost against it for when it's sent via snail mail.So, if the user orders the goods and they want them sent via emial then the shipping is set to $0.00So, I'd still use unitshipcost just incase, and use a series of [showif] commands to determine the calculation if its emailed. Something like this.In your formulae database you would have Name Formula shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost ] in your ship costs database you would haveShipMethod ShipCost Japan 25.00 USA 50.00 EMAIL 0.00This would refernce the selection in your invoice template when people select their prefered shipping choice.Hope this helps.cheers,Rick---------------------------------------------------------------------------Key Options Pty. Ltd. P.O. Box 1150 Castle Hill, NSW, 2154 AustraliaTel:+61-2-9899-9564 Fax:+61-2-9899-9318 Mob: 0412-205-113-----BEGIN PGP PUBLIC KEY BLOCK-----mQBPAzNMLcoAAAECAL5yuN2krMXeMwfcZPvWFJ0d6oMd++Pafsx0MkIGoTmHLz9i LYHOiyZfeWNcLRd4c6xHlPN36lyPe9Uw9jwbaQEAEQEAAbQiUmljaGFyZCBXeWxp ZSA8cmlja3dAbWFnbmEuY29tLmF1PokAVQMFEDNLoSp71TD2PBtpAQEB3kMCAKQ5 zd+aPODE2zw2Rht1duf4kVV6yXdC+ZSGYT0uGmkidgHS/Jw+uJvzHnKvR2ziAFrV pYMY6WMaf06yWFvekvc= =prwK -----END PGP PUBLIC KEY BLOCK----- Richard Wylie

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:

WebCat 3? (2000) Problems getting parameters passed into email. (1997) Need help (1998) Buying sans cart (1997) [WebDNA] INCLUDE file= in the footer (2009) Calculating multiple shipping... (1997) temporary database? an aside (2000) GoLive CyberStudio 1.0.1 (1997) [WebDNA] What am I doing wrong with authenticate (2012) Multiple prices (1997) Migrating to NT -Reply (1997) Sendmail Excel attachment (2003) New Installation (1998) Web Catalog 2 demo (1997) What date is it anyway? (2004) Paranoid about serial numbers...not (1998) Pass a form addendum (2003) [table] retained in memory (2006) using showpage and showcart commands (1996) WebCommerce: Folder organization ? (1997)