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.EricAt 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:
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.EricAt 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)