USPS changes effective January 2nd, 2011

Applies to: AbleCommerce 7.0.0 through 7.0.6

Release Date:  1/3/2011

A NEWER VERSION IS AVAILABLE HERE

IMPORTANT UPDATE

The United States Postal Service notified it's integration providers of a price change effective January 2th, 2010.  This is part of the notice that was given.

Dear Web Tools integrator,

Effective January 2, 2011, USPS will enact a Price Change. While there will be no structural changes to existing Web Tools requests and responses, there could be other changes that might affect your interface with Web Tools.

A summary of changes is listed below. Please direct any questions to the USPS Internet Customer Care Center (icustomercare@usps.com or 1-800-344-7779).

The result of this change included updates to the service names.  The USPS integration requires the service name in AbleCommerce to match the service name designated by USPS.  If a name match is not found, services and rates will not be returned at checkout or with the shipping estimator.  

We have responded as quickly as possible by providing a patch for all versions of AbleCommerce 7.  Make sure you know the version of AbleCommerce you are using and choose the correct download from below.  

You can find your version by logging into the AbleCommerce Admin and going to the Help > About page.

DOWNLOADS:

Installing the USPS patch

After downloading the patch file, extract the contents to a temporary folder on the AbleCommerce server.

1. Copy the new CommerceBuilder.USPS.dll to the \bin\ folder of your AbleCommerce installation.
    

   * If the website is active, it may be necessary to temporarily stop the web service during the copy process.

   The new DLL will allow you to create NEW services using the correct USPS names.

If you have existing services setup for USPS, proceed to the next step.

Updating the Database

If you prefer to handle the database update manually, we have provided the SQL script below, which is necessary to update your existing USPS service names.
 

2. Copy the new file "PatchUSPS.aspx" into your \install\ folder.  You may need to create the folder if you don't have it.

   e.g.  c:\inetpub\wwwroot\youracrootfolder\install\
 

3. Launch a browser and access the PatchUSPS update.

   e.g.  http://yourwebsite/install/PatchUSPS.aspx
 

4. Confirm that you want to run the script, and do so.
    

5. Remove the \install\ folder and file.

RUN THE FOLLOWING SQL SCRIPT ONLY IF YOU DO NOT COMPLETE STEPS 2 through 5

* The Readme file within your patch will have this script in text form, which may be easier to copy from.

UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail<sup>®</sup> Sunday/Holiday Delivery' WHERE ServiceCode = 'Express Mail Sunday/Holiday Guarantee';
UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail<sup>®</sup> Sunday/Holiday Delivery Flat Rate Envelope' WHERE ServiceCode = 'Express Mail Flat-Rate Envelope Sunday/Holiday Guarantee';
UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail<sup>®</sup> Flat Rate Envelope' WHERE ServiceCode = 'Express Mail Flat Rate Envelope';
UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail<sup>®</sup>' WHERE ServiceCode = 'Express Mail';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup>' WHERE ServiceCode = 'Priority Mail';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> Flat Rate Envelope' WHERE ServiceCode = 'Priority Mail Flat Rate Envelope';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> Small Flat Rate Box' WHERE ServiceCode = 'Priority Mail Small Flat Rate Box';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> Medium Flat Rate Box' WHERE ServiceCode = 'Priority Mail Medium Flat Rate Box';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> Large Flat Rate Box' WHERE ServiceCode = 'Priority Mail Large Flat Rate Box';
UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail<sup>®</sup> Letter' WHERE ServiceCode = 'First-Class Mail';
UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail<sup>®</sup> Large Envelope' WHERE ServiceCode = 'First-Class Mail Flat';
UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail<sup>®</sup> Package' WHERE ServiceCode = 'First-Class Mail Parcel';
UPDATE ac_ShipMethods SET ServiceCode = 'Parcel Post<sup>®</sup>' WHERE ServiceCode = 'Parcel Post';
UPDATE ac_ShipMethods SET ServiceCode = 'Media Mail<sup>®</sup>' WHERE ServiceCode = 'Media Mail';
UPDATE ac_ShipMethods SET ServiceCode = 'Global Express Guaranteed<sup>®</sup> (GXG)' WHERE ServiceCode = 'Global Express Guaranteed (GXG)';
UPDATE ac_ShipMethods SET ServiceCode = 'Global Express Guaranteed<sup>®</sup> Non-Document Rectangular' WHERE ServiceCode = 'Global Express Guaranteed Non-Document Rectangular';
UPDATE ac_ShipMethods SET ServiceCode = 'Global Express Guaranteed<sup>®</sup> Non-Document Non-Rectangular' WHERE ServiceCode = 'Global Express Guaranteed Non-Document Non-Rectangular';
UPDATE ac_ShipMethods SET ServiceCode = 'USPS GXG<sup>™</sup> Envelopes' WHERE ServiceCode = 'USPS GXG Envelopes';
UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail<sup>®</sup> International' WHERE ServiceCode = 'Express Mail International';
UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail<sup>®</sup> International Flat Rate Envelope' WHERE ServiceCode = 'Express Mail International Flat Rate Envelope';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> International' WHERE ServiceCode = 'Priority Mail International';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> International Flat Rate Envelope' WHERE ServiceCode = 'Priority Mail International Flat Rate Envelope';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> International Small Flat Rate Box' WHERE ServiceCode = 'Priority Mail International Small Flat Rate Box';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> International Medium Flat Rate Box' WHERE ServiceCode = 'Priority Mail International Medium Flat Rate Box';
UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail<sup>®</sup> International Large Flat Rate Box' WHERE ServiceCode = 'Priority Mail International Large Flat Rate Box';
UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail<sup>®</sup> International Letter' WHERE ServiceCode = 'First-Class Mail International Letter';
UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail<sup>®</sup> International Large Envelope' WHERE ServiceCode = 'First-Class Mail International Large Envelope';
UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail<sup>®</sup> International Package' WHERE ServiceCode = 'First-Class Mail International Package';