Applying discounts as more items are added...
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12444
interpreted = N
texte = HiI would like to offer a sliding scale discount system whereby the discount applied to an order varies/is changed each time a product is added to (or removed from) a cart. In effect the discount would be based on the total order quantity (i.e the total number of units from all lines of the order file) but would be applied to each line separately. It would need to be recalculated each time somthing was added or removed from the cart. Can this be done or would the discount have to be a separate line in the cart (preferably always the last line)?Could there be another field in the order file called [discount] which could also have a formula in the formula.db database? I suppose you could use either unitShipCost or ShipCost to create this effect....How do you calculate the total number of units ordered?Thanks in advance!Jeremy Jeremy Pocock NetCommerce Ltd http://www.NetCommerce.co.uk ---------------------------------------------------------------------- Tel: +44 (0)1703 456656 Fax: +44 (0)1703 453231 ---------------------------------------------------------------------- Email address : jpocock@NetCommerce.co.uk ---------------------------------------------------------------------- Buy It On-Line in 97! http://www.ShopsOnTheNet.co.uk http://www.ShopsOnTheNet.com ---------------------------------------------------------------------- InfoDisk - Address and Telephone Numbers for over 44 million UK residents on CD-Rom Order Your Copy Now from IDDirect! http://www.iddirect.co.uk ---------------------------------------------------------------------- Europe's Premier On-Line CD Rom Retailer http://www.CDDirect.co.uk
Associated Messages, from the most recent to the oldest:
| |
- Applying discounts as more items are added... (Jeremy Pocock 1997)
|
HiI would like to offer a sliding scale discount system whereby the discount applied to an order varies/is changed each time a product is added to (or removed from) a cart. In effect the discount would be based on the total order quantity (i.e the total number of units from all lines of the
order file) but would be applied to each line separately. It would need to be recalculated each time somthing was added or removed from the cart. Can this be done or would the discount have to be a separate line in the cart (preferably always the last line)?Could there be another field in the
order file called [discount] which could also have a formula in the formula.db database? I suppose you could use either unitShipCost or ShipCost to create this effect....How do you calculate the total number of units ordered?Thanks in advance!Jeremy Jeremy Pocock NetCommerce Ltd http://www.NetCommerce.co.uk ---------------------------------------------------------------------- Tel: +44 (0)1703 456656 Fax: +44 (0)1703 453231 ---------------------------------------------------------------------- Email address : jpocock@NetCommerce.co.uk ---------------------------------------------------------------------- Buy It On-Line in 97! http://www.ShopsOnTheNet.co.uk http://www.ShopsOnTheNet.com ---------------------------------------------------------------------- InfoDisk - Address and Telephone Numbers for over 44 million UK residents on CD-Rom Order Your Copy Now from IDDirect! http://www.iddirect.co.uk ---------------------------------------------------------------------- Europe's Premier On-Line CD Rom Retailer http://www.CDDirect.co.uk
Jeremy Pocock
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:
Re2: frames & carts (1997)
help with autenticate (1998)
strange problem listfiles and movefile (2000)
Deleting Cookie Problems (2007)
GuestBook example (1997)
Odd [math] behavior (2003)
WebTen and WebCat (1997)
Searching (2000)
Max Record length (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Setting up shop (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Searching multiple Databases (1997)
Help! WebCat2 bug (1997)
Pass Thru Page? (1998)
Include Troubles (1998)
Secure Server basic question... (1997)
quantity minimum problem (1997)
Problem with pull down menu (1998)
[writefile] (1997)