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