Installing the USPS patch
After downloading the patch file, extract the contents to a
temporary folder on the AbleCommerce server.
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.
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\
Launch a browser
and access the PatchUSPS update.
e.g.
http://yourwebsite/install/PatchUSPS.aspx
Confirm that you
want to run the script, and do so.
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'; |