Re: Shipping charge question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52077
interpreted = N
texte = 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/ 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)
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/ Donovan

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:

[defined]ish (1997) Nested tags count question (1997) PCS Emailer's role ? (1997) So many lookers, hey smith micro (2003) BACKGROUND (2000) WebCatalog/WebMerchant 3.0 for SALE !!! (2000) aol (2000) multi-paragraph fields (1997) PIXO (1997) More than one db with the same namn (was: WC2f3) (1997) Append..... doesn't (2000) Database causes out of memory error (2000) Nested vs conditional (1997) WebCat2 several catalogs? (1997) WebCat2 - [format thousands] (1997) Bug? (1997) WebCatalog for guestbook ? (1997) Configuration Q (1998) removelineitems (2000) [WebDNA] crashing loop (2011)