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:

More on the email templates (1997) RED QUESTION MARKS AGAIN (1999) suggestion (1997) Upload (1998) Narrowing NT Crashing error (2000) different ship dates and shopping carts -- how to? (1997) REPOST: How do _you_ back up your db? (2000) PCS Frames (1997) WebDNA and SQL (2003) So when do we get something similar? (1998) limitation found on group searching (1997) Undeclared variables (2004) Other tags inside the founditems context? (1998) Add a Blog to your site. (2002) Thanks and Big News!!! (1997) SiteEdit Pro Update Announcement (1997) What am I doing wrong? (2000) Possible Bug in 2.0b15.acgi (1997) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) Dynamic PDFs? (2002)