Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

TomB01

Members
  • Posts

    414
  • Joined

  • Last visited

  • Days Won

    3

Reputation Activity

  1. Thanks
    TomB01 got a reaction from ozEworks Support in USPS Rate V4, Intl Rate V2 (official support thread)   
    Here's the latest version I have - USPS Rate V4 Intl Rate V2_r3.6.
    USPS Rate V4 Intl Rate V2_r3.6.zip
  2. Like
    TomB01 reacted to GetSirius in USPS Rate V4, Intl Rate V2 (official support thread)   
    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!
  3. Like
    TomB01 got a reaction from Smoky Barnable in USPS Rate V4, Intl Rate V2 (official support thread)   
    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!
  4. Thanks
    TomB01 got a reaction from GetSirius in USPS Rate V4, Intl Rate V2 (official support thread)   
    Here's the latest version I have - USPS Rate V4 Intl Rate V2_r3.6.
    USPS Rate V4 Intl Rate V2_r3.6.zip
  5. Like
    TomB01 got a reaction from GetSirius in USPS Rate V4, Intl Rate V2 (official support thread)   
    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.
     
  6. Thanks
    TomB01 reacted to Smoky Barnable in USPS Rate V4, Intl Rate V2 (official support thread)   
    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.😠
  7. Like
    TomB01 reacted to ecartz in FedEx - Web Services v9   
    If it is traversable, then replacing line 313 with
    $cost = (reset($rateReply->RatedShipmentDetails)->ShipmentRateDetail->TotalNetCharge->Amount)/MODULE_SHIPPING_FEDEX_WEB_SERVICES_CURRENCY; might work. 
    Setting it to List and explicitly casting to array might work. 
    foreach ((array)$rateReply->RatedShipmentDetails as $ShipmentRateDetail) I'm not sure what line that is, but it is before 313 and I just added (array) to it. 
    In a test store (not a live store, as it would break it), you could add
    var_dump($rateReply->RatedShipmentDetails); exit(); just before line 313 and see what it says.  Try twice, once each for domestic and international. 
     
  8. Like
    TomB01 reacted to BrockleyJohn in NEW! Complete Order Editing Tool!   
    The code checks which config group ORDER_EDITOR_USE_AJAX is in but it doesn't check if there's more than one occurrence of it (hence my original question).
  9. Like
    TomB01 reacted to BrockleyJohn in NEW! Complete Order Editing Tool!   
    I guess you have been installing and uninstalling. You have somehow added the new settings to config group 18 instead of 19.  Simply edit the config group for the second and last rows to 19.
  10. Like
    TomB01 got a reaction from Krisz1 in Google reCAPTCHA v3   
    Anyway to make this work under php 5.4?  I tried replacing "[]" with "array()" everywhere, but the google recaptcha doesn't appear on either page, create_account or contact_us.
  11. Like
    TomB01 reacted to BrockleyJohn in NEW! Complete Order Editing Tool!   
    That should show up in the configuration group - I guess it means that your original settings didn't have it and you've left it with the second config group id. When you did the update did you get a redirect with a message telling you there were new settings and to check them? It checks for a pre-existing install by looking for one of the settings being defined. I've just put in a change to test a different config (ORDER_EDITOR_USE_AJAX) which should be present in any existing installation of any age.
    I confess I'd not looked at the uninstall sql since updating the addon. I've now redone it to take out any and all configs and groups for the editor.
  12. Like
    TomB01 reacted to BrockleyJohn in NEW! Complete Order Editing Tool!   
    pah, I knew I was going to regret upgrading office 2010
    They're landscape but it didn't pdf them so in word 2020. Try the attached instead
    Order Editor Readme.pdf
  13. Like
    TomB01 reacted to BrockleyJohn in NEW! Complete Order Editing Tool!   
    So, adding the same product on two different order lines was messing up the shipping calculations (even if with different options). I reckon that shipping modules based on price didn't get the right results either. This is fixed (cart products are now indexed on uprid and the restore checks for existing key), along with the Edit button issue and also the redirect error on a fresh install.
    Uploaded to https://apps.oscommerce.com/Apps&wwEZ9&order-editor-for2-3-v1-0
    @ArtcoInc @TomB01
    Tested on 2.3.4 classic, Phoenix 1.0.4.0 and a bunch of bs versions in between but please flag up any issues.
  14. Like
    TomB01 reacted to ecartz in USPS Rate V4, Intl Rate V2 (official support thread)   
    The ones that remain are the ones that change from store to store.  For example, your catalog directory might be in the root at / or at /catalog/ or at something like /shop/.  Each store can choose to do something different.  Meanwhile, images/icons/ is always images/icons/ -- there is very little reason to ever change it.  Even if you did want to change it in the URL, you could use something like mod_rewrite so that the directory structure would stay the same. 
    In general, most of the constant ones have gone, leaving only the few variable choices.  I find it rather unlikely that we'd take out more of the DIR_WS values (except possibly DIR_WS_HTTPS_CATALOG).  More likely to go would be HTTPS values and USE_PCONNECT.  USE_PCONNECT because mysqli does that in the DB_SERVER.  The HTTPS values because very few stores used mixed HTTP and HTTPS today.  So why support something that no one uses? 
    The two DIR_FS_DOWNLOAD values may go.  And STORE_SESSIONS. 
    The following are pretty safe, although the HTTP ones might get renamed (or not): 
    define('HTTP_SERVER', ''); // eg, http://localhost - should not be empty for productive servers define('HTTP_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', ''); define('DIR_FS_CATALOG', dirname($_SERVER['SCRIPT_FILENAME']) . '/'); // define our database connection define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); DIR_WS_CATALOG is defined elsewhere, but also pretty safe. 
  15. Like
    TomB01 reacted to ecartz in USPS Rate V4, Intl Rate V2 (official support thread)   
    I wouldn't say it that way.  What should be replaced is
    " . TABLE_CONFIGURATION . " and it gets replaced with
    configuration So that the string looks like
    insert into configuration ( It will sort of work if you replace TABLE_CONFIGURATION with configuration, but it will generate a notice that may appear in the logs.  And of course if anyone ever made a constant named configuration, it would break. 
    Normally, I'd recommend replacing
    $this->icon = DIR_WS_ICONS . 'shipping_usps.gif'; with
    $this->icon = DIR_WS_CATALOG . 'images/icons/shipping_usps.gif'; Because that will work regardless of where the catalog directory is located. 
    If you use the <> tool to insert code in the forums, it will be easier to tell it from the surrounding text. 
  16. Like
    TomB01 got a reaction from altoid in USPS Rate V4, Intl Rate V2 (official support thread)   
    1) A bit of miscommunication; I'm familiar with phpMyAdmin, and am prepared to copy and poke.  I was just trying to figure out where to place the actual values in those SQL statements.  I think the country is already defined in your first SQL statement with ID = 223, but was trying to figure out the best place to put the real value of my zip code (5 digits) in the second SQL statement.
    2) Kymation has taken it upon himself to support the USPS Rate V4 module for the last several years, thank goodness!  I will be dead as an e-commerce store if I don't have USPS shipping.
  17. Like
    TomB01 got a reaction from diannecl in [Development] USPS Shipping Module   
    Feature suggestions are kind of trivial compared to your primary goal. :)
     
    However, since you asked - it would sure be a neat trick if you could associate different shipping methods with specific products in your catalog. I have things that when sold internationally, simply have to be insured because of the $$ involved. However, Priority Mail is the minimum service that USPS allows for insurance on international shipping (in some cases, that's not even enough - it has to be Express). I kind of draw the line at about $150 - less than that, and 1st Class International without insurance is something I'm willing to accept. More than that and I'm not. I put "Priority Mail Shipping Required" in my catalog listings for those things more than $150, but that's not good enough. Some people select 1st Class anyway (because I want to offer that for lower-priced items). Then I have to contact them, explain my policies, etc., etc. and revise the invoice and ask them for an additional payment. It's a real hassle and would be easily solved if one could associate specific shipping options with a specific product.
  18. Like
    TomB01 got a reaction from dr_lucas in FedEx - Web Services v9   
    This is another one where the module/code makes me feel pretty stupid.  This is entirely setup in the admin-configuration for the FedEx module.  "International Ground" apparently means FedEx Ground if you are in an international country (Canada).  For some reason, I thought "International Ground" would work for a Canadian address.  Disable it, and the domestic rate option of "FedEx Ground" disappears from the checkout.  "FedEx Ground" does not actually show up for any addresses, including Canada.  The only ground service that shows up is "Ground Home Delivery" for US addresses (if your store is in the US and you enable "Ground").
  19. Like
    TomB01 got a reaction from Bob Terveuren in Support for Stripe.com?   
    Got my first credit card sale and shipped it, so I consider this a success. :)
  20. Like
    TomB01 got a reaction from bkpie in [Contribution] - USPS Methods   
    Yep - worse than before. I'll take some time today and see if I can install 5.2.2 from scratch and go from there. Hopefully, it will resolve the database, too - because now I've got semi-duplicate fields for many of the same services/options under USPS.
  21. Like
    TomB01 got a reaction from videod in [Contribution] - USPS Methods   
    WARNING!
    Received today in my e-mail:
     
     
    Have any of you experts looked at this? Think it will break things?
     
     
    EDIT: Tried to clean up the formatting; their bullet list didn't copy-paste well ...
  22. Like
    TomB01 got a reaction from maxtors in Is USPS shipping module down   
    OK, this was tough to figure out - what you meant for "find" and what was actually changed/added. I went through it and think I got it all. International shipping now partially works - I can't get First Class International, though.
  23. Like
    TomB01 reacted to heartbroke in Is USPS shipping module down   
    Right now my customers get this error msg when they checkout:
     
    "An error occured with the USPS shipping calculations.
    If you prefer to use USPS as your shipping method, please contact the store owner."
     
     
    It was working yesterday.
×
×
  • Create New...