USPS Rates

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: USPS Rates

Post by jmestep » Thu Jan 07, 2010 6:33 am

Our client, Dan, reports that First Class is working OK now with the database corrections. The email we got from USPS was very hard to decipher and I went to the USPS website and their documentation was last updated on 5/11/09, so Logan has had a battle fixing it, I'm sure.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

fcmlmt1
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 26
Joined: Tue Jul 21, 2009 11:34 am

Re: USPS Rates

Post by fcmlmt1 » Thu Jan 07, 2010 8:44 am

Just one more question, we're currently using an option that is "Priority Mail International" that is NOT a flat rate box. I don't see an update to the script for that but rather only flat rate boxes. How do we fix this?

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: USPS Rates

Post by compunerdy » Thu Jan 07, 2010 9:42 am

Its not broken

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: USPS Rates

Post by Logan Rhodehamel » Thu Jan 07, 2010 10:05 am

jmestep wrote: and I went to the USPS website and their documentation was last updated on 5/11/09, so Logan has had a battle fixing it, I'm sure.
Yes, the documentation is outdated. I had to derive the correct service names by sending requests to USPS and examining the response values. I had to vary countries and weights until I retrieved all services.
fcmlmt1 wrote:Just one more question, we're currently using an option that is "Priority Mail International" that is NOT a flat rate box.
Only the services that had name changes were affected. Fewer than half of the services had name changes. Services that did not have name changes would still be working normally.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

fcmlmt1
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 26
Joined: Tue Jul 21, 2009 11:34 am

Re: USPS Rates

Post by fcmlmt1 » Thu Jan 07, 2010 12:12 pm

Everything is working except the First Class Mail International Package option for me. I did the debug with USPS and have included the log. Can you look at the log to see if you can isolate the problem for me?

Send: API=IntlRate&XML=<?xml version="1.0" encoding="UTF-8"?><IntlRateRequest USERID="905BRILL6747"><Package ID="0"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>Great Britain</Country></Package></IntlRateRequest>

Receive: <?xml version="1.0"?>
<IntlRateResponse><Package ID="0"><Prohibitions>Any postal item containing enclosures addressed to different persons at different addresses.
Arms and parts of arms, except as noted under Observation #5 below.
Articles, goods infringing British trademarks or copyright laws.
Cards decorated with mica or ground glass or similar materials unless they are placed in envelopes.
Citizens Band Radios, walkie-talkies, microbugs, and radio microphones that are capable of transmitting on any frequency between 26.1 and 29.7 megacycles per second and 88 to 108 Mhz per second.
Goods made in foreign prisons, except those imported for a non-commercial purpose or of a kind not manufactured in the UK.
Horror comics and matrices.
Obscene articles, prints, paintings, cards, films, videotapes, etc.
Perishable infectious biological substances.
Seal skins except those from an accepted source.
Switchblade knives.</Prohibitions><Restrictions>The maximum value of a GXG shipment to GREAT BRITAIN is $2,499 or a lesser amount if limited by content or value.
Coins; banknotes; currency notes (paper money); securities payable to bearer; traveler's checks; manufactured and unmanufactured platinum, gold, silver; precious stones; jewelry; and other valuable articles, may only be sent in registered letter-post shipments or insured parcel post.
Foods or beverages to which any preservative or other substance has been added must comply with the British regulations for importation.
Live bees.
Live queen bees must be accompanied by an import license issued by a UK Government Agricultural Department and a health certificate issued by the appropriate Government Department of the country of origin stating that the bees are free of disease.
Meat, meat products, and animal products including dry sausage and dried milk require import license issued by appropriate UK Agricultural Department.
Plants and parts of plants require import permit issued by the appropriate Agricultural Department in UK.</Restrictions><Observations>1. The following is a list of the names of the counties and city names in Northern Ireland. The County names are in capital letters. The geographic identifiers should be used in addressing mail to Northern Ireland:

ANTRIM:
Antrim
Ballymena
Belfast
Carrickfergus
Larne
Lisburn
Portrush
Toomebridge
Whitehead

ARMAGH:
Armagh
Lurgan
Portsdown

DOWN:
Banbridge
Bangor
Downpatrick
Kilkeel
Newcastle
Newry
Newtownards

LONDONDERRY:
Coleraine
Kilrea
Limavady
Londonderry
Magherafelt
Portstewart

TYRONE:
Cookstown
Dugannon
Moy
Omagh
Strabane

FERMANAGH:
Enniskillen

2. Many types of merchandise, unless sent as unsolicited gifts, require import licenses that the addressees must obtain from the British Board of Trade. Before mailing commercial shipments, senders should be assured that the addressees can obtain licenses if needed.
3. All goods sent to the UK are liable to customs duty and Value Added Tax on importation whether or not the package is marked as a gift." Packages are admitted free of customs charges, however, if they meet the following conditions:
a. Gift packages of small value provided they do not contain any tobacco goods, spirits or wine;
b. Gift packages containing only well-worn clothing (excluding garments of high value), limited quantities of foodstuffs (other than caviar), soap or consumable medical supplies.
4. Postal packages without a customs declaration that contain goods liable to customs duty or control may be seized by the customs authorities.
5. Firearms that are intended for sporting purposes are mailable to Great Britain, provided the prospective addressee has obtained the required import license.</Observations><CustomsForms>First-Class Mail International items and Priority Mail International flat-rate envelopes:
PS Form 2976 or 2976-A (see 123.61)
Priority Mail International parcels:
PS Form 2976-A inside 2976-E (envelope)</CustomsForms><ExpressMail>Country Code:
GB

Reciprocal Service Name:
Datapost

Required Customs Form/Endorsement
1. Business correspondence, commercial papers, and documents.
No form required. Endorse item clearly next to mailing label as BUSINESS PAPERS.

2. Merchandise samples without commercial value.
PS Form 2976, Customs - CN 22 (Old C 1) and Sender's Declaration (green label).

3. Merchandise and all articles subject to customs duty.
PS Form 2976-A, Customs Declaration and Dispatch Note CP 72, inside a PS Form 2976-E, Customs Declaration Envelope CP 91.

Note:
Coins; banknotes; currency notes (paper money); securities of any kind payable to bearer; traveler's checks; platinum, gold, and silver (manufactured or not); precious stones; jewelry; and other valuable articles are prohibited in EMS shipments to Great Britain and Northern Ireland.

Areas Served:

All points in England, Scotland, Wales,
Northern Ireland, Guernsey, Jersey, Alderney, Sark, and the Isle of Man.</ExpressMail><AreasServed>Please reference Express Mail for Areas Served.</AreasServed><Service ID="4"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>73.25</Postage><SvcCommitments>1 - 3 Days</SvcCommitments><SvcDescription>Global Express Guaranteed (GXG)</SvcDescription><MaxDimensions>Max. length 46", width 35", height 46" and max. length plus girth combined 108"</MaxDimensions><MaxWeight>70</MaxWeight></Service><Service ID="6"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>73.25</Postage><SvcCommitments>1 - 3 Days</SvcCommitments><SvcDescription>Global Express Guaranteed Non-Document Rectangular</SvcDescription><MaxDimensions>Max. length 46", width 35", height 46" and max. length plus girth combined 108"</MaxDimensions><MaxWeight>70</MaxWeight></Service><Service ID="7"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>73.25</Postage><SvcCommitments>1 - 3 Days</SvcCommitments><SvcDescription>Global Express Guaranteed Non-Document Non-Rectangular</SvcDescription><MaxDimensions>Max. length 46", width 35", height 46" and max. length plus girth combined 108"</MaxDimensions><MaxWeight>70</MaxWeight></Service><Service ID="12"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>73.25</Postage><SvcCommitments>1 - 3 Days</SvcCommitments><SvcDescription>USPS GXG Envelopes</SvcDescription><MaxDimensions>Cardboard envelope has a dimension of 9 1/2" X 12 1/2" and GXG tyvek envelope has a dimension of 12 1/2" X 15 1/2"</MaxDimensions><MaxWeight>70</MaxWeight></Service><Service ID="1"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>38.00</Postage><SvcCommitments>5 Days</SvcCommitments><SvcDescription>Express Mail International</SvcDescription><MaxDimensions>Max. length 42", max. length plus girth combined 79"</MaxDimensions><MaxWeight>66</MaxWeight></Service><Service ID="10"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>28.95</Postage><SvcCommitments>5 Days</SvcCommitments><SvcDescription>Express Mail International Flat Rate Envelope</SvcDescription><MaxDimensions>USPS Supplied Envelope: 9 1/2" x 12 1/2"</MaxDimensions><MaxWeight>66</MaxWeight></Service><Service ID="2"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>31.05</Postage><SvcCommitments>6 - 10 Days</SvcCommitments><SvcDescription>Priority Mail International</SvcDescription><MaxDimensions>Max. length 60", max. length plus girth combined 108"</MaxDimensions><MaxWeight>66</MaxWeight></Service><Service ID="11"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>55.95</Postage><SvcCommitments>6 - 10 Days</SvcCommitments><SvcDescription>Priority Mail International Large Flat Rate Box</SvcDescription><MaxDimensions>USPS Supplied Large Box: 12" x 12" x 5 1/2". Maximum weight 20 pounds.</MaxDimensions><MaxWeight>20</MaxWeight></Service><Service ID="9"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>43.45</Postage><SvcCommitments>6 - 10 Days</SvcCommitments><SvcDescription>Priority Mail International Medium Flat Rate Box</SvcDescription><MaxDimensions>USPS Supplied Medium Box: 13 5/8" x 11 7/8" x 3 3/8" or 11" x 8 1/2" x 5 1/2". Maximum weight 20 pounds.</MaxDimensions><MaxWeight>20</MaxWeight></Service><Service ID="16"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>13.45</Postage><SvcCommitments>6 - 10 Days</SvcCommitments><SvcDescription>Priority Mail International Small Flat Rate Box</SvcDescription><MaxDimensions>USPS Supplied Small Box: 8 5/8" x 5 3/8" x 1 5/8". Maximum weight 4 pounds.</MaxDimensions><MaxWeight>4</MaxWeight></Service><Service ID="8"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>13.45</Postage><SvcCommitments>6 - 10 Days</SvcCommitments><SvcDescription>Priority Mail International Flat Rate Envelope</SvcDescription><MaxDimensions>USPS Supplied Envelope: 9 1/2" x 12 1/2". Maximum weight 4 pounds.</MaxDimensions><MaxWeight>4</MaxWeight></Service><Service ID="15"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>14.20</Postage><SvcCommitments>Varies</SvcCommitments><SvcDescription>First-Class Mail International Package</SvcDescription><MaxDimensions>Other than rolls: Max. length 24", max length, height and depth (thickness) combined 36" Rolls: Max. length 36". Max length and twice the diameter combined 42"</MaxDimensions><MaxWeight>4</MaxWeight></Service><Service ID="14"><Pounds>1</Pounds><Ounces>8</Ounces><MailType>Package</MailType><Country>GREAT BRITAIN</Country><Postage>14.00</Postage><SvcCommitments>Varies</SvcCommitments><SvcDescription>First-Class Mail International Large Envelope</SvcDescription><MaxDimensions>Max. length 15", height 12" or thickness 3/4"</MaxDimensions><MaxWeight>4</MaxWeight></Service></Package></IntlRateResponse>

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: USPS Rates

Post by Logan Rhodehamel » Thu Jan 07, 2010 12:50 pm

fcmlmt1 wrote:Everything is working except the First Class Mail International Package option for me. I did the debug with USPS and have included the log. Can you look at the log to see if you can isolate the problem for me?
The log shows the rate is being returned. The second half of the troubleshooting is to look at the SQL database records. In the ac_ShipMethods table there are records for each of the shipping methods you support. The value of the ServiceCode field for your international package method must be this:

First-Class Mail International Package

It seems the most likely cause of the problem is that method has an incorrect service code configured.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

fcmlmt1
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 26
Joined: Tue Jul 21, 2009 11:34 am

Re: USPS Rates

Post by fcmlmt1 » Thu Jan 07, 2010 1:16 pm

That is how it has been set.
untitled.jpg

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: USPS Rates

Post by Logan Rhodehamel » Thu Jan 07, 2010 1:27 pm

That's very strange. I don't suppose there's a chance of a stray space in the database service code? I can try the same weight and addresses from your debug XML to see if it shows up for me.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

speedythinker
Commander (CMDR)
Commander (CMDR)
Posts: 121
Joined: Sat Sep 23, 2006 1:00 pm

Re: USPS Rates

Post by speedythinker » Sat Jan 30, 2010 2:57 am

I have used Logan suggestion and have my hosting SQL admin to run the database script. After that everything seems working fine till today. I found that the postage calculator for International shipment could only show "USPS Priority Mail International" and my local pickup . Then, it's strange enough that all methods for US domestic will show up : First class, Priority mail, Express mail, UPS.. but it also show USPS Priority Mail International and USPS Express Mail International as well. Did USPS change their name db structure again? Or is it just me to have this issue.

Then, I ran the new patches for V7.04 and it didn't help either. My site is: http://www.lightobject.com. If you try a small item and pick an Int'l country, say Brazil, it could end up that USPS Priority Mail International is the only shipping method available.

Please help
Speedy

DBounlom
Lieutenant (LT)
Lieutenant (LT)
Posts: 62
Joined: Wed Sep 09, 2009 1:26 pm

Re: USPS Rates

Post by DBounlom » Tue Feb 09, 2010 9:31 pm

I applied the patch for bug ID 8653. I can get "USPS First-Class Mail International Package" to work fine, but "USPS First Class Mail International Parcel" does not work still. Any help is greatly appreciated. I am running AbleCommerce 7.0.3 build 12458. Thank you!

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: USPS Rates

Post by jmestep » Wed Feb 10, 2010 8:24 am

Try using usps.com and getting a quote for shipping to that address. We ran into a couple of cases after the change where USPS might not have that method available for a particular address. I don't know if it was a change or something that hadn't arisen previously for that address.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

speedythinker
Commander (CMDR)
Commander (CMDR)
Posts: 121
Joined: Sat Sep 23, 2006 1:00 pm

Re: USPS Rates

Post by speedythinker » Wed Feb 10, 2010 12:26 pm

My issue got fixed. Here is what I did: I removed all shipping method from the USPS carrier and added the method again. After that, it works perfectly. That procedure never been mentioned from the forum and . I ran out of the option so I tried everything I could. Now it works just fine!

By the way, I found that there was a problem on Able v7.04 and I'ld to share here. If you have a product that has a link to "Product Accessoreies" and if that accessories item dropped (disable or removed), it will cause a big time "Application Error"!

Another issue (not crtical): some item can not be display for unknown reason unless I changed the "Sort" from A to Z or Z to A to resort it. Otherwise, it disappear unless I click the subcatalogy or do a Search.

It seems that there are still a lot of little bugs in V7.04

DBounlom
Lieutenant (LT)
Lieutenant (LT)
Posts: 62
Joined: Wed Sep 09, 2009 1:26 pm

Re: USPS Rates

Post by DBounlom » Wed Feb 10, 2010 7:15 pm

Thanks for the replies. Did they get rid of USPS First Class Mail International Parcel? I dont' even see it on USPS.com. The closest I see is USPS First-Class Mail International Package, which I guess is the same thing?

AbleBody
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 23
Joined: Sun Feb 24, 2008 3:47 am

Re: USPS Rates

Post by AbleBody » Fri Feb 12, 2010 12:52 am

Hi Logan,
That db fix did not seem to resolve my client's issue (he is on 7.0.2).

Now, in the USPS debug log, I get the following for any shipping transaction with USPS :
Receive: <Error>
<Number>80040b1a</Number>
<Description>API Authorization failure. RateV3 is not a valid API name for this protocol.</Description>
<Source>UspsCom::DoAuth</Source>
</Error>
For International, its slightly different :
Receive: <Error>
<Number>80040b1a</Number>
<Description>API Authorization failure. IntlRate is not a valid API name for this protocol.</Description>
<Source>UspsCom::DoAuth</Source>
</Error>
Any ideas? The service codes now look correct based on that db script.

Thanks.
-sri
______________________________
AWCS.net
Image
Advanced Web Commerce Solutions
Your AbleCommerce Experts!
P: 949-544-7166
http://www.AWCS.net

AbleBody
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 23
Joined: Sun Feb 24, 2008 3:47 am

Re: USPS Rates

Post by AbleBody » Fri Feb 12, 2010 6:14 am

Nevermind... turns out it was an invalid URL in the USPS Gateway configuration. They must have changed it during one of the upgrades.

Thanks!
-sri
______________________________
AWCS.net
Image
Advanced Web Commerce Solutions
Your AbleCommerce Experts!
P: 949-544-7166
http://www.AWCS.net

Post Reply