Re: [shippingtotal] in Formulas.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45746
interpreted = N
texte = No to both questions.However, here's what I did for a quick fix:Set the Shipcost in Formulas,db to double the normal shipping value, in this case $13.00Gave each item a UnitShipCost of $-6.50Then when one item is added, the shippingtotal is $13.00 -6.50 = $6.50When more than one item is added, [shippingtotal] is $13.00-6.50-6.50...=0I like this because I don't have to have some crazy formula that accounts for the number of lineitems *and* the quantities of lineitems.Bleah, my head was starting to spin. Maybe they should name the next big ride at Six Flags the FormulasDB!?!;)-WillOn Tuesday, November 26, 2002, at 08:24 PM, Donovan Brooke wrote:> Do you have unitshipcosts being applied to the lineitems? > > ShipCost doesn't override these values, it adds to the total of them. > Also, I assume you don't have any CR's in the formulas.db. :-) > > note.. You can overide the shippingtotal with a setheader. > > Donovan > > > > WJ Starck wrote: > >> In an attempt to offer free shipping when 2 or more products are >> ordered, I have this in Formulas.db: >> >> [orderfile ShoppingCarts/[GetCookie SessionID]][lineitems][math >> show=f]ordered=[lineindex][/math][/lineitems][/orderfile][showif >> [ordered]>1]0.00[/showif][showif [ordered]<2]6.50[/showif] >> >> When 1 item is added to the cart the shipping ([shippingtotal]) is >> correctly figured. >> >> When a second item is added the shipping does not change to 0 >> >> When the third and any further items are added the shipping changes >> to >> 0. >> >> Why the lag? >> >> -Will >> > > > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  2. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  3. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  4. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  5. [shippingtotal] in Formulas.db (WJ Starck 2002)
No to both questions.However, here's what I did for a quick fix:Set the Shipcost in Formulas,db to double the normal shipping value, in this case $13.00Gave each item a UnitShipCost of $-6.50Then when one item is added, the shippingtotal is $13.00 -6.50 = $6.50When more than one item is added, [shippingtotal] is $13.00-6.50-6.50...=0I like this because I don't have to have some crazy formula that accounts for the number of lineitems *and* the quantities of lineitems.Bleah, my head was starting to spin. Maybe they should name the next big ride at Six Flags the FormulasDB!?!;)-WillOn Tuesday, November 26, 2002, at 08:24 PM, Donovan Brooke wrote:> Do you have unitshipcosts being applied to the lineitems? > > ShipCost doesn't override these values, it adds to the total of them. > Also, I assume you don't have any CR's in the formulas.db. :-) > > note.. You can overide the shippingtotal with a setheader. > > Donovan > > > > WJ Starck wrote: > >> In an attempt to offer free shipping when 2 or more products are >> ordered, I have this in formulas.db: >> >> [orderfile ShoppingCarts/[GetCookie SessionID]][lineitems][math >> show=f]ordered=[lineindex][/math][/lineitems][/orderfile][showif >> [ordered]>1]0.00[/showif][showif [ordered]<2]6.50[/showif] >> >> When 1 item is added to the cart the shipping ([shippingtotal]) is >> correctly figured. >> >> When a second item is added the shipping does not change to 0 >> >> When the third and any further items are added the shipping changes >> to >> 0. >> >> Why the lag? >> >> -Will >> > > > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ WJ Starck

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:

[ShowNext] (1997) Emailer prefs in two places ... (1997) Database Security (1998) Been meaning to ask... (1997) necessary? (2000) WebDNA Writer Needed (1997) CORR: date format (2000) Using Plug-In while running 1.6.1 (1997) Help!!!! (1997) RE: Credit card processing - UK (1997) [WriteFile] problems (1997) more on my bbs (1997) PSC recommends what date format yr 2000??? (1997) Adding up weights (1998) WebCat and WebTV (1997) Staring a store with WebDNA 4.5.1 and Website Payments Pro (2006) Using Plug-In while running 1.6.1 (1997) For those of you not on the WebCatalog Beta... (1997) WebCatalog and WebMerchant reviewed by InfoWorld (1997) [lookup] [search] Issue (2005)