USPS Rates

[comptech520]

Hi,

I have USPS rates enabled setup in SC, when in shipping options, the rates don't appear.

Any ideas on that?

It is set to shipping priority 1

[Jamie]

Have you looked through this page?
http://squirrelcart.com/help/?Real%2...0Overview.html

For real time rates to be returned:

1. You must have a company address entered on your Store Settings page
2. The items in the cart must have weights assigned to them
3. You must have the shipping courier enabled
4. You must have shipping methods for that courier enabled
5. You must have RTR setup for the shipping courier, and it must be setup properly per our documentation
6. CURL and OpenSSL must be present and working on your server

[jonbius]

Hi Jamie,

Thanks for that checklist. I'm having trouble with the cart at this site:
https://www.beyondboobsinc.org/cart/store.php

I've gone through the checklist you provided, and it looks to me like everything is OK according to that, but basically, when you get to the area where you select shipping, it falls back to the RTR Failure rate. I've called the USPS, and from their end, the RTR number I plugged in to the cart is OK. The hosting provider said we're good to go on the items needed for the server.

Any suggestions?

TIA for any help- I do appreciate it!

[Jamie]

Try this:
1. Login as store admin

2. Check the "Diagnostics Mode" checkbox on the storefront page, in the "Admin Options" nav block. If it's already checked, uncheck it, then check it again.

A popup window will open.

3. Checkout. When you get to the shipping rate page, look in the diag window. You should see the rate request made to USPS and their response. Paste the response here.

[jonbius]

OK.... I'm not sure how much you need to see.... so I grabbed the whole deal.

It's still falling back to the RTR failure, but it looks like the Post office is returning a rate.

Thanks so much for your help Jamie.

=======================================

Squirrelcart Diagnostics Mode

05/06/2011 13:43:31
Checking Rule_Set...
Purpose: To determine if shipping rule #20 "Real Time Rate Failure" applies.
record_number: 129
Name: none specified
Description: none specified
Rule_Formula:
Looking for Rules...
Found 1 Rule(s)...

Checking Rule 1: TRUE
Type: order_in_progress
Looking for Conditions...
Found 1 Condition(s)...
Checking condition Condition_1:TRUE
field:Weight_Total is greater than or equal to ".0001"


05/06/2011 13:43:31
Checking Rule_Set...
Purpose: To determine if shipping rule #17 "Real Time Rate Failure" applies.
record_number: 133
Name: none specified
Description: none specified
Rule_Formula:
Looking for Rules...
Found 1 Rule(s)...

Checking Rule 1: TRUE
Type: order_in_progress
Looking for Conditions...
Found 1 Condition(s)...
Checking condition Condition_1:TRUE
field:Weight_Total is greater than or equal to ".0001"


05/06/2011 13:43:31
Attempting connection to http://production.shippingapis.com/ShippingAPI.dll...
Request type: POST
Sending the following field/value pairs:
Field Value
API RateV3
XML

<RateV3Request USERID="xxxxxxxxx">
<Package ID="0">
<Service>EXPRESS</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
</Package>
<Package ID="1">
<Service>FIRST CLASS</Service>
<FirstClassMailType>LETTER</FirstClassMailType>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
<Package ID="2">
<Service>PRIORITY</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
</Package>
<Package ID="3">
<Service>PARCEL</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
<Package ID="4">
<Service>BPM</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
<Package ID="5">
<Service>MEDIA</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
</RateV3Request>

Request being sent via CURL...
Remote server responded with HTTP code: 200, "OK"
Total request time: 0.504411 seconds.

Response from remote host:

<?xml version="1.0"?>
<RateV3Response>
<Package ID="0">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Zone>3</Zone>
<Postage CLASSID="3">
<MailService>Express Mail&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>21.05</Rate>
</Postage>
</Package>
<Package ID="1">
<Error>
<Number>-2147219434</Number>
<Source>DomesticRatesV3;clsRateV3.ValidateWeight;R ateEngineV3.ProcessRequest</Source>
<Description>First Class mail must weigh 13 ounces or less.</Description>
<HelpFile>
</HelpFile>
<HelpContext>1000440</HelpContext>
</Error>
</Package>
<Package ID="2">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Zone>3</Zone>
<Postage CLASSID="1">
<MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>5.15</Rate>
</Postage>
</Package>
<Package ID="3">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
<Zone>3</Zone>
<Postage CLASSID="4">
<MailService>Parcel Post&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>5.15</Rate>
</Postage>
</Package>
<Package ID="4">
<Error>
<Number>-2147219432</Number>
<Source>DomesticRatesV3;clsRateV3.CreateSinglePost age-CreateSinglePostage;RateEngineV3.ProcessRequest</Source>
<Description>Service not available.</Description>
<HelpFile>
</HelpFile>
<HelpContext>1000440</HelpContext>
</Error>
</Package>
<Package ID="5">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Zone>3</Zone>
<Postage CLASSID="6">
<MailService>Media Mail&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>2.41</Rate>
</Postage>
</Package>
</RateV3Response>

[Jamie]

They returned rates for:
Priority Mail
Parcel Post
Media Mail

1. Do you have these shipping methods enabled?

2. What do you have the RTR Priority field set to on your USPS shipping courier record?

3. What do you have the Priority set to on your shipping rules?

4. Did you apply this bug fix, if needed? (I don't know what version you are running)
http://www.ldev.com/forums/showthrea...highlight=usps

[jonbius]

1. I have the following enabled: First Class Mail, Priority Mail
2. It's set to 10
3. They are set to 1
4. I hadn't done that. I've now applied that.

I ran the same transaction again, and it gave me a different rate than I've seen before, $5.15. I enabled diagnostic mode, and this is what I got:

Squirrelcart Diagnostics Mode

05/09/2011 07:47:55
Attempting connection to http://production.shippingapis.com/ShippingAPI.dll...
Request type: POST
Sending the following field/value pairs:
Field Value
API StandardB
XML

<StandardBRequest USERID="791BIZTO1880">
<OriginZip>23168</OriginZip>
<DestinationZip>28303</DestinationZip>
</StandardBRequest>

Request being sent via CURL...
Remote server responded with HTTP code: 200, "OK"
Total request time: 0.112521 seconds.

Response from remote host:

<?xml version="1.0"?>
<StandardBResponse>
<OriginZip>231</OriginZip>
<DestinationZip>283</DestinationZip>
<Days>5</Days>
</StandardBResponse>


05/09/2011 07:47:55
Attempting connection to http://production.shippingapis.com/ShippingAPI.dll...
Request type: POST
Sending the following field/value pairs:
Field Value
API StandardB
XML

<StandardBRequest USERID="xxxxxxxxxx">
<OriginZip>23168</OriginZip>
<DestinationZip>28303</DestinationZip>
</StandardBRequest>

Request being sent via CURL...
Remote server responded with HTTP code: 200, "OK"
Total request time: 0.112413 seconds.

Response from remote host:

<?xml version="1.0"?>
<StandardBResponse>
<OriginZip>231</OriginZip>
<DestinationZip>283</DestinationZip>
<Days>5</Days>
</StandardBResponse>


05/09/2011 07:47:55
Attempting connection to http://production.shippingapis.com/ShippingAPI.dll...
Request type: POST
Sending the following field/value pairs:
Field Value
API PriorityMail
XML

<PriorityMailRequest USERID="791BIZTO1880">
<OriginZip>23168</OriginZip>
<DestinationZip>28303</DestinationZip>
</PriorityMailRequest>

Request being sent via CURL...
Remote server responded with HTTP code: 200, "OK"
Total request time: 0.114638 seconds.

Response from remote host:

<?xml version="1.0"?>
<PriorityMailResponse>
<OriginZip>231</OriginZip>
<DestinationZip>283</DestinationZip>
<Days>2</Days>
</PriorityMailResponse>


05/09/2011 07:47:55
Attempting connection to http://production.shippingapis.com/ShippingAPI.dll...
Request type: POST
Sending the following field/value pairs:
Field Value
API RateV3
XML

<RateV3Request USERID="791BIZTO1880">
<Package ID="0">
<Service>EXPRESS</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
</Package>
<Package ID="1">
<Service>FIRST CLASS</Service>
<FirstClassMailType>LETTER</FirstClassMailType>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
<Package ID="2">
<Service>PRIORITY</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
</Package>
<Package ID="3">
<Service>PARCEL</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
<Package ID="4">
<Service>BPM</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
<Package ID="5">
<Service>MEDIA</Service>
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
</Package>
</RateV3Request>

Request being sent via CURL...
Remote server responded with HTTP code: 200, "OK"
Total request time: 0.479093 seconds.

Response from remote host:

<?xml version="1.0"?>
<RateV3Response>
<Package ID="0">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Zone>3</Zone>
<Postage CLASSID="3">
<MailService>Express Mail&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>21.05</Rate>
</Postage>
</Package>
<Package ID="1">
<Error>
<Number>-2147219434</Number>
<Source>DomesticRatesV3;clsRateV3.ValidateWeight;R ateEngineV3.ProcessRequest</Source>
<Description>First Class mail must weigh 13 ounces or less.</Description>
<HelpFile>
</HelpFile>
<HelpContext>1000440</HelpContext>
</Error>
</Package>
<Package ID="2">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Zone>3</Zone>
<Postage CLASSID="1">
<MailService>Priority Mail&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>5.15</Rate>
</Postage>
</Package>
<Package ID="3">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Machinable>TRUE</Machinable>
<Zone>3</Zone>
<Postage CLASSID="4">
<MailService>Parcel Post&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>5.15</Rate>
</Postage>
</Package>
<Package ID="4">
<Error>
<Number>-2147219432</Number>
<Source>DomesticRatesV3;clsRateV3.CreateSinglePost age-CreateSinglePostage;RateEngineV3.ProcessRequest</Source>
<Description>Service not available.</Description>
<HelpFile>
</HelpFile>
<HelpContext>1000440</HelpContext>
</Error>
</Package>
<Package ID="5">
<ZipOrigination>23168</ZipOrigination>
<ZipDestination>28303</ZipDestination>
<Pounds>1</Pounds>
<Ounces>0</Ounces>
<Container>
</Container>
<Size>REGULAR</Size>
<Zone>3</Zone>
<Postage CLASSID="6">
<MailService>Media Mail&amp;lt;sup&amp;gt;&amp;amp;reg;&amp;lt;/sup&amp;gt;</MailService>
<Rate>2.41</Rate>
</Postage>
</Package>
</RateV3Response>

[Jamie]

If you didn't have the update applied, it wouldn't have worked properly. It looks like it's working now.

[jonbius]

Thanks so much for your help Jamie! I guess I should do better keeping up with updates!