Re: ShippingCosts
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19058
interpreted = N
texte = Will,Got the tax affair working after I enmailed off (The problem was that I was passing a FormVariable from the previous page state=[state] that was blowing away the lookup.I still can't figure the the shipping.For some reason, when I try to call the ShipCost from the formulas.db it doesn't lookup correctly.The line from the formulas.db is:ShipCost [Math]5[ShowIf [SubTotal]>25]-5[/ShowIf][/Math]So in the final checkout, I do a simple [format .2f][ShipCost][/format] and no matter what it shows up as 0.00. BTW, the above trick is from the WebCat Archives and seemed to work for the gent that used it, but I must be missing something.Any Ideas?Bill>>We continue to the order_verify.tpl page where the user confirms >>shipping/billing/CC info, the items they've ordered, Tax is figured in >>(which isn't working but that's another problem), and the ShipCost is >>figured (except it keeps showing up as $0.00). > >Well, I can't comment on the other stuff, but this one's easy (having just >been through it). You need to do a couple of things: > >1) Change the Ca Taxrate.db file's name to the two letter name of your state >(eg., Tx Taxrate.db) > >2) Open this file and edit the zip codes and tax rates to reflect those of >your state. In my case, I deleted the zips and rates for Ca, and pasted the >zips for TX from another program I use. I then changed all of the rates to >7.75 except for those around Fort Worth, which must be 8.25 because of a .5% >rapid transit assessment. > >3) In the formulas.db file, change [lookup db=Ca TaxRates] to [lookup >db=whatever you named your file above.db].Also, you must replace the 9.0 >in the ¬Found=9.0 to 0.0 so WebCat won't apply tax to anyone who orders >from outside your State. > >In my example, the relevant line now reads:taxRate [lookup >db=TXTaxRates.db&lookInField=zipcode&value=[ShipTozip]&returnField=taxRate&n >otFound=0.00] > >4) Finally, you need to select the radio button Can be Taxed when you add >or modify products in the General Store Admin area. > >Hope this helps, email me if you're still confused. This one tortured me for >a few days... > >Will Starck >President >TigerNet Technologies, Inc. >daprez@tigernet.net > >>Am I not carrying something >>correctly, or what? >> >>Any help will be appreciated... >> >>Bill-- Bill Heissenbuttel PageHouse, Inc. bill@pagehouseinc.com Internet Presence Provider http://www.pagehouseinc.com (509) 892-1973
Associated Messages, from the most recent to the oldest:
Will,Got the tax affair working after I enmailed off (The problem was that I was passing a FormVariable from the previous page state=[state] that was blowing away the lookup.I still can't figure the the shipping.For some reason, when I try to call the ShipCost from the
formulas.db it doesn't lookup correctly.The line from the
formulas.db is:ShipCost
[math]5[ShowIf [SubTotal]>25]-5[/ShowIf][/Math]So in the final checkout, I do a simple [format .2f][ShipCost][/format] and no matter what it shows up as 0.00. BTW, the above trick is from the WebCat Archives and seemed to work for the gent that used it, but I must be missing something.Any Ideas?Bill>>We continue to the order_verify.tpl page where the user confirms >>shipping/billing/CC info, the items they've ordered, Tax is figured in >>(which isn't working but that's another problem), and the ShipCost is >>figured (except it keeps showing up as $0.00). > >Well, I can't comment on the other stuff, but this one's easy (having just >been through it). You need to do a couple of things: > >1) Change the Ca Taxrate.db file's name to the two letter name of your state >(eg., Tx Taxrate.db) > >2) Open this file and edit the zip codes and tax rates to reflect those of >your state. In my case, I deleted the zips and rates for Ca, and pasted the >zips for TX from another program I use. I then changed all of the rates to >7.75 except for those around Fort Worth, which must be 8.25 because of a .5% >rapid transit assessment. > >3) In the
formulas.db file, change [lookup db=Ca TaxRates] to [lookup >db=whatever you named your file above.db].Also, you must replace the 9.0 >in the ¬Found=9.0 to 0.0 so WebCat won't apply tax to anyone who orders >from outside your State. > >In my example, the relevant line now reads:taxRate [lookup >db=TXTaxRates.db&lookInField=zipcode&value=[ShipTozip]&returnField=taxRate&n >otFound=0.00] > >4) Finally, you need to select the radio button Can be Taxed when you add >or modify products in the General Store Admin area. > >Hope this helps, email me if you're still confused. This one tortured me for >a few days... > >Will Starck >President >TigerNet Technologies, Inc. >daprez@tigernet.net > >>Am I not carrying something >>correctly, or what? >> >>Any help will be appreciated... >> >>Bill-- Bill Heissenbuttel PageHouse, Inc. bill@pagehouseinc.com Internet Presence Provider http://www.pagehouseinc.com (509) 892-1973
Bill Heissenbuttel
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:
Arrays (2000)
WebCat2: Items xx to xx shown, etc. (1997)
Entering the Serial Number (2003)
[random] only for 1-100??? (1997)
WebCat on OS X 10.4.7 won't send emails (2006)
Roundup function? (1997)
Size/Color Options (2002)
send mail problem? (1997)
searching by date (1998)
send mail problem? (1997)
WebCat2b12 - nesting [tags] (1997)
Setting up shop (1997)
[isfile] ? (1997)
How do I specify a & character in Grep? (2000)
[search] and [shownext] Problem (2000)
Garbage files created (2000)
NT lockup (1998)
RE: protect tag on NT (1997)
Searching an Email database (1997)
RAM variables (1997)