Re: [cart] Taxrate - seriously ..

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 41415
interpreted = N
texte = We fixed it.What we didn't realize was that webcat applies all the formulas to all thelineitems again if you modify the header. This means that the lookup in theformulas database that relied on the sku of the product didn't work becausethe sku wasn't there.We also didn't realize that the TaxRate effects the whole cart rather thanindividual items.Silly us or silly webcat - I'm still not sure.On 11/7/02 3:21 PM, NovaDerm Skincare Science wrote:> Yes, here's some snippets on a page that contains a ton of setheaders> and uses [taxrate] and [taxtotal] from Taxrates.db> > > > > > [orderfile ShoppingCarts/[GetCookie SessionID]]> [showif [shiptoname]=]> [showif [GetCookie BillShip]=T]> [setheader cart=[GetCookie SessionID]]shiptoname=Same[/setheader]> [/showif]> [/showif]> [showif [shiptoname]=[raw][shiptoname][/raw]]> [showif [GetCookie BillShip]=T]> [setheader cart=[GetCookie SessionID]]shiptoname=Same[/setheader]> [/showif]> [/showif]> [/orderfile]> > [showif [referrer]^shipper.html]> [setheader cart=[GetCookie SessionID]]shipvia=[shipvia][/setheader]> [/showif]> > [showif [referrer]^shipping.html]> [setheader cart=[GetCookie SessionID]][hideif [GetCookie> BillShip]=T]shiptoname=[url][shiptoname][/url][/hideif]&shiptoemail=[url]> [shiptoemail][/url]&shiptoaddress1=[url][shiptoaddress1][/url]&shiptocity=> [url][shiptocity][/url]&shiptostate=[url][shiptostate][/url]&shiptozip=> [url][shiptozip][/url]&shiptocountry=[shiptocountry][/hideif][showif> [GetCookie > BillShip]=T]shiptoname=Same&shiptozip=[zip][/showif]&shipvia=[shipvia][/sethea> der]> [/showif]> > ...> Sales Tax ([TaxRate]%):> size=2>[taxtotal]> > -Will> > On Wednesday, July 10, 2002, at 09:26 PM, Andrew Simpson wrote:> >> >> The code is just a snippet to show logic.>> >> Does anybody have a working version of this where they are setting>> headers>> and successfully using the taxrate from a formulas databases?>> >> On 11/7/02 2:07 PM, Gary Krockover wrote:>> >>> Missing a bracket:>>> >>> [setheader>>> cart=[newcart]]HEADER17=[url][freight_area][/url]&CartIPAddress=[url]>>> [ipaddr>>> ess][/url]&header20=[url]COMPLETE[/url]]<--here [/SetHeader]>>> >>> and...should COMPLETE be [COMPLETE] ?>>> >>> GK>>> >>> >>>> Ok,>>>> We have narrowed it down to the following ..>>>> >>>> We add a lineitem, tax works fine>>>> [orderfile cart=[newcart]][taxrate][/orderfile] displays 12.5>>>> >>>> We set some headers ..>>>> [setheader>>>> >>> cart=[newcart]]HEADER17=[url][freight_area][/url]&CartIPAddress=[url]>>> [ipaddr>>>> ess][/url]&header20=[url]COMPLETE[/url][/SetHeader]>>>> >>>> Straight under that we try and display the rate again>>>> [orderfile cart=[newcart]][taxrate][/orderfile] displays 0>>>> >>>> Is the tax rate a bit delicate about the order things can be set ??>>>> If we add another lineitem tax comes back .. ?>>>> >>>> Anyone have any ideas ..>>>> Scott .. ?>>>> >>>> Thanks>>>> Alain>>>> >>>> >>>> >>>>> Okay, its been about 3 hours now and Both Alain and Myself are fully>>>>> convinced webcatalog has a bug!>>>>> >>>>> The tax rate works fine as long as the last thing you did before>>>>> listing>>> the>>>>> orderfile is play around with the header....>>>>> >>>>> If you add a line item then list the order file the tax works fine.>>>>> If you add a line item then set a header the tax is not shown.>>>>> If you add a line item, set a header then add another line item the>>>>> tax>>>>> comes back again.>>>>> >>>>> What is the deal with this???>>>>> >>>>> >>>> >>>> >>>> ------------------------------------------------------------->>>> This message is sent to you because you are subscribed to>>>> the mailing list .>>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to>>> >>>> Web Archive of this list is at: http://search.smithmicro.com/>>> >>> >>> ------------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to>>> >>> Web Archive of this list is at: http://search.smithmicro.com/>> >> -->> >> Andrew Simpson>> Web Development>> >> Blackpepper Interactive Ltd>> PO Box 99805>> Newmarket>> >> 4 Clayton Street>> Newmarket>> Auckland>> >> Ph: +64 9 520-6281>> Mob: 0272733270>> Fax: +64 9 524-1849>> >> http://www.blackpepper.co.nz>> >> >> >> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com>>> Web Archive of this list is at: http://search.smithmicro.com/>> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> > Web Archive of this list is at: http://search.smithmicro.com/-- Andrew SimpsonWeb DevelopmentBlackpepper Interactive LtdPO Box 99805Newmarket4 Clayton StreetNewmarketAucklandPh: +64 9 520-6281Mob: 0272733270Fax: +64 9 524-1849http://www.blackpepper.co.nz-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: [cart] Taxrate - seriously .. (Andrew Simpson 2002) Re: [cart] Taxrate - seriously .. (NovaDerm Skincare Science 2002) Re: [cart] Taxrate - seriously .. (Andrew Simpson 2002) Re: [cart] Taxrate - seriously .. (Gary Krockover 2002) [cart] Taxrate - seriously .. (Alain Russell 2002)

We fixed it.What we didn't realize was that webcat applies all the formulas to all thelineitems again if you modify the header. This means that the lookup in theformulas database that relied on the sku of the product didn't work becausethe sku wasn't there.We also didn't realize that the TaxRate effects the whole cart rather thanindividual items.Silly us or silly webcat - I'm still not sure.On 11/7/02 3:21 PM, NovaDerm Skincare Science wrote:> Yes, here's some snippets on a page that contains a ton of setheaders> and uses [taxrate] and [taxtotal] from Taxrates.db> > > > > > [orderfile ShoppingCarts/[GetCookie SessionID]]> [showif [shiptoname]=]> [showif [GetCookie BillShip]=T]> [setheader cart=[GetCookie SessionID]]shiptoname=Same[/setheader]> [/showif]> [/showif]> [showif [shiptoname]=[raw][shiptoname][/raw]]> [showif [GetCookie BillShip]=T]> [setheader cart=[GetCookie SessionID]]shiptoname=Same[/setheader]> [/showif]> [/showif]> [/orderfile]> > [showif [referrer]^shipper.html]> [setheader cart=[GetCookie SessionID]]shipvia=[shipvia][/setheader]> [/showif]> > [showif [referrer]^shipping.html]> [setheader cart=[GetCookie SessionID]][hideif [GetCookie> BillShip]=T]shiptoname=[url][shiptoname][/url][/hideif]&shiptoemail=[url]> [shiptoemail][/url]&shiptoaddress1=[url][shiptoaddress1][/url]&shiptocity=> [url][shiptocity][/url]&shiptostate=[url][shiptostate][/url]&shiptozip=> [url][shiptozip][/url]&shiptocountry=[shiptocountry][/hideif][showif> [GetCookie > BillShip]=T]shiptoname=Same&shiptozip=[zip][/showif]&shipvia=[shipvia][/sethea> der]> [/showif]> > ...> Sales Tax ([TaxRate]%):> size=2>[taxtotal]> > -Will> > On Wednesday, July 10, 2002, at 09:26 PM, Andrew Simpson wrote:> >> >> The code is just a snippet to show logic.>> >> Does anybody have a working version of this where they are setting>> headers>> and successfully using the taxrate from a formulas databases?>> >> On 11/7/02 2:07 PM, Gary Krockover wrote:>> >>> Missing a bracket:>>> >>> [setheader>>> cart=[newcart]]HEADER17=[url][freight_area][/url]&CartIPAddress=[url]>>> [ipaddr>>> ess][/url]&header20=[url]COMPLETE[/url]]<--here [/SetHeader]>>> >>> and...should COMPLETE be [COMPLETE] ?>>> >>> GK>>> >>> >>>> Ok,>>>> We have narrowed it down to the following ..>>>> >>>> We add a lineitem, tax works fine>>>> [orderfile cart=[newcart]][taxrate][/orderfile] displays 12.5>>>> >>>> We set some headers ..>>>> [setheader>>>> >>> cart=[newcart]]HEADER17=[url][freight_area][/url]&CartIPAddress=[url]>>> [ipaddr>>>> ess][/url]&header20=[url]COMPLETE[/url][/SetHeader]>>>> >>>> Straight under that we try and display the rate again>>>> [orderfile cart=[newcart]][taxrate][/orderfile] displays 0>>>> >>>> Is the tax rate a bit delicate about the order things can be set ??>>>> If we add another lineitem tax comes back .. ?>>>> >>>> Anyone have any ideas ..>>>> Scott .. ?>>>> >>>> Thanks>>>> Alain>>>> >>>> >>>> >>>>> Okay, its been about 3 hours now and Both Alain and Myself are fully>>>>> convinced webcatalog has a bug!>>>>> >>>>> The tax rate works fine as long as the last thing you did before>>>>> listing>>> the>>>>> orderfile is play around with the header....>>>>> >>>>> If you add a line item then list the order file the tax works fine.>>>>> If you add a line item then set a header the tax is not shown.>>>>> If you add a line item, set a header then add another line item the>>>>> tax>>>>> comes back again.>>>>> >>>>> What is the deal with this???>>>>> >>>>> >>>> >>>> >>>> ------------------------------------------------------------->>>> This message is sent to you because you are subscribed to>>>> the mailing list .>>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to>>> >>>> Web Archive of this list is at: http://search.smithmicro.com/>>> >>> >>> ------------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to>>> >>> Web Archive of this list is at: http://search.smithmicro.com/>> >> -->> >> Andrew Simpson>> Web Development>> >> Blackpepper Interactive Ltd>> PO Box 99805>> Newmarket>> >> 4 Clayton Street>> Newmarket>> Auckland>> >> Ph: +64 9 520-6281>> Mob: 0272733270>> Fax: +64 9 524-1849>> >> http://www.blackpepper.co.nz>> >> >> >> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com>>> Web Archive of this list is at: http://search.smithmicro.com/>> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> > Web Archive of this list is at: http://search.smithmicro.com/-- Andrew SimpsonWeb DevelopmentBlackpepper Interactive LtdPO Box 99805Newmarket4 Clayton StreetNewmarketAucklandPh: +64 9 520-6281Mob: 0272733270Fax: +64 9 524-1849http://www.blackpepper.co.nz-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Andrew Simpson

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:

More help for discount pricing (1998) F3 crashing server (1997) Email within tmpl ? (1997) Major bug report on rootbeer (1997) SSL and WebCatalog (1997) [WebDNA] StandardConversions.db (2016) Realtime Top 10 (1999) Dummy Credit Card Number for debug? (1997) Stopping bad HTML propagation ? (1997) Shipcost lookup? (1997) calculating ShipCost depending on weight (1997) Re:PCS Customer submissions ? (1997) send mail problem? (1997) Math Function (1997) Problem (1997) FTP Address (2003) Search (1997) contextual shownext (1998) RE: protect tag on NT (1997) More on [purchase] (1998)