Re: Shipping charge question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52084
interpreted = N
texte = Thanks Donovan, I try it and it does give me shipping=0 when the order contains SKU=N030844 (I took the "" out because N030844 does not have quotes). However, it also gives me shipping=0 when the order did not contain SKU=N030844. Any idea? Suggestions are greatly appreciated. Eric At 11:04 AM 8/6/2003 -0500, you wrote: >Eric wrote: >>Hi, >>I hope someone can help me with the following: >>If the user's order contain a specific SKU number, then the shipping >>charge for that entire order is zero. >>I place the following code at the invoice.inc page >>[if [lookup db=admin/products.db&lookinfield=SKU&value="N030844"]] >>[Then] >>[shippingTotal]="0" >>$[shippingTotal] >>[/Then] >>[/if] >>$[shippingTotal] >>But it did not work. What did I do wrong. It still have the shipping >>charge even I order the item with SKU "N030844" > >Eric, >In your invoice page you need to loop through *all* the lineitems before >setting the shippingtotal. Somethinglike > >[orderfile cart=[cart]] > [lineitems] > [showif [sku]="N030844"][!]Note - the quotes must > exist in product SKU [/!] > [text]theShipping=0[/text] > [/showif] > [/lineitems] >[/orderfile] > >[setheader >cart=[cart]&db=some.db]Password=BLAH&ShippingTotal=[theShipping][/setheader] > >Note, You can also set this in the formulas database using just about the >same code. (take out *all* the white space) > >Donovan > >>Thanks, >>Eric > > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE > Eucalyptus Design > Developer / Consultant > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > P.O. Box 260153 > Madison, WI 53726-0153 > > PH:> 1.608.442.5217 > email:> dbrooke@euca.us > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > >------------------------------------------------------------- >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 has been scanned for viruses and >dangerous content by the MailScanner at ow4, and is >believed to be clean. ------------------------------------------------------------- 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: Shipping charge question ( Eric 2003)
  2. Re: Shipping charge question ( Donovan 2003)
  3. Re: Shipping charge question ( Donovan 2003)
  4. Re: Shipping charge question ( Donovan 2003)
  5. Re: Shipping charge question ( Eric 2003)
  6. Re: Shipping charge question ( Donovan 2003)
  7. Re: Shipping charge question ( Eric 2003)
  8. Re: Shipping charge question ( Donovan 2003)
  9. Re: Shipping charge question ( Kenneth Grome 2003)
  10. Re: Shipping charge question ( Tim Robinson 2003)
  11. Re: Shipping charge question ( "Gary Krockover" 2003)
  12. Shipping charge question ( Eric 2003)
Thanks Donovan, I try it and it does give me shipping=0 when the order contains SKU=N030844 (I took the "" out because N030844 does not have quotes). However, it also gives me shipping=0 when the order did not contain SKU=N030844. Any idea? Suggestions are greatly appreciated. Eric At 11:04 AM 8/6/2003 -0500, you wrote: >Eric wrote: >>Hi, >>I hope someone can help me with the following: >>If the user's order contain a specific SKU number, then the shipping >>charge for that entire order is zero. >>I place the following code at the invoice.inc page >>[if [lookup db=admin/products.db&lookinfield=SKU&value="N030844"]] >>[Then] >>[shippingTotal]="0" >>$[shippingTotal] >>[/Then] >>[/if] >>$[shippingTotal] >>But it did not work. What did I do wrong. It still have the shipping >>charge even I order the item with SKU "N030844" > >Eric, >In your invoice page you need to loop through *all* the lineitems before >setting the shippingtotal. Somethinglike > >[orderfile cart=[cart]] > [lineitems] > [showif [sku]="N030844"][!]Note - the quotes must > exist in product SKU [/!] > [text]theShipping=0[/text] > [/showif] > [/lineitems] >[/orderfile] > >[setheader >cart=[cart]&db=some.db]Password=BLAH&ShippingTotal=[theShipping][/setheader] > >Note, You can also set this in the formulas database using just about the >same code. (take out *all* the white space) > >Donovan > >>Thanks, >>Eric > > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE > Eucalyptus Design > Developer / Consultant > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > P.O. Box 260153 > Madison, WI 53726-0153 > > PH:> 1.608.442.5217 > email:> dbrooke@euca.us > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > >------------------------------------------------------------- >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 has been scanned for viruses and >dangerous content by the MailScanner at ow4, and is >believed to be clean. ------------------------------------------------------------- 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/ Eric

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:

Webcatalog/Butler (1998) Showif for mulitple variations (1997) database visibility (2000) setheader and retrieve it immediatly (2001) Advice needed. (1998) WebCatalog can't find database (1997) & not allowed in db by definition? (1999) listfiles-looking for slick solution (1997) Plugin or CGI or both (1997) [WebDNA] WebDNA crash and now emailer not working (2009) Quit revisited (1997) Re:2nd WebCatalog2 Feature Request (1996) problems with 2 tags (1997) [OT] (waaaay OT) (2004) question: webmerchant connection (1997) Emailer problem....still (1997) Re:Off Topic: Frames Killer? (1998) WebTen? (1997) [OT] - Block Traffic to DevBox (2003) BBEdit and WebCatalog 2.0? (1997)