Recalculating Shipping Costs
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15270
interpreted = N
texte = Grant:You were so kind to give me a cost variable solution to shipping costs based on subtotals. However, when a customer adds to their cart by going back to our search page, the subtotal does not recalculate and the user has to Reload the page to obtain the correct shipping total. Is there a way to cause the shipping total to recalculate based on the new subtotal created when products are added?Here is the formula from the formulas.db to calculate the shipping costs based on the subtotal: shipCost [math show=f]rate=.04[/math][showif [subtotal]>499.99][math show= f]rate=.03[/math][/showif][showif [subtotal]>1499.99][math show=f]rate=.02[/ math][/showif][math][subtotal]*rate[/math]Thank you for your help.____________________________________________________________________________ Jim McDonald DataServ, Inc. tel: 614-488-1400 jmcdonald@k12.dserv.com 1335 Dublin Rd St.118-D fax: 614-488-4622 Edu. Mrkt. Rep/WebMaster Columbus, OH 43215 http://www.dserv.com ____________________________________________________________________________
Associated Messages, from the most recent to the oldest:
| |
- Recalculating Shipping Costs (McDonald, Jim 1997)
|
Grant:You were so kind to give me a cost variable solution to shipping costs based on subtotals. However, when a customer adds to their cart by going back to our search page, the subtotal does not recalculate and the user has to Reload the page to obtain the correct shipping total. Is there a way to cause the shipping total to recalculate based on the new subtotal created when products are added?Here is the formula from the
formulas.db to calculate the shipping costs based on the subtotal: shipCost [math show=f]rate=.04[/math][showif [subtotal]>499.99][math show= f]rate=.03[/math][/showif][showif [subtotal]>1499.99][math show=f]rate=.02[/ math][/showif]
[math][subtotal]*rate[/math]Thank you for your help.____________________________________________________________________________ Jim McDonald DataServ, Inc. tel: 614-488-1400 jmcdonald@k12.dserv.com 1335 Dublin Rd St.118-D fax: 614-488-4622 Edu. Mrkt. Rep/WebMaster Columbus, OH 43215 http://www.dserv.com ____________________________________________________________________________
McDonald, Jim
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:
Dates - Search and Sorting (1999)
We are searching (2005)
no global [username] or [password] displayed ... (1997)
For those of you not on the WebCatalog Beta... (1997)
how to use WebCat w. SSL & CyberCash (1998)
dates and hex formatting (1997)
select menus & database design (1998)
Further on formula.db failure to calculate shipCost (1997)
Calendar (1997)
Limits (2000)
Restart of DBserver (1997)
Text data with spaces in them... (1997)
turning every 5th line red (1998)
truncating email part II (1997)
[WebDNA] Emailer Issue (2009)
Integration with SQL (1997)
Error Lob.db records error message not name (1997)
Changing user submitted data (2000)
emailer w/F2 (1997)
Error cart approval pending (2005)