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 textA and 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 shipping cost and assign it using [setheader] to set the [shippingTotal] field. Now, you can display the cart with the correct information.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: shippingTotal Challenge (John Peacock 2001)
  2. shippingTotal Challenge (ctapia@lemon.cl (Cristián Tapia) 2001)
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 textA and 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 shipping cost and assign it using [setheader] to set the [shippingTotal] field. Now, you can display the cart with the correct information.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://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:

Weird problems with [SHOWIF]s (1997) [TCPSend] and whois? (1999) E-mailer error codes (1997) [WebDNA] Upload file to mysql (2017) Number searching/formats (1998) Checkbox question (1997) Search results templates (1996) [TaxableTotal] - not working with AOL and IE (1997) Summing Fields (1998) Site Search Concepts (2003) WebMerchant 1.6 and https (1997) Loss in Form (1998) Uh...can someone help me out with the b10? (1997) ShowNext example for GeneralStore (1997) More than one db with the same namn (was: WC2f3) (1997) The USArea® Network web site ... (1997) 2 Nt's (1998) Out of the woodwork (2007) Next (1997) [SearchString] problem with [search] context (1997)