spiritalan

This is regarding the contribution “USPS Rate V4 Intl Rate V2 - v.1.7 - FIX”, uploaded Feb. 12, 2012. Can someone explain to me why the changes in the readme.txt file for /checkout_shipping.php are not the same as in the checkout_shipping.php files found in Files_to_Modify and Drop_On_Top folders for the catalog directory? This is very confusing. I have been working on my new OSC 2.3.3 store in development to take the place of my 2.2RC2a store but after working for about 3 days in trying to make this USPS contribution work I have come to the end of my wits. I have used the Drop_On_Top files, it does not work. I have used the new files and Files_to_Modify by comparing originals and modifying them and it still does not work. I have followed the readme.txt file to the letter and modifying original files and it still does not work. I have taken files from another with the same contribution from a friend, (whose store is working with this USPS contribution) with the update of January 2013 and replaced my files with them and I still receive on checkout a blank page. HELP!!! I removed the existing USPS Module in Admin, then upload proper files, then install new module, then configure the module. The best response that I have gotten is when I manually make the modifications of the originals using the readme.txt file. At least I can configure it in Admin, but on the Front end on checkout I get a blank screen. I know there is more than one question in this post. Please help. I am an OSC veteran user and cut and paster but not a coder. Thanks, Alan

This is a followup to post #2356. Watch for this possible text highlighted (red) difference in your upsxlm.php file to mine and make the correction; it should not change from your original, it affects sort order in the database. Replacement line: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Customer Classification Code', 'MODULE_SHIPPING_UPSXML_RATES_CUSTOMER_CLASSIFICATION_CODE', '01', '00 - Rates Associated with Shipper Number, 01 - Daily Rates, 04 - Retail List Rates (only used when origin is US), 53 - Standard List Rates', '6', '6', 'tep_cfg_select_option(array(\'00\', \'01\', \'04\', \'53\'), ', now())");

Here is my answer to make this contribution work for me. After speaking with about 5 people in different departments with UPS and still waiting for an email answer from a more technical person whom I have not even spoken with, I conclude the UPSXML contribution needs an update. I had said before in post number 2354 that I had negotiated rates, however, UPS people said I did not have that. The quotes that I had been receiving with this contribution before year 2013 were actually the Daily Rate quotes. Customer counter was selected with 01 customer classification code, Negotiated rates was set to True and I provided my account number. But the Daily rate quotes are not negotiated rates but published or book rates. It appears that when my use of UPS shipping decreased over a period of time (bad economy) UPS shifted me to a higher rate, Standard List Rate. They did not inform me about this change in rate quote and it may not be their practice to do so. I downloaded UPS’s Rate Developers APIs and here is what I found from the Rating Package XML Developers Guide December 31, 2012. The Valid Values for the Customer Classification Code are: 00- Rates Associated with Shipper Number; 01- Daily Rates; 04- Retail Rates; 53- Standard List Rates; The following is the change that makes the UPSXML contribution work for me. Backup the affected file. Change the file: catalog/includes/modules/shipping/upsxml.php Around line 384 Replace line: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Customer Classification Code', 'MODULE_SHIPPING_UPSXML_RATES_CUSTOMER_CLASSIFICATION_CODE', '01', '01 - If you are billing to a UPS account and have a daily UPS pickup, 03 - If you do not have a UPS account or you are billing to a UPS account but do not have a daily pickup, 04 - If you are shipping from a retail outlet (only used when origin is US)', '6', '6', 'tep_cfg_select_option(array(\'01\', \'03\', \'04\'), ', now())"); With this: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Customer Classification Code', 'MODULE_SHIPPING_UPSXML_RATES_CUSTOMER_CLASSIFICATION_CODE', '01', '00 - Rates Associated with Shipper Number, 01 - Daily Rates, 04 - Retail List Rates (only used when origin is US), 53 - Standard List Rates', '6', '6', 'tep_cfg_select_option(array(\'00\', \'01\', \'04\', \'53\'), ', now())"); Before you do the next item, you might want to print out your existing UPS settings. In Admin, Modules, Shipping, United Parcel Service: REMOVE the existing UPS module. In Admin, Modules, Shipping, United Parcel Service: INSTALL the UPS module. You may now want to backup your new upsxml.php file. Find out your UPS account rate. You can do this in two ways. (1) Do a Calculate time and cost mock shipment and at the top of the results it should say Retail or Standard or Daily or maybe even Negotiated rate. If you do not enter your account number in the calculation the default will be Retail. (2) Call you UPS account representative. If you don’t have one, get one. I use Customer counter, so if you select something else you may get different results with different customer classification codes selected than what I got. If you use Customer Classification Code 00, be sure to set Negotiated Rates to True and enter your account number. If you select any Customer Classification Code other than 00, you do not need to set Negotiated Rates to True and enter your account number to get the appropriate rate. I don't know if it would work if you did. In my testing I kept Negotiated Rates to False and and did not enter an account number when I selected a Customer Classification Code other than 00. What seems to be nice about code 00, the next time UPS makes a change to my rates, hopefully OSCommerce store and UPS online should sync like it is suppose to without making any further changes. Final notes: I am not a programmer, so if I have missed something here, don’t be shy, let me know and others what needs to be done. Also, I am not a maintainer of this contribution but hopefully I have been able to help. Alan :thumbsup:

I have called UPS to see if the problem is on their side. Now waiting for an answer.

I should state that I use Negotiated Rates and they have worked in the past just fine until recently. In post #2353 of this topic I gave my problem using negotiated rates. I use Customer Classification Code 01 and Pickup Method, Customer Counter and it use to work fine even though I do not have customer pickup. Now, with further testing, here is what I come up with. This following is with Customer Classification Code set to 01 with Pickup Method, Customer Counter. I check negotiated rates to False, and I get the appearance of negotiated rates same as above in #2353 but not the exact UPS negotiated rates. But I should not be getting negotiated rates when set to false. When I check Customer Classification Code set to 03 with Pickup Method, Customer Counter and negotiated rates set to False, I get retail rates correctly across all ship services. When I check Customer Classification Code set to 03 with Pickup Method, Customer Counter and negotiated rates set to True and enter account number, I only receive retail rates and no negotiated rates. My conclusion is that the Negotiated Rates stopped working. Does anyone else have this problem? Please, I need help. I am using UPSXML version 1.3.3

UPSXML has been working for me just fine for years until now. I have made no changes to my store nor to the contribution. I believe the UPSXML module is not working correctly or UPS is not providing the correct quotes when requested by OSC. I am getting incorrect quotes on 2nd Day Air, Next Day Air Saver, Next Day Air and Next Day Air Early AM. I do not use 2nd Day Air Early AM so I do not know how it is performing with quotes. Ground and 3 Day Select seem to be ok. The difference in the amount of the misquoted items varies among methods of ship. For example for 2nd Day Air I am shorted about $0.78. The amount shorted increases a little more with Next Day Air and Saver, however, the amount is quoted higher than it should be with Next Day Air Early AM. Versions of what I have are below.

I'm using version 5.2.2 and I do not know about the 6.0 version. I know someone who was using a version a little earlier than 5.2.2 and upgraded to 6.1, but he quickly changed over to 5.2.2 and with some changes as per my posts regarding the USPS Jan 22nd changes, it now works for him. Post #25 in this thread leads you to some of those changes. Whichever, the USPS Methods contribution does need some cleanup work by an expert programmer. It appears someone has updated the 6.1 version in the contributions section of USPS Methods.

What version of USPS Methods contribution are you using?

This thread is for USPS Methods contribution but not the original. The following URL will take you to the original or contribution thread: http://www.oscommerce.com/forums/topic/146950-contribution-usps-methods/ I assume your problem began 1/22/2012. Start reading from Post #11 of this thread. You may find your problem and answer. I assume your problem began 1/22/2012. The day USPS made changes. Your problem sounds similar to mine. Start reading from Post #11 of this thread. You may find your problem and answer.

In my last post #1195 I said: However, after more testing there is a noticible difference. If you do not change "Package" to "Parcel" in these places listed above, your handling fee will not be added in for First Class Mail.

A quick fix for me, can be found here in the USPS Methods thread: http://www.oscommerce.com/forums/topic/146950-contribution-usps-methods/page__view__findpost__p__1619768

A quick fix for me, but this contribution still needs a cleanup. I’m using USPS Methods version 5.2.2. My problem has been narrowed down to the option in the USPS module in Admin “Domestic Delivery Confirmation”. With this option enabled it causes errors in quotes for both Domestic First Class and Priority mail. A temporary work around would be to disable the option and add $0.19 to the First Class Mail handling fee. Domestic Quotes are now correct. I did change 'First-Class Mail regimark Package' in includes/modules/shipping/usps.php to 'First-Class Mail regimark Parcel'. This is located in two places in this file. However, with “Domestic Delivery Confirmation” disabled it did not make any noticable difference. I have not yet checked on International mail options, just domestic. Thanks to videod for his invaluable private help.

Since the USPS change today, shipping quotes are showing up but they are incorrect. With the handling fee and tare weight taken into account, the quotes do not match the quotes from USPS website. I'm using USPS Methods v. 5.2.2

For me, shipping quotes are showing up but they are incorrect. With the handling fee taken into account, the quotes do not match the quotes from USPS website.

A solution to Signature Confirmation problem. I had installed USPS Methods 5.2.1 back in March and it worked, and then a couple weeks ago USPS had some price changes. Signature Confirmation was one of those price changes. As a result, Domestic Signature Confirmation no longer worked when over the threshold amount. The customer was no longer charged for Signature Confirmation. I installed USPS Methods 5.2.2 and this did not fix the problem. I opened file /includes/modules/shipping/usps.php and made two edits, which fixed the problem. They are as follows: (1) This mod affects the rate quote. Find: <\/AvailableOnline><Price>2.35 Change to: <\/AvailableOnline><Price>2.45 (2) This next mod affects text information in shipping module in the Admin regarding the online price for Signature Confirmation. Find: 'Automatically charge Signature Confirmation when available ($1.95)?', Change to: 'Automatically charge Signature Confirmation when available ($2.05)?', These are the only changes I made to the file. To display the correct online price for Signature Confirmation in Admin in edit mode of the shipping module, you have to edit the record, Domestic Signature Confirmation, in the table Configuration in MySql database. I am not a programmer, but it would be nice if these types of changes were not necessary each time USPS changes prices. :)

I've been able to make it work for me. For me, the problem was the addition of the USPS Registration Tradmark by the coders. The problem focused with the new code in catalog/admin/includes/functions/general.php. Some code I had to install and some I left out. You may want try this out. BE SURE TO BACKUP. When following the installation instructions in USPS Methods Ver. 5.2.1 provided by fulluvscents, when you come to Step 9. at the correct place to insert as shown, Insert the following (you may already have this code there if you have an earlier version of USPS Methods): // USPS Methods 3.0 // Alias function for Store configuration values in the Administration Tool function tep_cfg_select_multioption($select_array, $key_value, $key = '') { for ($i=0; $i<sizeof($select_array); $i++) { $name = (($key) ? 'configuration[' . $key . '][]' : 'configuration_value'); $string .= '<br><input type="checkbox" name="' . $name . '" value="' . $select_array[$i] . '"'; $key_values = explode( ", ", $key_value); if ( in_array($select_array[$i], $key_values) ) $string .= ' CHECKED'; $string .= '> ' . $select_array[$i]; } $string .= '<input type="hidden" name="' . $name . '" value="--none--">'; return $string; } Next, The following code may be used in lieu of step 10. (again, you may already have this code inserted). You insert the following code after the code given above in this post. // USPS Methods. Added by Greg Deeth // Alias function for Store configuration values in the Administration Tool. function tep_cfg_multiinput_list($select_array, $key_value, $key = '') { $key_values = explode( ", ", $key_value); for ($i=0; $i<sizeof($select_array); $i++) { $name = (($key) ? 'configuration[' . $key . '][]' : 'configuration_value'); $string .= '<br><input type="text" name="' . $name . '" value="' . $key_values[$i] . '"> ' . $select_array[$i]; } $string .= '<input type="hidden" name="' . $name . '" value="--none--">'; return $string; } // USPS Methods. Added by Greg Deeth // Alias function for Store configuration values in the Administration Tool. function tep_cfg_multiinput_duallist_oz($select_array, $key_value, $key = '') { $key_values = explode( ", ", $key_value); $string .= '<center>'; for ($i=0; $i<sizeof($select_array); $i++) { $current_key_value = current($key_values); $name = (($key) ? 'configuration[' . $key . '][]' : 'configuration_value'); $string .= '<br><input type="text" name="' . $name . '" size="3" value="' . $current_key_value . '"><i>oz</i>'; $string .= ' <b><</b> ' . $select_array[$i] . ' <u><b><</b></u>'; next($key_values); $current_key_value = current($key_values); $string .= '<input type="text" name="' . $name . '" size="3" value="' . $current_key_value . '"><i>oz</i>'; next($key_values); } $string .= '<input type="hidden" name="' . $name . '" value="--none--">'; $string .= '</center>'; return $string; } function tep_cfg_multiinput_duallist_lb($select_array, $key_value, $key = '') { $key_values = explode( ", ", $key_value); $string .= '<center>'; for ($i=0; $i<sizeof($select_array); $i++) { $current_key_value = current($key_values); $name = (($key) ? 'configuration[' . $key . '][]' : 'configuration_value'); $string .= '<br><input type="text" name="' . $name . '" size="3" value="' . $current_key_value . '"><i>lbs</i>'; $string .= ' <b><</b> ' . $select_array[$i] . ' <u><b><</b></u>'; next($key_values); $current_key_value = current($key_values); $string .= '<input type="text" name="' . $name . '" size="3" value="' . $current_key_value . '"><i>lbs</i>'; next($key_values); } $string .= '<input type="hidden" name="' . $name . '" value="--none--">'; $string .= '</center>'; return $string; } Follow the rest of the instructions starting from step 11.. Again, some of this code may be already inserted depending if you used an earlier version of USPS Methods. After you install the information I gave you, you will not be able to see USPS registration trademarks in the Admin section but you should be able to see them on checkout in the store. In the Admin, USPS configuration section, you will have "regimark" where a registration trademark would go. Also, for some extra info that might not be applicable, I did not do step 5.a., 5.b, or 8. Hope this works for you. I am not a coder, just a cut and paster. Alan

It appears I may have the same problem as you. I was going to write yesterday something about it, but I wanted to double check things. I reinstalled USPS Methods 5.2.1 again and still I could not Edit the configuation for this module. When I clicked Edit the displayed USPS configuration details disappeared. I am using OSC 2.2RC2a PHP Version 5.1.6 My previous version of USPS Methods was V. 3.0 with no problems until now it will not communicate with USPS on International quotes. To get noticed, maybe, a better place to post our problems would be here: http://www.oscommerce.com/forums/topic/146950-contribution-usps-methods/ Let me know what you think. Alan

I'm thinking about upgrading to direct payments. Is anyone successfully using this module: PayPal Express Checkout and Website Payments Pro (Official Payment Module) with register_globals OFF? PayPal istallation instructions say to turn ON register_globals at a minimum. This seems to be a step in the wrong direction since I have been using Version osc2.2 RC2a for about 2 years with register_globals OFF with Website PayPayments standard.

I do not have a download mod. Alan

I do not yet have any other payment mods installed. But I have: Header Tags SEO V 3.0.1 Automatic Thumbnail Creator SPPC V. 4.2.1a USPSMethods V3.0 UPSXML_v1_3_3 All Products Google XML Sitemap - Admin 2.0 Monthly Sales and Tax Teport V2.3.1. In-Stock Quantity Display Date+number to invoice and packing slip Alan

If you mean Alex's 2nd attempt testing code; it works better for me. Be sure to backup. Best wishes for you. Alan

First, I have never used the sandbox for testing. My testing is always live. Next, I have never had the problem that after I paid at PayPal it takes me back to the checkout page. After successful payment the buyer is returned to the checkout_success page if they don't close out the browser first. I don't know what could be causing a problem such as the one you have. You can see at the bottom, my system I am using. I do not have encrypted web payments enabled, I use SSL already on board. I have tried this contribution with both register_globals on and off and have had the same results. However, I have been told that with some of these fixes it was tested with register_globals on. Better for security purposes, IF YOU CAN, keep them off. A big thanks goes out to Alex and others for a great contribution. Alan

I am live testing the 2nd attempt code. I tested the new code with register_globals on and off. The results appears to be the same regardless of register globals condition. I did not see any difference. The results thus far: Now, if after reaching the confirmation page the buyer makes any changes of products, quantities, shipping service or payment method, this will simply create a new order with new order number. Changes are not updated with original order number. Whether this is the way it is suppose to work, it makes no difference to me. The changes are recorded in the database before the buyer pays at PayPal. Also, with a new order created after a change in items, there are no Preparing [PayPal IPN] orders to delete. The invoice number is passed to PayPal and the return IPN operates like it’s suppose to, whether the buyer returns to website or not. It's looking great Alex. I'll try and go awhile before I do any more reporting. Thanks again. Alan

Paul you need to read my earlier posts on this problem. Your situation seems a little different than mine. If at any time after the customer goes to the confirmation page and changes quantities or product items, then when they get to the confirmation page again, OSC creates a whole new order, whether the customer changes shipping or not. When they pay after this situation, I have no problems when the IPN returns, because it is a whole new order. I just delete their previous Preparing [PayPal IPN] order(s). But when only shipping is changed after reaching the confirmation page, the order is not updated and also there is not another order created, therefore the IPN is different than what osc database expected. It would appear that you situation may be worse than mine. The confirmation email sent out by OSC when the IPN is returned, is the previous information and not the updated info. So in my situation, if at first the customer chose USPS First Class Mail, then changed his mind to USPS Express, he will have paid for Express, but the confirmation email informs him he paid for First Class. I have to inform my customers to disregard the confirmatin email from OSC. Now apply this to your situation. You might want to check to see if you customer who first opts for a $5 item then changes to $100 item is getting the proper email info. Alan

Paul, Yea, I'm glad it's working in that issue also. However, do you have more than one shipping option, service? If so, what happens when after you select one service, go to the confirmation page and then change your mind, click another shipping service, then go to confirmation page, and then check out at PayPal? I find that the order is not updated, and the IPN comes back with different values since a different shipping service was selected. When this happens I have to go into the database and make the corrections. To test this you must not change the items or quantity of items in the basket, only the shipping service is changed. Alan