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:
A multi-processor savvy WebCatalog? (1997)
[shownext] and descending order (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[WebDNA] YouTube API v2.0 - OAuth 2.0 Authorization (2013)
Tenon and PCS Partner (1998)
Join us at MacWorld! (1998)
how do I have html files routed through webcat on OSX? (2001)
[Reload mydata.db] (1998)
[WebDNA] port from mime headers? (2017)
Search on Dates (2000)
webcat 3.06f on Linux keeps dying (1999)
emailer settings and control questions (1997)
[searchString] (1997)
Version 6 Problems (2004)
synching databases on multiple servers (1997)
New Webcatalog for Mac (1997)
totals (1997)
Multiple cart additions (1997)
WebCatalog NT beta 18 problem (1997)
carriage returns in data (1997)