shipcost - cleaner with a table
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16777
interpreted = N
texte = OK, sorry it took me so long to get back to you on this. I tested this in the GeneralStore and it seemed to work OK.>In shipping our product we have 5 different unique shipping costs that is>determined by>>1. Total Unit Quantity>2. Express or Regular Mail shipping method>3. Locality.>>For instance>>1 box to Los Angeles via Express = 15.00>1 box to Los Angeles via Regular = 5.00>1 box to Paris via Express = 30.00>1 box to Paris via Regular = 10.00>2 box to Los Angeles via Express = 17.00Here's how I would do it with a database table so that it's easy to update your shipping costs and destinations:--- CustomShipping.db ---Quantity ShipMeth ShipTo Cost1 Express LA 151 Regular LA 51 Express Paris 301 Regular Paris 102 Express LA 17-- Formulas.db --shipCost [Search db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqShipTodatarq=[ShipTo]&eqQuantitydatarq=[math][lineitems][quantity]+[/lineitems]0[/math]][FoundItems][Cost][/FoundItems][/Search]The [math] equation inside there loops thru all the lineitems and sums the quantities.I hope this helps,Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
OK, sorry it took me so long to get back to you on this. I tested this in the GeneralStore and it seemed to work OK.>In shipping our product we have 5 different unique shipping costs that is>determined by>>1. Total Unit Quantity>2. Express or Regular Mail shipping method>3. Locality.>>For instance>>1 box to Los Angeles via Express = 15.00>1 box to Los Angeles via Regular = 5.00>1 box to Paris via Express = 30.00>1 box to Paris via Regular = 10.00>2 box to Los Angeles via Express = 17.00Here's how I would do it with a database table so that it's easy to update your shipping costs and destinations:--- CustomShipping.db ---Quantity ShipMeth ShipTo Cost1 Express LA 151 Regular LA 51 Express Paris 301 Regular Paris 102 Express LA 17--
formulas.db --shipCost [Search db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqShipTodatarq=[ShipTo]&eqQuantitydatarq=
[math][lineitems][quantity]+[/lineitems]0[/math]]
[founditems][Cost][/FoundItems][/Search]The
[math] equation inside there loops thru all the lineitems and sums the quantities.I hope this helps,Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Help! WebCat2 bug (1997)
emailer (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Summing fields (1997)
Intermitent problem using [referrer] (1997)
Lookup within a Search (2005)
Press Release hit the NewsWire!!! (1997)
no [search] with NT (1997)
Plugin or CGI or both (1997)
EMailCompleted folder - How to process tags (2000)
2.0 Info (1997)
Conveting Characters to Graphics (1997)
carriage returns in data (1997)
Authenticating users without dialog box (1997)
WCf2 and nested tags (1997)
Showif, Hideif reverse logic ? (1997)
Time for a hard questions. (1997)
Quickie question on the email templates (1997)
[WebDNA] possible bug? (db field named [width]) (2012)
Numbers and Numbers and Me (1999)