texte = We fixed it.What we didn't realize was that webcat applies all the formulas to all the lineitems again if you modify the header. This means that the lookup in the formulas database that relied on the sku of the product didn't work because the sku wasn't there.We also didn't realize that the TaxRate effects the whole cart rather than individual 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 Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +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:
We fixed it.What we didn't realize was that webcat applies all the formulas to all the lineitems again if you modify the header. This means that the lookup in the formulas database that relied on the sku of the product didn't work because the sku wasn't there.We also didn't realize that the TaxRate effects the whole cart rather than individual 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 Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +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:
Trouble with formula.db (1997)
form crasehes server (1997)
Further on formula.db failure to calculate shipCost (1997)
shownext (2001)
Web*3 virtual hosting Webcatalog problem (1998)
triggers.db (1999)
emailer settings and control questions (1997)
emailer (1997)
Q: for those who use Cookies for sessions? (2004)
Umm...about those log files? (Off Topic) (1997)
Robert Minor duplicate mail (1997)
Setting up shop (1997)
Works! (1997)
Including a php script (2003)
Reversed words (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
WebCatalog Upgrade Pricing? (1997)
Help formatting search results w/ table (1997)
Setting up the server (1997)
Nested tags count question (1997)
| |