Re: adding shipping cost

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18643
interpreted = N
texte = >Quick question - If I have a shipping scale that looks like the following: >up to $99.99 = $8.00 shipping/handling >$100.00 to 199.99 = $11.00 s/h >etc.Since you are probably going to have a long list of price breakdowns, the best solution here is to create a database with the price ranges in it, and then perform a search to get the right shipping charge. For clarity, this is preferable to a bunch of nested [ShowIf] tags.I'd create a database like this: -- ShipTable.db -- Amount Shipping 0.00 8.00 100.00 11.00 200.00 13.00..and I'd put a shipCost formula in like this: -- Formulas.db -- shipCost [search db=ShipTable.db&leAmountdata=[subtotal]&deAmountsort=1&Amounttype=num&max=1][fou nditems][Shipping][/founditems][/search]The search finds all the shipping charges up to the highest allowable charge, but since it sorts in descending order and returns only 1 item (max=1), it effectively finds only the 1 shipping charge that pertains.Make sure you don't type any extra carriage returns on that formula: it should be one big long line with a tab after the shipCost text. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: adding shipping cost (PCS Technical Support 1998)
  2. adding shipping cost (Michael Di Filippo 1998)
  3. Re: Adding Shipping Costs based on percent of subtotal (Grant Hulbert 1997)
  4. Adding Shipping Costs based on percent of subtotal (McDonald, Jim 1997)
>Quick question - If I have a shipping scale that looks like the following: >up to $99.99 = $8.00 shipping/handling >$100.00 to 199.99 = $11.00 s/h >etc.Since you are probably going to have a long list of price breakdowns, the best solution here is to create a database with the price ranges in it, and then perform a search to get the right shipping charge. For clarity, this is preferable to a bunch of nested [showif] tags.I'd create a database like this: -- ShipTable.db -- Amount Shipping 0.00 8.00 100.00 11.00 200.00 13.00..and I'd put a shipCost formula in like this: -- formulas.db -- shipCost [search db=ShipTable.db&leAmountdata=[subtotal]&deAmountsort=1&Amounttype=num&max=1][fou nditems][Shipping][/founditems][/search]The search finds all the shipping charges up to the highest allowable charge, but since it sorts in descending order and returns only 1 item (max=1), it effectively finds only the 1 shipping charge that pertains.Make sure you don't type any extra carriage returns on that formula: it should be one big long line with a tab after the shipCost text. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

[ShowCart] and GET vs. POST (1997) Deleting Orders (1997) Suggestions (1998) [OT] PHP?MySQL Help Needed (2003) Just Testing (1997) shell problem (2003) Protect (1997) Converting characters to numbers ... (1997) Configuring E-mail (1997) Search bug. Help (2002) TCP connect, how long does it take (PCS please) (1999) migrating from MacOS to unix (2000) Database Security (1998) Separate SSL Server (1997) Emailer help....! (1997) WebDNA + SQL Server (2003) webcat (2000) Comments in db? (1997) [WebDNA] [Orderfile] problem (2009) emailer (1997)