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 Cost 1 Express LA 15 1 Regular LA 5 1 Express Paris 30 1 Regular Paris 10 2 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 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: shipcost - cleaner with a table (Brian B. Burton 1998)
  2. shipcost - cleaner with a table (PCS Technical Support 1998)
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 Cost 1 Express LA 15 1 Regular LA 5 1 Express Paris 30 1 Regular Paris 10 2 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 | Typhoon 619/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)