Re: ups quickcost [repost]

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25094
interpreted = N
texte = > Nicolas: > > in your example, where are you getting [UPSprod] from?Well,I have a little database with these products. I only have 6 products to choose from. I use the UPS Quick cost to see if this or this product is available or not and let them appear, with their cost, on the page where my customers choose their shipping solution.GDNCOM : UPS Ground Commercial Residential is cheaper, but UPS usually asks the destinated company to pay an overfee if the UPS Ground product is wrong. To avoid this, I decided to make Ground Commercial a default for all UPS Ground products.Other services: 2DA : 2nd day air (USA) 1DA : Next day air (USA) STD : Canada standard (Canada) XPD : Worldwide Expedited (world) XPR : Worldwide Express (most industrialized countries)There are many many more services, but actually these 6 do the jobs for everybody around the wold and in North America.Go to the UPS Site to extract the list of the country codes (It has to be the two letter codification).Note: Zip Codes have to be correct: either be a valid US or Canadian Zip Code, or be spelled correctly. Example: Canadians usually write their zip code: XXX XXX (with a space), while the UPS QuickCost only accepts it in the form: XXXXXX.Using [convertchars db=^CleanCard.db]...[/convertchars] (place your CleanCard.db in the Globals folder) will do the job in cleaning the zip code.If the zip code is still not ok, use a default zipcode for that country, since shipping to northern New Zealand or Southern New Zealand from Russia does not make a big difference.Have fun.PS: there should be a solution for USPS and FedEx too. Please share your work!Sincerely,Nicolas Verhaeghe Web Admnistrator - Web Designer http://www.irez.com - iREZ Video Products http://www.easysharenet.com - EasyShare Network & USB Products http://www.partec.com - PAR Technologies, Inc. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: ups quickcost [repost] (John Hill 1999)
  2. Re: ups quickcost [repost] (Aaron Lynch 1999)
  3. Re: ups quickcost [repost] (Aaron Lynch 1999)
  4. Re: ups quickcost [repost] (Aaron Lynch 1999)
  5. Re: ups quickcost [repost] (Nicolas Verhaeghe 1999)
  6. Re: ups quickcost [repost] (Josh Tiger 1999)
  7. Re: ups quickcost [repost] (Aaron Lynch 1999)
  8. Re: ups quickcost [repost] (Nicolas Verhaeghe 1999)
  9. Re: ups quickcost [repost] (Aaron Lynch 1999)
  10. Re: ups quickcost [repost] (Nicolas Verhaeghe 1999)
  11. ups quickcost [repost] (Aaron Lynch 1999)
> Nicolas: > > in your example, where are you getting [UPSprod] from?Well,I have a little database with these products. I only have 6 products to choose from. I use the UPS Quick cost to see if this or this product is available or not and let them appear, with their cost, on the page where my customers choose their shipping solution.GDNCOM : UPS Ground Commercial Residential is cheaper, but UPS usually asks the destinated company to pay an overfee if the UPS Ground product is wrong. To avoid this, I decided to make Ground Commercial a default for all UPS Ground products.Other services: 2DA : 2nd day air (USA) 1DA : Next day air (USA) STD : Canada standard (Canada) XPD : Worldwide Expedited (world) XPR : Worldwide Express (most industrialized countries)There are many many more services, but actually these 6 do the jobs for everybody around the wold and in North America.Go to the UPS Site to extract the list of the country codes (It has to be the two letter codification).Note: Zip Codes have to be correct: either be a valid US or Canadian Zip Code, or be spelled correctly. Example: Canadians usually write their zip code: XXX XXX (with a space), while the UPS QuickCost only accepts it in the form: XXXXXX.Using [convertchars db=^CleanCard.db]...[/convertchars] (place your CleanCard.db in the Globals folder) will do the job in cleaning the zip code.If the zip code is still not ok, use a default zipcode for that country, since shipping to northern New Zealand or Southern New Zealand from Russia does not make a big difference.Have fun.PS: there should be a solution for USPS and FedEx too. Please share your work!Sincerely,Nicolas Verhaeghe Web Admnistrator - Web Designer http://www.irez.com - iREZ Video Products http://www.easysharenet.com - EasyShare Network & USB Products http://www.partec.com - PAR Technologies, Inc. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Nicolas Verhaeghe

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:

[WebDNA] limit found per row (2011) Enterprise Server (1998) [SearchString] problem with [search] context (1997) Triggers (1999) [WebDNA] IIS 7.5 (2015) problems with WebCat-Plugin (1997) Formulas.db + Users.db (1997) & in Lookups (1997) Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003) Great product and great job ! (1997) Cancel Subscription (1996) Require Value to be a Num (1998) [OT] OSX 3D-Secure support (2006) using showpage and showcart commands (1996) search form problem.. (1997) Cloning OS X (2002) WebDNA and SQL (2003) [shell] (2002) Forcing a NEWCART (1997) Dynamic Form - Shipping Country / State/ Province (2006)