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:

SiteBuilder? - SlideShow (2004) PDF template hell (2000) RequiredFields template (1997) Email Format (1998) unable to launch acgi in WebCat (1997) Search bug. Help (2002) Include a big block of text (1997) [WebDNA] WebDNA restart script (2015) Attn: Bug in GeneralStore example b15 (1997) WebTen Memory Error with Plug-In (1998) WebCatalog can't find database (1997) So when do we get something similar? (1998) WebCat editing, SiteGuard & SiteEdit (1997) OFF Topic - Web-Stat App (2003) Unexpected error (1997) text size limitation (1997) Size limit for tmpl editor ? (1997) Error Lob.db records error message not name (1997) Quitting WebMerchant ? (1997) Web Logs (1998)