[Fixed - See post 26] USPS International shipping problem...

IF you go to phpMyAdmin and select your database and run this in the SQL do you see about 14 settings come up for USPS:

SELECT *
FROM `configuration`
WHERE `configuration_key` LIKE '%MODULE_SHIPPING_USPS%'

I see 29 configurations and they repeat. So, seems like the DB has got duplicate entries that are confusing things? Do I just delete half and if so, how do I know which half to delete? I see there is a "date Added" column, just delete the older ones?

Correction, there are 679 entries. Seems to be the same ones repeating over and over. Could be duplicate entries have been made every time I changed something in this module ?

If you look at the structure for the table:
configuration

What index do you see? :unsure:

You will want to delete all of the configuration_key that start with:
MODULE_SHIPPING_USPS_

Then go to your Modules ... Shipping ... and make sure that you see the red dot ...

My Indexes appear as per the attached screen shot,

Success! That did the trick. I don't know how the DB got so hosed in the first place but things seem to be working now. I did indeed see the red dot after deleting all the necessary DB entries. Did the install, I now see the "remove" button and First Class International is working now.

No way I would have resolved this one without your help Linda. Thanks so much! Coffee and Donuts headed your way again.

Essentially the same issue as this: http://www.zen-cart.com/forum/showthread.php?t=176023

Yes cleaning those duplicates up is important, and rebuilding the unique key that DrByte pointed out is also needed as it is missing from your configuration table ...

Yes, ran the sql command in DrBytes other post and I can see I have a bunch of dups. Any easy way to find and delete all of these or I should resign myself to crawling through the configuration table manually ? Any suggestion how I can avoid this problem in the future?

Browse the configuration table in phpMyAdmin and sort on configuration_key ...

When you find duplicates, delete the higher configuration_id ...

NOTE: backup your database before attempting to clean it ...

I just started using Zen Cart 1.3.9h, and was having issues with shipping as well. So installed that fix from post #26 (even though it was probably already part of this version) and turned on debugging. It appears that the USPS servers were not able to communicate with Zen Cart in test mode and therefore the USPS servers would not activate my account.

I spent the afternoon talking with the USPS support people via email, and they eventually asked what shopping cart software I was using so they can manually authorize the account. After they did so the shipping module is now working.

I figured that it would be a good idea to post this for others to see. If you are having issues with that module, put on the debugging and have the info emailed to you. It kept me from pulling my hair out!

Now to solve other issues I am having. Thanks for an active forum!
Tom

The test server with USPS rarely works ... just go to Production and call and ask USPS to activate your account and all will be working with the Jaunary 2, 2011 C version from post #26 ...

Thanks again for confirming that is all that was needed. ^5

Disregard

As an update fix posted I had left out changing that and afraid the confusion may be there for awhile, until the next release of Zen Cart ...

But yes ... it would have helped add something to make the module stand out more as a current release with more to verify against ... :lamo:

Again, thanks :)

I'm using a fresh install of zen cart and installed the usps shipping module as well as the usps patch from post 26. My problem is that i've selected first class shipping as an option, but it's not showing up. Only priority and express mail options are showing. My store isnt live, i'm still in testing. I've been going through the forums to see if someone else had this issue but cant find one similar. Thanks in advance for any help.

If the weight is too high 1st class isn't offered. Add a 1 oz item to the cart and see if 1st class shows.
Tom

Hi Tom and thanks for the assist. I gave it a try and still no luck.

I figured it out! :) I had to edit the "Package Tare Small to Medium - added percentage:weight". That fixed it. Thanks again for the help Tom.