Re: shippingTotal Challenge
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40349
interpreted = N
texte = Cristián Tapia wrote:> > Hi,> > I'm working on a commerce site which shipping cost calculation goes beyond> my basic DNA knowledge. I would appreciate if anybody can give me a hand> on this.> > The challenge is:> > 1.- Every product in the DB has two fields to be considered on the final> ShipCost calculation. The first one is weight and second is called> volumetric weight.When you add the item to the cart, also add the weight and vweight as textAand textB.> > 2.- Inside my invoice template I must add the weight of all the products> in the order. That gives me one value. Lets call it Total Weight. Then I> need to do the same for the volumetric weight. That gives me another value> Total Volumetric. Then I need to compare both of them and use the higher> one to continue with the calculation. Lets call it Master WeightAt the top of your invoice page, do a [lineitems] loop and add up the individual values of textA and textB, ala[math]total_weight=0[/math][math]total_vweight=0[/math][lineitems] [math]total_weight=[total_weight]+[textA][/math] [math]total_vweight=[total_vweight]+[textA][/math][/lineitems]> > - The next step is to use the Master Weight value to perform a series of> calculations based on shipping address, which finally should bring a> ShipCost to be added to the subtotal and get the long awaited> GrandTotalThen perform your logic to get the master weight and calculate the shippingcost and assign it using [setheader] to set the [shippingTotal] field. Now,you can display the cart with the correct information.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Cristián Tapia wrote:> > Hi,> > I'm working on a commerce site which shipping cost calculation goes beyond> my basic DNA knowledge. I would appreciate if anybody can give me a hand> on this.> > The challenge is:> > 1.- Every product in the DB has two fields to be considered on the final> ShipCost calculation. The first one is weight and second is called> volumetric weight.When you add the item to the cart, also add the weight and vweight as textAand textB.> > 2.- Inside my invoice template I must add the weight of all the products> in the order. That gives me one value. Lets call it Total Weight. Then I> need to do the same for the volumetric weight. That gives me another value> Total Volumetric. Then I need to compare both of them and use the higher> one to continue with the calculation. Lets call it Master WeightAt the top of your invoice page, do a [lineitems] loop and add up the individual values of textA and textB, ala[math]total_weight=0[/math][math]total_vweight=0[/math][lineitems] [math]total_weight=[total_weight]+[textA][/math] [math]total_vweight=[total_vweight]+[textA][/math][/lineitems]> > - The next step is to use the Master Weight value to perform a series of> calculations based on shipping address, which finally should bring a> ShipCost to be added to the subtotal and get the long awaited> GrandTotalThen perform your logic to get the master weight and calculate the shippingcost and assign it using [setheader] to set the [shippingTotal] field. Now,you can display the cart with the correct information.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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://search.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:
Quit revisited (1997)
Attn: Bug in GeneralStore example b15 (1997)
Un[url]ize (1999)
sendmail spaces (1997)
RE: [WebDNA] An alternative to hosting... (2009)
Summing fields (1997)
User/pass with tcpconnect (2000)
Separate SSL Server (1997)
I want a 404 (2005)
[WriteFile] problems (1997)
no global [username] or [password] displayed ... (1997)
[REPLACE] inside [FOUNDITEMS] (1998)
Referrer problem - Truncation (1998)
[WebDNA] WebDNA licenses discount from 12/23 to 12/31 (2011)
Server crash (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
WebCatalog Mac 2.1b3 (1997)
Shopping Carts (2000)
Bill To - Ship To Information display (1997)
Let's share the WebDNA.net domain ... (2005)