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, thebest solution here is to create a database with the price ranges in it, andthen perform a search to get the right shipping charge. For clarity, thisis preferable to a bunch of nested [ShowIf] tags.I'd create a database like this:-- ShipTable.db --Amount Shipping0.00 8.00100.00 11.00200.00 13.00..and I'd put a shipCost formula in like this:-- Formulas.db --shipCost [searchdb=ShipTable.db&leAmountdata=[subtotal]&deAmountsort=1&Amounttype=num&max=1][founditems][Shipping][/founditems][/search]The search finds all the shipping charges up to the highest allowablecharge, 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: itshould 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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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, thebest solution here is to create a database with the price ranges in it, andthen perform a search to get the right shipping charge. For clarity, thisis preferable to a bunch of nested
[showif] tags.I'd create a database like this:-- ShipTable.db --Amount Shipping0.00 8.00100.00 11.00200.00 13.00..and I'd put a shipCost formula in like this:--
formulas.db --shipCost [searchdb=ShipTable.db&leAmountdata=[subtotal]&deAmountsort=1&Amounttype=num&max=1][founditems][Shipping][/founditems][/search]The search finds all the shipping charges up to the highest allowablecharge, 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: itshould 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 | Typhoon619/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)