Re: shipping with weigth

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21981
interpreted = N
texte = >hi all, > >I am having difficulties getting the right shipping cost in the final >invoice. > >I want to calculate the shipping cost according to the weight of the >product. > >I looked in the manual, but can't really understand what I have to do. I >tried several different approaches, but without success. > >In the manual it says I have to have a perunitcost set in the formulas.db. > >But how exactly does it apply? I mean I have >unitShipCost [lookup >db=products.db&lookInField=sku&value=[sku]&returnField=weigth] > >In the invoice.tpl I have something like: > >Fr. [shippingTotal] > >I don't understand how I get the price for the unit, in a calculation like >this. > >Maybe I am totally off, but I hope someone on this list is merciful with a >newbie. > >Sincerely, >Nitai > > We have a separate database for listing weight of package and cost of shipping. We put weight of lineitems in one of the type fields, loop through the shopping cart figure total weight, then do a lookup in the weight database.Good luck!Sandy Associated Messages, from the most recent to the oldest:

    
  1. Re: shipping with weigth (PCS Technical Support 1998)
  2. Re: shipping with weigth (Sandra L. Pitner 1998)
  3. shipping with weigth (Nitai 1998)
>hi all, > >I am having difficulties getting the right shipping cost in the final >invoice. > >I want to calculate the shipping cost according to the weight of the >product. > >I looked in the manual, but can't really understand what I have to do. I >tried several different approaches, but without success. > >In the manual it says I have to have a perunitcost set in the formulas.db. > >But how exactly does it apply? I mean I have >unitShipCost [lookup >db=products.db&lookInField=sku&value=[sku]&returnField=weigth] > >In the invoice.tpl I have something like: > >Fr. [shippingTotal] > >I don't understand how I get the price for the unit, in a calculation like >this. > >Maybe I am totally off, but I hope someone on this list is merciful with a >newbie. > >Sincerely, >Nitai > > We have a separate database for listing weight of package and cost of shipping. We put weight of lineitems in one of the type fields, loop through the shopping cart figure total weight, then do a lookup in the weight database.Good luck!Sandy Sandra L. Pitner

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:

LookUp Tag (1997) flushdatabases (1997) Referrer problem - Truncation (1998) Sorry But This seems to be my fate (2000) WCS Newbie question (1997) I assume it is a safe bet this does not help (1998) Pref settings? (1998) RE: Emailer on NT! (1998) Nesting FoundItem Context (1997) How do I find where my IP address is located (2000) All questions are welcome on this list (1997) Help formatting search results w/ table (1997) Moment of Thanks (1997) Cookie woes with Mac IE4 (1998) Searching multiple fields from one form field (1997) [WebDNA] FFmpeg - shell path - brew install (2017) pop up menu's (1998) Banners (1997) WebCat2: Items xx to xx shown, etc. (1997) WebCat2b12 Mac.acgi--[searchstring] bug (1997)