Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Leaderboard

Popular Content

Showing content with the highest reputation on 07/17/2022 in Posts

  1. Very much appreciated Tom. phpMyAdmin is easy for me The most important thing people should remember if they edit the database (or any file) is to download a backup first!
    1 point
  2. Here's the latest version I have - USPS Rate V4 Intl Rate V2_r3.6. USPS Rate V4 Intl Rate V2_r3.6.zip
    1 point
  3. See my post above. Go into phpMyAdmin on your Internet Host's Control Panel (or whatever they use) and access your oscommerce MySQL database. click on the "configuration" table and scroll through all of the lines to find the USPS keys. There's a bunch of them and my configuration is 30+ lines now, so it may take you a while. Don't get mixed up with UPS keys, if you have them. Anyway, find the MODULE_SHIPPING_USPS_TYPES key, click on the "configuration_value" column for that key, and edit out the TM values to "RM." You need to be very careful doing this, because you can blow up the database if you mess something else up. Unless you are fairly confident with phpMyAdmin, the safer way is to uninstall and re-install the USPS shipping module, as suggested earlier. You do that in the oscommerce Admin Control Panel. Login as Admin to your store and the Admin Control Panel (or whatever you may be calling it). Look for Modules->Shipping. Click on "- Remove Module." After you've done that, go right back and click on "Install Module," select "USPS," and install it. WARNING: Print out all of your USPS settings on the right hand side of the page before you uninstall the module. I believe you're going to have re-edit all of those settings when you uninstall and re-install the module. That's why I went for manually editing the database, but as mentioned - that can be dangerous if you're not confident about what you're doing. P.S. I'm running Phoenix, so your mileage may vary from that description above.
    1 point
  4. Many, many thanks for this. I changed all the Priority MailTM, Priority Mail ExpressTM, and Priority Mail Express InternationalTM to "RM", but it didn't work. Saw your post and changed the items in the key MODULE_SHIPPING_USPS_TYPES of the configuration table with phpMyAdmin, and everything worked - no need to uninstall and re-install the USPS module. It's great to see that the legacy oscommerce forum stuff works. I didn't know about this, although I've had a customer or two order with UPS shipping options (the only shipping working, unbeknownst to me). I thought that was strange, but sometimes customers choose higher rates for their own reasons. However, I got an e-mail this morning because I had subscribed to this thread. I hadn't logged into the oscommerce forum in over a year, but got all of this fixed in about a half-hour. YAYYY! P.S. Still stuck on Phoenix 1.0.5, but I guess that's another whole story ... and forum, too!
    1 point
  5. I manually changed the configuration_key MODULE_SHIPPING_USPS_TYPES in the configuration table in the database as well. If you already made the changes in usps.php, then removing and installing the module would update the table. Seems to work ok now. Yeah, really tired of the usps api changes over the years.😠
    1 point
×
×
  • Create New...