USPS changes effective Jan 4th 2010

Applies to: All versions of AbleCommerce 7.x

Release Date:  1/7/2010

A NEWER VERSION IS AVAILABLE HERE

 

DETAILS

IMPORTANT UPDATE

The United States Postal Service notified it's integration providers of a price change effective January 4th, 2010.  This is part of the email that was sent on Saturday, January 2nd:

Dear Web Tools integrator,

Effective January 4, 2010, 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).

 

Unfortunately, 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 you 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.

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

  1. 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\
 

  1. Launch a browser and access the PatchUSPS update.

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

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

  2. Remove the \install\ folder and file.

 

RUN THIS 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 Flat Rate Envelope' WHERE ServiceCode = 'Express Mail Flat-Rate Envelope';

UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail Flat Rate Envelope' WHERE ServiceCode = 'Priority Mail Flat-Rate Envelope';

UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail Medium Flat Rate Box' WHERE ServiceCode = 'Priority Mail Flat-Rate Box';

UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail Large Flat Rate Box' WHERE ServiceCode = 'Priority Mail Large Flat-Rate Box';

UPDATE ac_ShipMethods SET ServiceCode = 'Global Express Guaranteed (GXG)' WHERE ServiceCode = 'Global Express Guaranteed';

UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail International' WHERE ServiceCode = 'Express Mail International (EMS)';

UPDATE ac_ShipMethods SET ServiceCode = 'Express Mail International Flat Rate Envelope' WHERE ServiceCode = 'Express Mail International (EMS) Flat-Rate Envelope';

UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail International Large Flat Rate Box' WHERE ServiceCode = 'Priority Mail International Large Flat-Rate Box';

UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail International Medium Flat Rate Box' WHERE ServiceCode = 'Priority Mail International Flat-Rate Box';

UPDATE ac_ShipMethods SET ServiceCode = 'Priority Mail International Flat Rate Envelope' WHERE ServiceCode = 'Priority Mail International Flat-Rate Envelope';

UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail International Letter' WHERE ServiceCode = 'First Class Mail International Letters';

UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail International Flat' WHERE ServiceCode = 'First Class Mail International Flats';

UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail International Parcel' WHERE ServiceCode = 'First Class Mail International Parcels';

UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail International Large Envelope' WHERE ServiceCode = 'First Class Mail International Large Envelope';

UPDATE ac_ShipMethods SET ServiceCode = 'First-Class Mail International Package' WHERE ServiceCode = 'First Class Mail International Package';