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.dllAre there any USPS updates or patches for this version of AbleCommerce? AbleCommerce VersionAbleCommerce 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
|
|
|
|
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-downloadExtract 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 |
|
|
|
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>&trade;</sup>|USPS Priority Mail Express{0} Priority Mail{0}<sup>&trade;</sup>|USPS Priority Mail{0}
Rate V4 response from USPS server contains lines like the one below:
Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt;
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&lt;sup&gt;&#174;&lt;/sup&gt;</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="2"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Hold For Pickup</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="13"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Flat Rate Envelope</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="27"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Flat Rate Envelope Hold For Pickup</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="30"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Legal Flat Rate Envelope</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="31"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Legal Flat Rate Envelope Hold For Pickup</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="62"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Padded Flat Rate Envelope</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="63"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Padded Flat Rate Envelope Hold For Pickup</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="1"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt;</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="22"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Large Flat Rate Box</MailService><Rate>21.50</Rate></Postage><Postage CLASSID="17"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Medium Flat Rate Box</MailService><Rate>16.10</Rate></Postage><Postage CLASSID="28"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Small Flat Rate Box</MailService><Rate>9.45</Rate></Postage><Postage CLASSID="16"><MailService>Priority Mail Flat Rate&lt;sup&gt;&#174;&lt;/sup&gt; Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="44"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Legal Flat Rate Envelope</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="29"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Padded Flat Rate Envelope</MailService><Rate>9.65</Rate></Postage><Postage CLASSID="38"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Gift Card Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="42"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Small Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="40"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Window Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="4"><MailService>USPS Retail Ground&lt;sup&gt;&#174;&lt;/sup&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>
|
|
|
|
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 |
|
|
|
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: <sup>&trade;</sup> 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
|
|
|
|
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 |
|
|
|
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&lt;sup&gt;&#174;&lt;/sup&gt;</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="2"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Hold For Pickup</MailService><Rate>27.85</Rate></Postage><Postage CLASSID="13"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Flat Rate Envelope</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="27"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Flat Rate Envelope Hold For Pickup</MailService><Rate>26.95</Rate></Postage><Postage CLASSID="30"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Legal Flat Rate Envelope</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="31"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Legal Flat Rate Envelope Hold For Pickup</MailService><Rate>27.10</Rate></Postage><Postage CLASSID="62"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Padded Flat Rate Envelope</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="63"><MailService>Priority Mail Express 1-Day&lt;sup&gt;&#174;&lt;/sup&gt; Padded Flat Rate Envelope Hold For Pickup</MailService><Rate>27.50</Rate></Postage><Postage CLASSID="1"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt;</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="22"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Large Flat Rate Box</MailService><Rate>21.50</Rate></Postage><Postage CLASSID="17"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Medium Flat Rate Box</MailService><Rate>16.10</Rate></Postage><Postage CLASSID="28"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Small Flat Rate Box</MailService><Rate>9.45</Rate></Postage><Postage CLASSID="16"><MailService>Priority Mail Flat Rate&lt;sup&gt;&#174;&lt;/sup&gt; Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="44"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Legal Flat Rate Envelope</MailService><Rate>9.25</Rate></Postage><Postage CLASSID="29"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Padded Flat Rate Envelope</MailService><Rate>9.65</Rate></Postage><Postage CLASSID="38"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Gift Card Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="42"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Small Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="40"><MailService>Priority Mail&lt;sup&gt;&#174;&lt;/sup&gt; Window Flat Rate Envelope</MailService><Rate>8.95</Rate></Postage><Postage CLASSID="4"><MailService>USPS Retail Ground&lt;sup&gt;&#174;&lt;/sup&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>
|
|
|
|
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: <sup>&trade;</sup> 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 |
|
|
|
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.
|
|
|
|
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 |
|
|
|
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.
Important Information:
The AbleCommerce Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close