Re: International Orders
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18430
interpreted = N
texte = That would be even easier than weight. the subtotal is already calculated. You just need to have a formula for each shipping region (shipcost/subtotal) in a table and do lookups based upon ship to country. You also need a way of assigning each country to a region.Sandy>There is just one other thing I failed to mention, we do not have the>weight of the package entered into our database. Ideally we would like to>base it on the total dollar amount for the order. Is this possible?>>Jeff>>Sandra L. Pitner wrote:>>> >We are accepting international orders on our web site where we sell>> >sporting goods. We take quite a few international orders, but we have>> >to single out these orders because we cannot apply proper international>> >shipping and handling rates to these orders on the fly (like we do for>> >US domestic orders). We pull these orders out, calculate shipping>> >charges, then contact the customer with an adjusted total for them to>> >approve. If they approve, we tack on the total (manually) and process>> >the order.>> >>> >There has got to be a better way. Has anyone out there come up with a>> >WebCat solution to this problem?>> >>> >Thanks!>> >Jeff Grady>> >>> >>>>> Look at www.musicianstore.com. We charge by weight of package. We>> divided up world into regions that share shipping charges/weight. We>> also give choice of slow boat, air or express. It works pretty well, we>> get lots of international orders. The caveat is the shipping time.>> Customs can hold onto packages for a while.>>>> Good luck.>>>> Sandy>>>>
Associated Messages, from the most recent to the oldest:
That would be even easier than weight. the subtotal is already calculated. You just need to have a formula for each shipping region (shipcost/subtotal) in a table and do lookups based upon ship to country. You also need a way of assigning each country to a region.Sandy>There is just one other thing I failed to mention, we do not have the>weight of the package entered into our database. Ideally we would like to>base it on the total dollar amount for the order. Is this possible?>>Jeff>>Sandra L. Pitner wrote:>>> >We are accepting international orders on our web site where we sell>> >sporting goods. We take quite a few international orders, but we have>> >to single out these orders because we cannot apply proper international>> >shipping and handling rates to these orders on the fly (like we do for>> >US domestic orders). We pull these orders out, calculate shipping>> >charges, then contact the customer with an adjusted total for them to>> >approve. If they approve, we tack on the total (manually) and process>> >the order.>> >>> >There has got to be a better way. Has anyone out there come up with a>> >WebCat solution to this problem?>> >>> >Thanks!>> >Jeff Grady>> >>> >>>>> Look at www.musicianstore.com. We charge by weight of package. We>> divided up world into regions that share shipping charges/weight. We>> also give choice of slow boat, air or express. It works pretty well, we>> get lots of international orders. The caveat is the shipping time.>> Customs can hold onto packages for a while.>>>> 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:
Protect (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] maybe silly suggestion? [founditems] (2015)
Generating Report Totals (1997)
Some basic help (2000)
docs for WebCatalog2 (1997)
Here's how to kill a Butler Database. (1997)
expired beta (1997)
tcpconnect/tcpsend problem ... (2004)
Where's Cart Created ? (1997)
Attention SM: Trigger Bug? (2000)
OT: Outsourcing & copyrights (2005)
[WebDNA] Set UID/GID/Permissions (2009)
form data submission gets truncated (1997)
auto enter dates (1998)
Limit on nested [ShowIf]'s? (1997)
problems with 2 tags (1997)
Separate SSL Server (1997)
Multiple catalog databases and showcart (1997)
possible, WebCat2.0 and checkboxes-restated (1997)