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:

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)