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:
[format 40s]text[/format] doesn't work (1997)
formvars available in formulas.db? (2000)
spaces in [texta] (1998)
emailer setup (1997)
WebCat2 - Getting to the browser's username/password data (1997)
What am I missing (1997)
Stumpted Again (1997)
OT (maybe) Setting up local (non internet) test computers (2000)
[replace] anomaly?? (2000)
Bug or syntax error on my part? (1997)
[SendMail] from a form? (1998)
Just Testing (1997)
Mail Lists (1998)
WebDNA Verison 4.5 will Not Restart! This SUCKS! (2002)
Setting up WebCatalog with Retail Pro data (1996)
how to check for no value while using [URL] to prevent cr (1999)
WebCat2b13MacPlugIn - [include] (1997)
OSX 10.2.6/iTools 7.0/WebDNA 5.0 installation (2003)
PCS Frames (1997)
[Reload mydata.db] (1998)