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:
>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)