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:
Nested tags count question (1997)
WebCatalog on G3 Macs? (1997)
[cart]'s ever get recycled? (2000)
OK, here goes... (1997)
Version 2.1.3 changes ... (1998)
Country & Ship-to address & other fields ? (1997)
[WebDNA] CICADA (2008)
problem serving foreign languages text (1997)
WebCommerce Security Alert! (1996)
success - serial numbers and webmerch (1997)
Speed Admin? (Was FlushDatabases) (1997)
Adding up line items. (2000)
Mac: [ListFiles] bug alert (1997)
Multi-Row Tables from a search. (1997)
Sorting (2000)
Anyone using [sendmail] for HTML encoded mail? (2000)
Upgrading old WebCat Database Files (1997)
[WebDNA] TCPConnect assist (2016)
Sort Issue? (2000)
Logical and or in [hideif] (1997)