Shipping Method: > > > [shipVia]=UPSGround]selected[/showif]>UPS Ground> > > [shipVia]=USPSPriorityMail(USOnly)]selected[/showif]>USPS Priority Mail> > (US ONLY)> > > [shipVia]=USPS(Book)]selected[/showif]>USPS (Book)> > > [shipVia]=USPS(Surface)]selected[/showif]>USPS (Surface) > VALUE=Subscription [showif> > [shipVia]=Subscription]selected[/showif]>Subscription> > > >> > > >> > ShipMethod ShipCost> > UPSGround 4.50> > USPSPriorityMail(US ONLY) 4.50> > USPS(Book) 3.50> > USPS(Surface) 4.50> > Subscription 0.00> >> > > >> > Name Formula> > price [lookup> > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=price]> > taxRate [lookup> > db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Foun> > d=0.00]> > shipCost [lookup> > db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]> > unitShipCost [lookup> > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=unitShipCost]> >> > -------------------------------------------------------------> > 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://search.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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks for your reply. I think I've got the [setheader] doing what itshould. Here it is: Any Ideas?[SetHeadercart=[cart] ]shipVia=[url] [__shipVia][/url]&shipToState=[url] [__shipToState][/url]&CartIPAddress=[ipaddress] [/SetHeader]John Butler wrote:> > unitShipCost = price per unit (can be in catalog.db or formula.db)> ShipCost = fixed price per order (can be in formula.db or form variable)> ShippingTotal= sum of (unitShipCost * qty) plus ShipCost for order> -(coutesy of John Peacock)> > I assume you are getting the orderfile header shipVia a value equal to what was> selected with the popup? I think that needs to happen before> the formula for shipCost kicks in.> Otherwise I don't see the problem either.> > -John> > Bob McPeak wrote:> > > Hey Guys-> >> > I'm bugging out on this one. I can't see why my [ShippingTotal] won't> > pick up the ShipMethod base rate from my ShipCosts.db. I've pasted all> > the parts below for inspection. A fresh set of eyes might pick> > something up that I just can't see. Any help is greatly appreciated.> > Thanks.> >> > > >> > > > [shipVia] Shipping &> > Handling > > $[shippingTotal] > > > >> > > >> > p>NOTE: If you have> > ONLY an SMQ Subscription in your cart, then please> > choose Subscription as your shipping method to avoid any shipping> > charges on your order. If you have even 1 item other than an SMQ> > subscription in your cart, then you must choose a valid shipping> > method or your order will not be fulfilled.
> > Shipping Method: > > > [shipVia]=UPSGround]selected[/showif]>UPS Ground> > > [shipVia]=USPSPriorityMail(USOnly)]selected[/showif]>USPS Priority Mail> > (US ONLY)> > > [shipVia]=USPS(Book)]selected[/showif]>USPS (Book)> > > [shipVia]=USPS(Surface)]selected[/showif]>USPS (Surface) > VALUE=Subscription [showif> > [shipVia]=Subscription]selected[/showif]>Subscription> > > >> > > >> > ShipMethod ShipCost> > UPSGround 4.50> > USPSPriorityMail(US ONLY) 4.50> > USPS(Book) 3.50> > USPS(Surface) 4.50> > Subscription 0.00> >> > > >> > Name Formula> > price [lookup> > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=price]> > taxRate [lookup> > db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Foun> > d=0.00]> > shipCost [lookup> > db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]> > unitShipCost [lookup> > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=unitShipCost]> >> > -------------------------------------------------------------> > 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://search.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://search.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://search.smithmicro.com/
Bob McPeak
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:
weird happenings (1997)
Grep support request for SMSI ... (2003)
Secure Server (1997)
Editing webDNA in a textarea (2007)
select multiple 2 more cents (1997)
Show items based on login Password (2003)
Virtual hosting and webcatNT (1997)
SMSI -- a [notfound] context? (2002)
Email within tmpl ? (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Trigger Bug? (2000)
Add a Blog to your site. (2002)
Been meaning to ask... (1997)
Search Question (2003)
Progress !! WAS: Trouble with formula.db (1997)
Associative lookup style? (1997)
WC2b12: Yes, Formulas.db is for real (1997)
minimalist shopping cart. (1997)
Cookie Crumble (1998)
WC2b15 File Corruption (1997)