logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
pdsteiner8198692  
#1 Posted : Wednesday, August 3, 2022 11:09:30 AM(UTC)
pdsteiner8198692

Rank: Member

Groups: Authorized User, HelpDesk
Joined: 12/30/2020(UTC)
Posts: 13

Hi,

For the past couple of months USPS has just stopped working for our webstore. I checked the USPS log the rates are received but somehow they don't match with the usps methods in the uspsmethods.csv file or the USPS module is obsolete. Here is the URL for the USPS shipping API:

https://production.shipp...apis.com/ShippingAPI.dll

Are there any USPS updates or patches for this version of AbleCommerce?

AbleCommerce Version

AbleCommerce for ASP.NET
VERSION: 7.0.7.14600
MSSQL v>2008
AC SCHEMA v2005
.NET CLR v4.0.30319.42000
ASP.NET TRUST: Unrestricted

AjaxControlToolkit: 3.0.20229.20843
CommerceBuilder: 7.7.14567.1
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.3.14358.0

Edited by user Wednesday, August 3, 2022 11:27:25 AM(UTC)  | Reason: Not specified

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

Katie S  
#2 Posted : Thursday, August 4, 2022 1:25:29 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 472

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Hello,

Well, first I must say that the version you are using was released over 11 years ago. That makes it very difficult to even locate any old documentation.

You are on the right track to troubleshooting the issue though. The USPS debug logs are going to give you everything needed to figure this out.

The best advice I can offer is to download a development copy of AbleCommerce version 9 here: https://www.ablecommerce.com/free-download

Extract the files and find the current CSV file. Open both files and review the shipping service names in each. Try to update the names in your AC7 file to match the new names that USPS supports. Don't try to put the AbleCommerce 9 version of the CSV file in your AC7 install. That won't work.

You really should think about upgrading at some point. We support a direct upgrade from v 7 to the latest (database records only).

Let me know if you have any questions.
Katie
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
pdsteiner8198692  
#3 Posted : Friday, August 5, 2022 11:45:16 AM(UTC)
pdsteiner8198692

Rank: Member

Groups: Authorized User, HelpDesk
Joined: 12/30/2020(UTC)
Posts: 13

Thank you, Katie.

Here is the uspsmethods.csv from version 9, just two lines:

// US DOMESTIC SERVICES, '{0}' IN THE NAMES DENOTES A VARIABLE DEPENDING ON THE SCHEDULED DELIVERY DATE CALCULATION BETWEEN THE ORIGIN AND DESTINATION ZIP CODES. POSSIBLE VALUES: ì1-DAYî, ì2-DAYî, ì3-DAYî, ìMILITARYî, ìDPOî, ì ì
Priority Mail Express{0}<sup>™</sup>|USPS Priority Mail Express{0}
Priority Mail{0}<sup>™</sup>|USPS Priority Mail{0}

Rate V4 response from USPS server contains lines like the one below:

Priority Mail Express 1-Day<sup>®</sup>

How should I replace the variable '{0}'? What about the possible values such as: ì1-DAYî, ì2-DAYî, ì3-DAYî, ìMILITARYî, ìDPOî, ì ì, what do these chars mean ì ì ???

Thank you.

Receive: <?xml version="1.0" encoding="UTF-8"?>
<RateV4Response><Package ID="0"><ZipOrigination>05478</ZipOrigination><ZipDestination>05478</ZipDestination><Pounds>2</Pounds><Ounces>0.0</Ounces><Machinable>TRUE</Machinable><Zone>1</Zone><Postage CLASSID="3"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt;</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="2"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Hold For Pickup</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="13"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Flat Rate Envelope</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="27"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Flat Rate Envelope Hold For Pickup</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="30"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Legal Flat Rate Envelope</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="31"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Legal Flat Rate Envelope Hold For Pickup</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="62"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Padded Flat Rate Envelope</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="63"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Padded Flat Rate Envelope Hold For Pickup</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="1"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt;</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="22"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Large Flat Rate Box</MailService><Rate>21.50</Rate></Postage><Postage CLASSID="17"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Medium Flat Rate Box</MailService><Rate>16.10</Rate></Postage><Postage CLASSID="28"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Small Flat Rate Box</MailService><Rate>9.45</Rate></Postage><Postage CLASSID="16"><MailService>Priority Mail Flat Rate&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="44"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Legal Flat Rate Envelope</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="29"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Padded Flat Rate Envelope</MailService><Rate>9.65</Rate></Postage><Postage CLASSID="38"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Gift Card Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="42"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Small Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="40"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Window Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="4"><MailService>USPS Retail Ground&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt;</MailService><Rate>9.05</Rate></Postage><Postage CLASSID="6"><MailService>Media Mail Parcel</MailService><Rate>4.16</Rate></Postage><Postage CLASSID="7"><MailService>Library Mail Parcel</MailService><Rate>3.95</Rate></Postage></Package></RateV4Response>
Katie S  
#4 Posted : Friday, August 5, 2022 12:20:47 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 472

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Quote:
How should I replace the variable '{0}'?


The variables are:
POSSIBLE VALUES: “1-DAY”, “2-DAY”, “3-DAY”, “MILITARY”, “DPO”

So for each service that shows {0}, you will need to add 5 separate entries for each variable above.

Quote:
what do these chars mean ì ì ???


Looks like a problem with the file? I don't see this. They should be surrounded by quotes. Try opening in notepad or Excel.

Also, this has not been tested, so before spending a lot of time updating all services, you should try updating one and then giving it a test.

Be sure to keep a backup of your original.

Good Luck!

Thanks for your support!

Katie
Secure eCommerce Software and Hosting
pdsteiner8198692  
#5 Posted : Friday, August 5, 2022 12:44:38 PM(UTC)
pdsteiner8198692

Rank: Member

Groups: Authorized User, HelpDesk
Joined: 12/30/2020(UTC)
Posts: 13

Katie,

I just updated just one service (USPS Priority Mail Express) but our shipping estimator isn't picking it up even though USPS rate response includes the ZIP code specified (Vermont, 05478), see screenshots. What could be the issue?

Note: USPS Priority is a shipping method with flat rate added by us manually to cover the USPS shipping issues.

By the way uspsmethods file contains these encrypted HTML codes: &lt;sup&gt;&amp;trade;&lt;/sup&gt; What do they mean, is the registered mark symbol? Could it be the culprit?

Screen Shot 2022-08-05 at 20.37.54.png (55kb) downloaded 0 time(s). Screen Shot 2022-08-05 at 20.37.29.png (177kb) downloaded 6 time(s).

Edited by user Friday, August 5, 2022 12:47:01 PM(UTC)  | Reason: Not specified

Katie S  
#6 Posted : Friday, August 5, 2022 1:01:37 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 472

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Can you check the USPS log file and see what the response is?
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
pdsteiner8198692  
#7 Posted : Friday, August 5, 2022 1:06:44 PM(UTC)
pdsteiner8198692

Rank: Member

Groups: Authorized User, HelpDesk
Joined: 12/30/2020(UTC)
Posts: 13

Sure, here is the response:

Receive: <?xml version="1.0" encoding="UTF-8"?>
<RateV4Response><Package ID="0"><ZipOrigination>05478</ZipOrigination><ZipDestination>05478</ZipDestination><Pounds>2</Pounds><Ounces>0.0</Ounces><Machinable>TRUE</Machinable><Zone>1</Zone><Postage CLASSID="3"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt;</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="2"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Hold For Pickup</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="13"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Flat Rate Envelope</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="27"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Flat Rate Envelope Hold For Pickup</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="30"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Legal Flat Rate Envelope</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="31"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Legal Flat Rate Envelope Hold For Pickup</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="62"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Padded Flat Rate Envelope</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="63"><MailService>Priority Mail Express 1-Day&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Padded Flat Rate Envelope Hold For Pickup</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="1"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt;</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="22"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Large Flat Rate Box</MailService><Rate>21.50</Rate></Postage><Postage CLASSID="17"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Medium Flat Rate Box</MailService><Rate>16.10</Rate></Postage><Postage CLASSID="28"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Small Flat Rate Box</MailService><Rate>9.45</Rate></Postage><Postage CLASSID="16"><MailService>Priority Mail Flat Rate&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="44"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Legal Flat Rate Envelope</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="29"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Padded Flat Rate Envelope</MailService><Rate>9.65</Rate></Postage><Postage CLASSID="38"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Gift Card Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="42"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Small Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="40"><MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt; Window Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="4"><MailService>USPS Retail Ground&amp;lt;sup&amp;gt;&amp;#174;&amp;lt;/sup&amp;gt;</MailService><Rate>9.05</Rate></Postage><Postage CLASSID="6"><MailService>Media Mail Parcel</MailService><Rate>4.16</Rate></Postage><Postage CLASSID="7"><MailService>Library Mail Parcel</MailService><Rate>3.95</Rate></Postage></Package></RateV4Response>
Katie S  
#8 Posted : Friday, August 5, 2022 1:23:17 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 472

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Well, I don't see any errors so I'm not sure what could be wrong.

You are getting appropriate services "Priority Mail Express 1-Day" and rates so there must be some other issue that is not related.

Quote:
encrypted HTML codes: &lt;sup&gt;&amp;trade;&lt;/sup&gt; What do they mean


These should be fine. Just like you said, this is the HTML version for special characters.

So, at this point, you can either wait for additional responses from the community or you can purchase support time and we can have a developer help you with this project.

https://www.ablecommerce...chnical-Support-Incident
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
pdsteiner8198692  
#9 Posted : Friday, August 5, 2022 1:43:32 PM(UTC)
pdsteiner8198692

Rank: Member

Groups: Authorized User, HelpDesk
Joined: 12/30/2020(UTC)
Posts: 13

Could be the CommerceBuilder.USPS.dll module? Well, we can't afford $150 per hour support, it might take hours. I thought this is a well known issue, I'm surprised nobody else is having this issue.
Katie S  
#10 Posted : Friday, August 5, 2022 4:19:43 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 472

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Quote:
I checked the USPS log the rates are received but somehow they don't match with the usps methods in the uspsmethods.csv file


By updating the CSV file, this should have taken care of the issue, but as far as I know, no one has attempted to upgrade USPS for AbleCommerce 7.

I'm sorry that you are now stuck in this position. The software is over 11 years old, and you'll need to make a decision about upgrading at some point. Whether it's AbleCommerce or some other platform, the Operating System and other dependent software will also become deprecated, if they aren't already.

We do have some more options for licensing here:
https://www.ablecommerce...ng-Cart-Software-Pricing

Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.