Re: Adding insurance to an order, round 2
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50584
interpreted = N
texte = Just talking off the top of my head here, but why don't you have it as a 'hidden' lineitem. You add it as a lineitem so it's added up into the subtotal, but you do a [hideif [lineitem]^insurance] so it doesn't appear with the rest of the products and just create a new row above subtotal which is [showif [lineitem]^insurance], therefore looking like this:Item Category Qty Unit Price ==================================== Product A Cat Name 1 $100 $100 Product B Cat Name 1 $100 $100 Product C Cat Name 1 $50 $50 Product D Cat Name 1 $60 $60 --------------------------------------------------------- Insurance $10 --------------------------------------------------------- Subtotal $320 --------------------------------------------------------- Tax $31 --------------------------------------------------------- Grand Total $351I'm assuming that you can specify an arbitrary price in the products db, which you can change dynamically with your price change password included, and if it's in the products db, you can specify whether the insurance incurs tax or not too.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: WJ Starck
> Reply-To: (WebDNA Talk) > Date: Tue, 20 May 2003 15:12:25 > To: (WebDNA Talk) > Subject: Re: Adding insurance to an order, round 2 > > No, it's shipping insurance on the entire order, not individual items. > > Thus the problem... > > -W > ----- Original Message ----- > From: Tim Robinson > To: WebDNA Talk > Sent: Wednesday, May 21, 2003 6:38 PM > Subject: Re: Adding insurance to an order, round 2 > > >> If you're saying that insurance is available on individual items as > opposed >> to the whole order, it would make sense to me to add it as a lineitem. It >> would take a bit of fiddling, but I think that it would be much clearer > for >> your customer if, after adding an item to the cart, that they see > something >> like: >> >> Item Category Qty Unit Price >> ================================================ >> Product A Cat Name 1 $100 $100 >> - insurance for Product A $5 >> Product B Cat Name 1 $100 $100 >> Product C Cat Name 1 $50 $50 >> - insurance for Product C $5 >> Product D Cat Name 1 $60 $60 >> >> >> Regards, >> Tim >> -- >> Tim Robinson >> IDFK Web Developments >> tim@idfk.com.au >> 114a/40 Yeo Street >> Neutral Bay 2089 >> Australia >> Phone +612 9908 2134 >> Fax +612 9908 4837 >> >> >> >>> From: WJ Starck >>> Reply-To: (WebDNA Talk) >>> Date: Wed, 21 May 2003 17:45:27 >>> To: (WebDNA Talk) >>> Subject: Adding insurance to an order, round 2 >>> >>> I have a form that has a checkbox named insurance the value of which >>> is T if it's checked. This is so customers can elect to insure a >>> package (or not). >>> >>> The checkbox is submitted to another page that has the following code: >>> >>> [setheader cart=[GetCookie SessionID]header40=[insurance][/setheader] >>> and below that an orderfile that displays the cart info. >>> >>> Formulas.db has a [showif] that calculates an insurance amount if the >>> checkbox has been selected like so: >>> >>> Shipcost [showif [header40]=T]some code to add insurance to >>> shipcost[/showif] >>> >>> (It was suggested by Jay yesterday to use shipcost to add insurance to >>> an order as a whole, not as a lineitem.) >>> >>> Problem is, it seems like once items are added to the cart, the >>> Shipcost formula from Formulas.db has been applied and cannot be >>> changed - unless I remove all the items, remember what they were, check >>> to see if the insurance checkbox was checked, and then readd them, so >>> that the formula will be reapplied. >>> >>> Is there another way to do this I'm missing? >>> >>> Thanks, >>> >>> >>> -- >>> >>> Will Starck >>> NovaDerm Skincare Science >>> http://www.novaderm.com >>> wjs@novaderm.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/ >>> >> >> >> >> ------------------------------------------------------------- >> 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/ > ------------------------------------------------------------- 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:
Just talking off the top of my head here, but why don't you have it as a 'hidden' lineitem. You add it as a lineitem so it's added up into the subtotal, but you do a [hideif [lineitem]^insurance] so it doesn't appear with the rest of the products and just create a new row above subtotal which is [showif [lineitem]^insurance], therefore looking like this:Item Category Qty Unit Price ==================================== Product A Cat Name 1 $100 $100 Product B Cat Name 1 $100 $100 Product C Cat Name 1 $50 $50 Product D Cat Name 1 $60 $60 --------------------------------------------------------- Insurance $10 --------------------------------------------------------- Subtotal $320 --------------------------------------------------------- Tax $31 --------------------------------------------------------- Grand Total $351I'm assuming that you can specify an arbitrary price in the products db, which you can change dynamically with your price change password included, and if it's in the products db, you can specify whether the insurance incurs tax or not too.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: WJ Starck > Reply-To: (WebDNA Talk) > Date: Tue, 20 May 2003 15:12:25 > To: (WebDNA Talk) > Subject: Re: Adding insurance to an order, round 2 > > No, it's shipping insurance on the entire order, not individual items. > > Thus the problem... > > -W > ----- Original Message ----- > From: Tim Robinson > To: WebDNA Talk > Sent: Wednesday, May 21, 2003 6:38 PM > Subject: Re: Adding insurance to an order, round 2 > > >> If you're saying that insurance is available on individual items as > opposed >> to the whole order, it would make sense to me to add it as a lineitem. It >> would take a bit of fiddling, but I think that it would be much clearer > for >> your customer if, after adding an item to the cart, that they see > something >> like: >> >> Item Category Qty Unit Price >> ================================================ >> Product A Cat Name 1 $100 $100 >> - insurance for Product A $5 >> Product B Cat Name 1 $100 $100 >> Product C Cat Name 1 $50 $50 >> - insurance for Product C $5 >> Product D Cat Name 1 $60 $60 >> >> >> Regards, >> Tim >> -- >> Tim Robinson >> IDFK Web Developments >> tim@idfk.com.au >> 114a/40 Yeo Street >> Neutral Bay 2089 >> Australia >> Phone +612 9908 2134 >> Fax +612 9908 4837 >> >> >> >>> From: WJ Starck >>> Reply-To: (WebDNA Talk) >>> Date: Wed, 21 May 2003 17:45:27 >>> To: (WebDNA Talk) >>> Subject: Adding insurance to an order, round 2 >>> >>> I have a form that has a checkbox named insurance the value of which >>> is T if it's checked. This is so customers can elect to insure a >>> package (or not). >>> >>> The checkbox is submitted to another page that has the following code: >>> >>> [setheader cart=[GetCookie SessionID]header40=[insurance][/setheader] >>> and below that an orderfile that displays the cart info. >>> >>> formulas.db has a [showif] that calculates an insurance amount if the >>> checkbox has been selected like so: >>> >>> Shipcost [showif [header40]=T]some code to add insurance to >>> shipcost[/showif] >>> >>> (It was suggested by Jay yesterday to use shipcost to add insurance to >>> an order as a whole, not as a lineitem.) >>> >>> Problem is, it seems like once items are added to the cart, the >>> Shipcost formula from formulas.db has been applied and cannot be >>> changed - unless I remove all the items, remember what they were, check >>> to see if the insurance checkbox was checked, and then readd them, so >>> that the formula will be reapplied. >>> >>> Is there another way to do this I'm missing? >>> >>> Thanks, >>> >>> >>> -- >>> >>> Will Starck >>> NovaDerm Skincare Science >>> http://www.novaderm.com >>> wjs@novaderm.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/ >>> >> >> >> >> ------------------------------------------------------------- >> 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/ > ------------------------------------------------------------- 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/
Tim Robinson
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:
Formulas.db + Users.db (1997)
OS X, Communigate Pro & Line Breaks (2003)
Nested tags count question (1997)
Exclamation point (1997)
RE: WebCat and image maps (1997)
New WebDNA Solutions ... (1997)
Trouble with formula.db (1997)
Errata: WCS Newbie question (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Newbie problem blah blah blah (1997)
auto-stripping of spaces (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Truncated numbers (2000)
New Webcatalog for Mac (1997)
[WebDNA] feature suggestion (2011)
RE: MacFinder -- a new WebDNA web site (1998)
View Source from cache (1997)
Purchased cart being overwritten - still !?? (1997)
[showif] and equality (1998)
Creating main- and sub-category search (1997)