Re: Ship Cost Calculated via Subtotal

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21083
interpreted = N
texte = David,Here's one that compares based on subtotal and then it goes to the ShipCosts.db to see if there is any additional cost for RUSH shipping versus STANDARD shipping.The breaks are < 30 4.95 30-60 6.95 60-100 8.95 100-150 10.95 150-250 12.95 250+ 16.95Standard Ship 0.00 RUSH Ship 14.00 In formulas.dbshipCost [hideif [subTotal]>30.00][showif [subTotal]<30.00][math]4.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>60.00][showif [subTotal]<60.00][math]6.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>100.00][showif [subTotal]<100.00][math]8.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>150.00][showif [subTotal]<150.00][math]10.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>250.00][showif [subTotal]<250.00][math]12.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>100000.00][showif [subTotal]<100000.00][math]16.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] In ShipCosts.dbShipMethod ShipExtra Standard Shipping 0.00 Rush Shipping 14.00Hope it helps.Bill >Hello > I would like to calculate the shipping cost based on the subtotal. >Could someone show me the best way to do this. What I would like to do >is have a database that holds the cost of shipping. If the subtotal is >less than or equal to $25 dollars make the shipping cost $10. > >Subtotal ShipCost >Subtotal <= $25 $10 >Subtotal <= $75 $7 >Subtotal <= $100 $3 > >Thank You In Advance >David Greensfelder >Origin Technology In Business >8044 Montgomery Rd. Suite 200W >Cincinnati, Ohio 45236 >513-985-1414 >david.greensfelder@us.origin-it.com -- Bill Heissenbuttel PageHouse, Inc. bill@pagehouse.com Internet Presence Provider http://www.pagehouse.com (509) 892-1973 Associated Messages, from the most recent to the oldest:

    
  1. Re: Ship Cost Calculated via Subtotal (Bill Heissenbuttel 1998)
  2. Re: Ship Cost Calculated via Subtotal (PCS Technical Support 1998)
  3. Ship Cost Calculated via Subtotal (Greensfelder, David 1998)
David,Here's one that compares based on subtotal and then it goes to the ShipCosts.db to see if there is any additional cost for RUSH shipping versus STANDARD shipping.The breaks are < 30 4.95 30-60 6.95 60-100 8.95 100-150 10.95 150-250 12.95 250+ 16.95Standard Ship 0.00 RUSH Ship 14.00 In formulas.dbshipCost [hideif [subTotal]>30.00][showif [subTotal]<30.00][math]4.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>60.00][showif [subTotal]<60.00][math]6.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>100.00][showif [subTotal]<100.00][math]8.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>150.00][showif [subTotal]<150.00][math]10.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] [hideif [subTotal]>250.00][showif [subTotal]<250.00][math]12.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif][hideif [subTotal]>100000.00][showif [subTotal]<100000.00][math]16.95+[lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipExtra][/m ath][/showif][/hideif] In ShipCosts.dbShipMethod ShipExtra Standard Shipping 0.00 Rush Shipping 14.00Hope it helps.Bill >Hello > I would like to calculate the shipping cost based on the subtotal. >Could someone show me the best way to do this. What I would like to do >is have a database that holds the cost of shipping. If the subtotal is >less than or equal to $25 dollars make the shipping cost $10. > >Subtotal ShipCost >Subtotal <= $25 $10 >Subtotal <= $75 $7 >Subtotal <= $100 $3 > >Thank You In Advance >David Greensfelder >Origin Technology In Business >8044 Montgomery Rd. Suite 200W >Cincinnati, Ohio 45236 >513-985-1414 >david.greensfelder@us.origin-it.com -- Bill Heissenbuttel PageHouse, Inc. bill@pagehouse.com Internet Presence Provider http://www.pagehouse.com (509) 892-1973 Bill Heissenbuttel

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:

[WebDNA] WebDNA Showcase? (2008) Interactive Online Docs Was: [OT] Mozilla | Was: R.I.P. (2003) formatting dates from a field ... (1997) The IBC root beer has arrived! (1997) Sendmail problem on UNIX (2000) International Orders (1998) interesting (2003) Upgrade Pricing? (2003) Database flushing does not work any more... (2000) WCS Newbie question (1997) WC2f3 (1997) Email Set-Up? (1997) Taxable Shipping (2003) WebCat2 several catalogs? (1997) [time] math Q (2003) Two submit buttons ? (1997) [OT] Trying to steal databases on our server (2003) Sorting Results (1999) Date Formats (1997) Need relative path explanation (1997)