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:

emailer settings and control questions (1997) FYI: virus alert (1996) authenticating a second user, the sequel (1997) Bug or syntax error on my part? (1997) WebCatalog 2.1 for NT (1998) [WriteFile] problems (1997) [WebDNA] sagepayments TLS? requests now failing (2018) ShowIf, If, XML Syntax.... (2004) RE: E-mailer error codes (1997) Web Delivery Page concept (1997) [Semi-OT] Eaaaaaasy OSX FTP (2003) WebDNA Windows 5.0 sendmail bug (2003) iis 4.0 (1997) Runtime version ... (2003) Sorting Results (1999) Various Problems (1997) Re:FYI: Error message (1996) thankyou.tmpl (1997) Bug in 4.5 - Needs to be fixed ASAP. (2002) .. more on sliding discounts... (1997)