Jump to content

Demitry

Members
  • Content count

    288
  • Joined

  • Last visited

  • Days Won

    8

Everything posted by Demitry

  1. Demitry

    New UPS XML Shipping Module available

    Thank John, I completely agree that this cURL option should not be set as default considering that the TLS version setting will vary from one hosting company to another. However, I think it should probably be added and commented out same as the cURL [60] error, in case someone finds this in their upsxml.log Along with the details of what number to use for each of the specific TLS versions. My initial issue was that UPS deleted my account for inactivity. After reviewing the upsxml.log I found that it was using my UPS login info to communicate with the UPS gateway. So, I thought this was the problem. However, after creating a new UPS account, I was still getting that error. So, I went back into that upsxml.log and found the cURL [35] error, ..and well, you know the rest. The weird thing too is that every once in a while, the UPS rates would display. So, this "Rating and Service" error was not consistent. Demitry
  2. Demitry

    Multi_Vendor_Shipping new thread

    Hi, If you’re getting the following error at checkout for UPS, ... Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway Then you should read this post: http://forums.oscommerce.com/topic/49382-new-ups-xml-shipping-module-available/?p=1743950 Demitry
  3. Demitry

    New UPS XML Shipping Module available

    Hi, I want to share my trouble shooting & solution for the dreaded UPS “Rating and Service” error. It could actually be one, or several different issues. I hope this helps others because I spent a lot of time trying to resolve this problem and could not find much on the Internet. If you’re getting the following error at checkout for UPS, then you should read this post. Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway The first and easiest step is to check if your UPS User ID and Password still work on the UPS site. UPS deletes non-active accounts after 18 months. So, if you’re using drop-shipping and not shipping anything yourself via UPS, but only providing the UPS rates on your site as a courtesy to the customer, you must log into your UPS account via their site once a year to keep it active. If your account was deleted, you will need to create a new one. The UPS tech support will guide you through it. If there are no issues with your UPS account & login info, then the next step is to run the debugging script. To do this you have to follow the steps in one of the following files. /includes/modules/shipping/upsxml.php If you’re using the Multi-Vendor Shipping (MVS) contribution: /includes/modules/vendors_shipping/upsxml.php Search the contents of the upsxml.php file for “upsxml.log” and follow the directions to create a log file and set file permissions. Then run a test checkout (partial - only to the checkout_shipping.php page). The details of this are explained in this older thread. Much respect goes to Jan Zonjee for his help there. http://forums.oscommerce.com/topic/248356-ups-xml-rates-services-v124-error/ Download the log file and search it for errors. You are likely to have cURL errors. cURL is a command line tool for getting or sending files using URL syntax. It is used by the UPS API gateway in providing real time rates to your store site. If there are no cURL errors, you should call your hosting company’s tech support and ask them if cURL is compiled into PHP for your account. If it is not, then search the upsxml.php file for “when cURL is not compiled into PHP” and follow those directions to test further. If you get the cURL [60] error, then there is a line in the upsxml.php file that you can uncomment (on or around line 736 or 811, see below), then save, upload, and do a partial test checkout again. That line is: curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); If you get the cURL Error [35]: SSL connect error, then you have entered my world. I contacted UPS tech support and sent them the upsxml.log file, and this was their response: “The UPS API's no longer support SSL. The UPS API's now support TLS 1.0, 1.1 and 1.2. If your solution is browser based, make sure that TLS 1.2 is enabled in the security settings. If your solution is server based, you will need to write the necessary code to make this change to your security protocol.” So, if you have an SSL certificate installed for your store, you would have to call your hosting company’s tech support and find out what version of TLS is enabled in the server security settings. Right now, I have an SSL certificate by COMODO and my hosting company has the TLS 1.2 enabled. Based on that information I found a link that provided the one-line solution that finally fixed my UPS module problem and got rid of that pesky “Rating and Service” error. Here it is: https://stackoverflow.com/questions/30145089/tls-1-2-not-working-in-curl And here is the line I had to add to upsxml.php I added it with the other curl_setopt options. You can just search for “curl_setopt” in the upsxml.php curl_setopt($ch, CURLOPT_SSLVERSION, 6); // Integer NOT string TLS v1.2 Please note: the "6" is relevant to TLS 1.2 ...other versions of TLS require a different number. See the stackoverflow.com link above for what number correlates to your TLS version. I hope that helps and prevents most of you from wasting as much time as I did in trying to resolve this issue. UPS “Rating and Service” ERROR SOLUTION SUMMARY: 1) Login to the UPS site to make sure your account is active and do this at least once a year. 2) Follow the directions in the upsxml.php file to run a debugging script to write to a log file. 3) Review the log file for errors: If cURL error [60] – uncomment related line (736 or 811) in upsxml.php file If cURL error [35] SSL connect – call your hosting company to find out the version of TLS enabled and then add curl_setopt($ch, CURLOPT_SSLVERSION, 6); to the rest of the curl_setopt options in upsxml.php file. Then change the “6” to the number that correlates with your enabled version of TLS. Demitry
  4. Demitry

    Multi_Vendor_Shipping new thread

    Hi Jim, I looked at doing that re-install of MVS and it is a major undertaking for me because my site has a lot of customization and there are a lot of files to make changes to. However, after a long struggle with this dreaded UPS error (see below), I was able to find a solution. And it is one that is not in the MVS V1.3 though it does involve the /includes/modules/vendors_shipping/upsxml.php file. Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway I'd like to share my resolution to help others with this issue. Please let me know if this thread is the right place for it or if I should do that on the New UPSXML thread, or both. The issue deals with cURL [35] SSL connectivity error and UPS chances with using SSL with their API. The solution is just one line. Let me know. Thanks. Demitry
  5. Demitry

    Multi_Vendor_Shipping new thread

    ok, thanks
  6. Demitry

    Multi_Vendor_Shipping new thread

    ok, thank Jim. I'll look at the code for MVS V1.3 and possibly install that one. To test for compatibility is there anything I need to do other than run a test checkout for domestic, international, and shipping with different weights? Are there any other metrics I should be testing for? Demitry
  7. Demitry

    Multi_Vendor_Shipping new thread

    Hi Jim, I'm getting another UPS error and in the process of trying to figure it out, I realized that I need to upgrade the contribution. So, I have MS2.2 that I upgraded to PHP5.3 and I only use MVS instead of the standard shipping modules that are part of OSC. I looked at the latest MVS V1.3 add-on on OSC contributions and it says that it is for OSC 2.3.4 Could I use this version or should I look for an older one to use with my MS2.2 shop? Thanks. Demitry
  8. Demitry

    New UPS XML Shipping Module available

    @kymation Jim, You're Awesome!!! That was the solution I was looking for! I just installed and tested and there are no UPS errors. The UPS rates are displaying as they should for a delivery to Maryland, USA. Thank you, ...and I had no idea about osCMax infringement of OSC copyright laws. I always thought them and ZenCart were just an evolved extension of OSC. Demitry
  9. Demitry

    Multi_Vendor_Shipping new thread

    Hi Jim, I've got another challenge and hope you could help me solve it. I posted this issue on the New UPS XML Shipping Module available thread since it deals with the UPS module and so far, there has been no viable solution. Because I'm using this MVS contribution, I figured I'd try my luck here. I added the contributions for Country-State Selector and World Zones, which cover pretty much every place in the world. And I started getting a UPS error at checkout with the following message: 111286: ML is not a valid state for the specified shipment. After some troubleshooting I discovered that there are 2 records for Maryland in the database. Apparently there is a Maryland, Liberia as well, and it precedes Maryland, USA in the database and has the "ML" as the abbreviated State/Province. So in /includes/modules/vendors_shipping/upsxml.php what the script is doing, is searching the zones database table for the first instance of "Maryland" and using that record's State/Province 2-letter code for the shipping calculations. When instead, it should be looking for that match based on the zone_country_id. I can probably fix this problem for the Maryland, Liberia issue by changing the name of that province in the database to "Mary-land" but I would rather get a more valid code solution because there may be other duplicate instances and there are over 4K records in that zones table. If anyone has a solution, I would greatly appreciate it. Demitry PS: I later found the following forum thread that deals with this problem but does not provide a code solution and mentions that there are other potential problems like this that exist. http://www.oscmax.com/forums/bugs-and-problems/27232-upsxml-wont-calculate-maryland-detects-abbrev-ml.html
  10. Demitry

    New UPS XML Shipping Module available

    John, I know, I'm from Maryland and the test-checkout I was running was using my old Maryland address. However, the UPS module is searching out the first instance of that state name in the database and this is why (ML) is displayed in the error. This is also why there are no shipping rates because there is no ML as a US state. After I posted this here, I did some more searching and found this for osCMax. Apparently this is a problem and there are more duplicates in that zones table for Florida and other states. http://www.oscmax.com/forums/bugs-and-problems/27232-upsxml-wont-calculate-maryland-detects-abbrev-ml.html Demitry
  11. Demitry

    New UPS XML Shipping Module available

    Hi, I'm hoping someone has a solution for the following issue. I added the contributions for Country-State Selector and World Zones, which cover pretty much every place in the world. And I started getting a UPS error at checkout with the following message: 111286: ML is not a valid state for the specified shipment. After some troubleshooting I discovered that there are 2 records for Maryland in the database. Apparently there is a Maryland, Liberia as well, and it precedes Maryland, USA in the database and has the "ML" as the abbreviated State/Province. So what the script is doing, is searching the zones database table for the first instance of "Maryland" and using that record's State/Province 2-letter code for the shipping calculations. When instead, it should be looking for that match based on the zone_country_id. I can probably fix this problem for the Maryland, Liberia issue by changing the name of that province in the database to "Mary-land" but I would rather get a more valid code solution because there may be other duplicate instances and there are over 4K records in that zones table. If anyone has a solution, I would greatly appreciate it. Demitry
  12. Demitry

    UPS XML Rates & Services v1.2.4 Error

    I just came across this same issue with the UPS module displaying the following error instead of rates: Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway I tried to log into the UPS site but my UPS User ID and Password were not working. And when I tried to retrieve my password by having their system send me a password reset email, my email was not in their system. I contacted UPS tech support and it turns out that if you do not log into your account within 18 months, they delete your email and account. So, if you have a drop shipping scenario set up and you don't ship via UPS but only use their rates API as a courtesy to the customer, then you need to log into your UPS account once a year to avoid losing it. I followed Jan Zonjee's advice from a few posts above and the log file showed me that it was using my UPS ID and Password to log into UPS API. Hence, this is where that error is coming from. If you are getting this error, try logging into the UPS site. If you cannot login and they don't have your email, then this is likely the problem. Demitry
  13. Demitry

    Country-State Selector

    is Steve or anyone else supporting this thread?? There is an issue with the address_book_process.php when editing an existing address or adding a new address. The problem is with error checking the states drop down menu selection on submit. When submitting that form with the states menu displaying "Please Select" the system will not display a state error because its value is the primary address state. Anyone have a solution for this? Thanks in advance. Demitry
  14. Demitry

    Country-State Selector

    ok, I've got a new challenge with saving the user-selected state in a session for error checking. I have the user-selected country saved in their session but cannot figure out how to get the state saved as well. So, when a user enters their information, selects a country and a state from the drop-down menus, then clicks Continue, the error checking brings back the same page (if there are errors) and the states drop-down menu displays "Please Select" ...what I want it to do is display the user's state selection instead. Here is the code I came up with for the country, and it works great. This is for the order_info.php page, but you can use it on create_account.php or any other page that requires the country & state selection. if (isset($_SESSION['order_info']['country']) && $_SESSION['order_info']['country'] != STORE_COUNTRY) { $country = $_SESSION['order_info']['country']; } else { $country = STORE_COUNTRY; } Does anyone have a code solution for retaining the user-selected state on page reload? Any and all help would be greatly appreciated. Thanks. Demitry
  15. Demitry

    Country-State Selector

    @dennish Dennis, I just wanted to thank you for your post on here. I spent hours and hours trying different ways to get the countries to pull up the correct states. It was working in my mobile_create_account page from an earlier install, but I could not figure out why it would not work in any other place on my site. The key was the <div id="indicator"> tag. I did not want another image on my site so I completely overlooked that div tag, and omitting it was causing the problem. Here is the thing though, you don't have to have the actual image, but you do need that div tag for the countries to pull up the correct states. So, I just added the div tag itself and everything works! <div id="indicator"></div> Demitry
  16. Demitry

    Multi_Vendor_Shipping new thread

    ok, thank Jim. I'll check it out. Demitry
  17. Demitry

    Multi_Vendor_Shipping new thread

    Jim, Old code does not mean that it's bad code. MVS contribution is one of the better ones on OSC. It's functional and I think most if not all of the bugs have been worked out. It is the only solution I know of for managing drop shipping vendors. As for upgrading to a newer version of OSC, I am really not looking forward to that nightmare with so many customized scripts. I'm not a developer so I still struggle with div tag structures and am not at all a fan of heavy javascript use, which is a big part of the new OSC platform. Plus, I am not sure if the new version of OSC is mobile responsive or not. The last time I looked, it was not, which means duplicate files for the mobile version - that is what I am doing now with MS2.2. When the time comes to upgrade, I will look at another ecom platform with my long-list of must-haves and evaluate the amount of subbed developer work required to complete that list. Demitry
  18. Demitry

    Multi_Vendor_Shipping new thread

    come to think of it, I don't even really need that conditional "if" statement for the shipping module error.
  19. Demitry

    Multi_Vendor_Shipping new thread

    Jim, That was exactly the issue! The DB query was missing all the vendor info. p.vendors_prod_id, p.vendors_product_price, p.vendors_prod_comments, p.vendors_id And I even know when I overwrote that query. It was recently when I updated the Header Tags SEO to v3.3.3 So, I added those vendor attributes back and tested it and all works great! The Products Vendors dropdown menu is now retaining its set value on page load. I will probably need to go through and check all of the MVS changes ..at least for the /admin/categories.php page. There were a lot of changes to that page for the Header Tags SEO contribution and I'm sure I likely overwrote other MVS changes. I also added another email script in /includes/modules/vendor_shipping.php after the following line: if (isset($quotes[$i]['error'])) { and changed the condition to if ($quotes[$i]['error'] != '') { in order to get notified when one of the shipping modules is displaying an error. This was another recent occurrence with UPS, though unrelated to my original issue. Because there is no way of knowing if a shipping carrier displays an error at checkout, other than doing a test checkout yourself, this email notification is perfect! Thanks again for all your help! You were right on point! Demitry
  20. Demitry

    Multi_Vendor_Shipping new thread

    Jim, you're awesome!!! Thank you so much for your help! You totally rocked on finding the issue. ok, so here is an update on my situation. First of all, I was completely wrong about the shipping modules somehow getting uninstalled. I was looking in the wrong place (Admin>Modules>Shipping) and made an error in my assumption. I added the email script to that /includes/modules/vendor_shipping.php file, but I think the condition was counting the number of items in the cart instead of the number of shipping quotes. So I changed it to: if (count($quotes) == 0) { ..and moved the entire thing down some, under the following line so that I could add $products['products_name'] to the email text to identify any product with this issue of not having shipping rate quotes. It was line 118 in my file. $products = tep_db_fetch_array($products_query); I tested it and it works great! Also, I did as you suggested and went into the product page for one of the products I was having problems with, and the selected vendor was “Certificates,” which of course does not have any shipping vendors. Hence, this was the source of my problem. So I changed it to the correct vendor and saved it. Everything was fine until I went back into that product page for editing again. The Certificates were automatically selected as the Products Vendors default again, because it is the first item in that dropdown menu. Is there a way to keep the set Vendor value in the dropdown menu for that product instead of having to remember to change it every time you save a product page? Demitry
  21. Demitry

    Multi_Vendor_Shipping new thread

    Jim, You're absolutely right!! I was looking in the wrong place, under Admin>Modules. I appreciate the code and I will add it shortly. However, I'm still baffled as to why some items do not display shipping carriers or rates and others do. I'll keep digging and post back. Thanks. Demitry
  22. Demitry

    Multi_Vendor_Shipping new thread

    Jim, Thank you for the reply. I have a pretty secure site with lots of security add-ons & features and I've upgraded to PHP5.3. I'm currently with webhostinghub and I just tried uploading a recent backup of the database but the modules are still showing as uninstalled. The weird thing is that for some items the shipping rates display at checkout even-though those modules in admin show as uninstalled. I'll probably just reinstall them again, because that's the easiest solution. could you tell me where I could insert an email script to notify me if the shipping rates come up as blank at checkout? I can add an email script, I just need to know where to find and test for that condition. Thanks. Demitry
  23. Demitry

    Multi_Vendor_Shipping new thread

    Hi, I have a recurring problem with the shipping modules getting uninstalled. This has happened several times and is difficult to replicate because it occurs out of the blue and rarely. I have a customized MS2.2 site with multi-vendor shipping installed. The payment modules did not get uninstalled and the free shipping module was not uninstalled, but UPS, USPS, and FedEx - all need to be reinstalled. Reinstalling them is not a big deal, but I would like to fix this if this is a bug or some sort of hack. The biggest issue is that I have no way of knowing when this happens unless I do a test checkout and see that there are no shipping methods displaying. I searched this thread but could not find anything, so,... 1) has anyone had this issue and is there a fix? 2) does anyone know where I can add a script to email me as soon as something like this happens? Any and all help is greatly appreciated. Demitry
  24. ok cool, ..actually, I got it fixed!!! No endless redirect loops and no problems with the forward slash only showing up before the product name. Works great!!!! on all products and I tested it in all major browsers. My site now displays: www.mydomain.com/category-name/sub-category-name/manufacturer-name/product-name-c-number.php so now, all my URL’s use the forward slash instead of the hyphen to separate categories, sub-categories, and manufacturers from products and other pages. Love it! Great contribution! Thanks Jack. Demitry
  25. Hey Jack, Thanks for the reply. Yeah, I’ve been trying different things with my limited coding skills and so far it is not working. Having forward slash "/" separators is standard practice and it helps search engines better identify keyword phrases. How much more is there to code? any idea when you would have that completed? There were some people that also mentioned it on the other forum for this contribution. http://forums.oscommerce.com/topic/336702-ultimate-seo-urls-5-by-fwr-media/ Demitry
×