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:
>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:
HELP WITH DATES (1997)
WebCatalog can't find database (1997)
Server Load (2000)
search form problem.. (1997)
WebCat on Alpha? (1997)
Location of Browser Info.txt file (1997)
Thanks and new Question on lineitems (2002)
File Upload (1997)
Format question WC Mac f3 (1997)
[WebDNA] File not found when trying to install WebDNA on Debian (2016)
Review comparison by PC Magazine: Open for On-line Business (1997)
many-to-one problem (1998)
WebCat2b12 CGI Mac - [shownext] problem (1997)
WebCatalog can't find database (1997)
RE: Formulas.db + Users.db (1997)
Hiding Brands (2004)
Great product and great job ! (1997)
Plugin or CGI or both (1997)
Listserver problem (1997)
Date sorting (1997)