Re: UnitShipCost, Formulas.db and passwords
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47249
interpreted = N
texte = Alphonse MacDonald wrote: > I am trying to set up a shipping scheme that includes the following > shipping options in ShipCosts.db > > ShipMethod ShipCost UnitShipCost > UPS Ground 6.75 3.00 > UPS 2 Day Air 20.00 10.00 > UPS 3 Day Select 12.00 3.00 > International Air 25.00 10.00 > International Surface 15.00 15.00 > Just to confirm something, you want to charge 9.75 for ground shipping of one unit, correct? If you really mean to charge 6.75 Shipping and Handling for one unit by ground, you need to subtract a single UnitShipCost from the ShipCost. The ShipCost is added to the sum of units * UnitShipCost.The other thing to point out is that the Formulas.db is _only_ active when adding an item to the cart, in case you didn't know this when you were testing. You also need to [flushdatabases] after updating the ShipCosts.db before you can use the new values.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Alphonse MacDonald wrote: > I am trying to set up a shipping scheme that includes the following > shipping options in ShipCosts.db > > ShipMethod ShipCost UnitShipCost > UPS Ground 6.75 3.00 > UPS 2 Day Air 20.00 10.00 > UPS 3 Day Select 12.00 3.00 > International Air 25.00 10.00 > International Surface 15.00 15.00 > Just to confirm something, you want to charge 9.75 for ground shipping of one unit, correct? If you really mean to charge 6.75 Shipping and Handling for one unit by ground, you need to subtract a single UnitShipCost from the ShipCost. The ShipCost is added to the sum of units * UnitShipCost.The other thing to point out is that the formulas.db is _only_ active when adding an item to the cart, in case you didn't know this when you were testing. You also need to [flushdatabases] after updating the ShipCosts.db before you can use the new values.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
John Peacock
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:
Copyfile to length limit for absolute paths (2003)
HEADER AND FOOTER (1997)
[date] problem with %d%m%Y (1998)
WebCat2: Found Items syntax, etc. (1997)
SKU lookup (1997)
Protect (1997)
Newbie problem blah blah blah (1997)
empty shopping cart message (1997)
About WebCatalog and iTools 7 (2003)
no global [username] or [password] displayed ... (1997)
WebCatalog as a ListServ (1998)
Version 2.1.3 question :-) (2003)
Only charge card when product shipped ? (1997)
Entry pages (was: WebCatalog MAJOR drawback) (1998)
BUG in [showif] using ^ (contains) (1997)
Trouble with carts (2000)
WebCat Versions (2003)
[WebDNA] [listwords] and [index] (2009)
Freeze (2003)
Question about [encrypt] (1998)