USPS v5 - Bundled and Unbundled shipping

[nefar]

Installed this earlier and began to notice some odd weights in my products.  I went to edit the products to change the weight and noticed nothing would change so I threw debug on and when attempting to change any product data I now get a

500 error:
JDatabaseMySQL::query: 1054 - Unknown column 'ship_alone' in 'field list' SQL=UPDATE `jos_vm_product` SET `vendor_id` = '1', `product_sku` = 'stopper01', `product_name` = 'Bocote Wine Bottle Stopper', `product_desc` = '

[lowmips]

Nefar:
check your jos_vm_product table for a ship_alone field
if it is ship_alone2, rename it to ship_alone
if it does not even exist, just create the ship_alone field

I'm assuming you used the uspsv5.sql file to create the field. This will be about the 3rd time I've re-uploaded the zip file due to that sql call not being correct. I'm not sure if I'm going crazy or if it is being cached somehow or what.  But that is most likely your problem.

[nefar]

Yeah that was it, I was looking through the DB and saw the 2 a few minutes ago. I did copy the sql query out of the usps5.sql file and it does have the 2 in there

[Gaelen Hudson]

Um, any answer to if weight has to be specified in order to use this module?

[lowmips]

Weight of 1lb or greater has to be specified, yes.  USPS will not take a zero weight query.

[tmedina]

I've followed the directions but still have an issue.  Do I still need to create a "Shipper" and "Shipping Rates" when using this mod?

I receive this message: Notice: We are unable to obtain any USPS shipping methods at this time, please choose from one of the following shipping methods.

Could this be due to issues with USPS production server?

I am using Joomla 1.5.9 and VM 1.1.3

[lowmips]

No shipper/shipper rates are used in the mod.

Have you put VM into debug mode to see what the error is?
-Reggie

[tmedina]

Just as I thought, an issue with USPS:

<Error>
   <Number>80040b1a</Number>
   <Description>Authorization failure.  You are not authorized to connect to this server.</Description>
   <Source>UspsCom::DoAuth</Source>
</Error>

I'll have to get in touch with them to correct this.

Thanks for pointing me in the right direction.  I'll update once resolved.

[tmedina]

I believe I have everything working now but receive the following errors:

<Error>
   <Number>80040b1a</Number>
   <Description>API Authorization failure. RateV3 is not a valid API name for this protocol.</Description>
   <Source>UspsCom::DoAuth</Source>
</Error>

Is this version compatible with the API changes made by USPS on 1/18/2009 ?

[lowmips]

I don't think so. 
I just tested the module on my test website, and everything went through just fine.  I've attached a very simplified USPS rate requester for you to try.  Input your username/zip code and see if it works.

-Reggie

[attachment cleanup by admin]

[tmedina]

Thanks for that test code -- finally got USPS to help, they did not have me fully transitioned to the production servers -- that was why I had the errors.  Seems all good now.

Thanks again.  My own testing continues now iwth all these different modules, components, etc.

[kevinmcli]

Hi
    Thanks for the USPS v5 version first. I have downloaded/installed/configured it correctly and it works great!! Only one thing that I need your help:

In the configuration/international shipping options I basically checked everything in it. But in my checkout processes: step 2 of 4, I found that there are missing options. My case is that I have only one thing in my cart, it's weight is 1 lb (for testing use), the missing option is in the step is:
 
Priority Mail International Flat-Rate Box

Can anyone helps me with this?

[lowmips]

Hi kevinmcli,
have you put your shop into debug mode to see what the XML result is? Basically, if that option was not returned by the USPS server, it will not be shown as a choice, and I have a suspicion that this may be the case.

Check the XML result and post your findings here please!
-Reggie

[kevinmcli]

Reggie

         Thanks for your prompt response!! I do open the "report error on frontend" and there is not any errors/XML listed on the checkout frontend.
         The only missing option on the frontend is "Priority Mail International Flat-Rate Box" and the other options seem working fine.
         I went into the uspsv5.php and tried to change the option to the exact naming words with the one on USPS' website. It's working fine now.

[lowmips]

Ah, right. I know there was a recent naming change on some of the services, I've not had time to look into it yet.  I think they added another service also? Not sure.
-Reggie