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/
Associated Messages, from the most recent to the oldest:
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 wasselected with the popup? I think that needs to happen beforethe formula for shipCost kicks in.Otherwise I don't see the problem either.-JohnBob 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/
John Butler
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 for guestbook ? (1997)
[WebDNA] Silly question (2009)
Credit card number for testing (2003)
WebCat2 - storing unformatted date data? (1997)
Parsing args without ? (2003)
WebCat 5 Intranet Question (2003)
Upgrading old WebCat Database Files (1997)
Emailer setup (1997)
Emailer choke (1997)
flushing databases (2003)
Not really WebCat (1997)
A question on sub-categories (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Separate SSL Server (1997)
Webcat 2.0.1 date math bug -> Crash! (1997)
ImageMagick Commands? (2003)
Can't Search field (1998)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Price override (2004)
Showing once on a founditems (1997)