Re: Adding insurance to an order, round 2
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50625
interpreted = N
texte = Tim-Thanks, I'd prefer it to appear after the subtotal so I'll do the small backflip.That's where it should be IMO.Perhaps SMSI could consider adding a generic below subtotal (I'm sure there's a standard term for these items) item, that could utilize it's own formula from formulas.db, that could be used for such things as insurance and/or discounts.Regards,--Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com On Wednesday, May 21, 2003, at 11:25 PM, Tim Robinson wrote:> 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 $351 > > I'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/ > >------------------------------------------------------------- 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:
Tim-Thanks, I'd prefer it to appear after the subtotal so I'll do the small backflip.That's where it should be IMO.Perhaps SMSI could consider adding a generic below subtotal (I'm sure there's a standard term for these items) item, that could utilize it's own formula from formulas.db, that could be used for such things as insurance and/or discounts.Regards,--Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com On Wednesday, May 21, 2003, at 11:25 PM, Tim Robinson wrote:> 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 $351 > > I'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/ > >------------------------------------------------------------- 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:
WC 2.0 frames feature (1997)
WC Database Format (1997)
What's New Date (2002)
WebDNA Docs - interactive - beta (2003)
Question re: Format command (2000)
Pithy questions on webcommerce & siteedit (1997)
Tea Room trouble (1997)
Re2: frames & carts (1997)
Searching (2004)
when will the list move? (nm) (2000)
same product in cart (1997)
[WebDNA] two ideas for running a cluster of WebDNA servers (2019)
searchable list archive (1997)
Wanted: Broader string manipulation functions (1997)
WebCatalog can't find database (1997)
setting taxable to true (1997)
SMSI -- a [notfound] context? (2002)
Potential Conflicts? (1997)
Using Plug-In while running 1.6.1 (1997)
Re:Need help... (1997)