Jan Zonjee Posted April 2, 2007 Share Posted April 2, 2007 Correct me if I'm wrong. In reading the instructions for the dimensional support feature, I understood that the Ready To Ship option would be used to calculate any product that was designated as ready to ship in the admin section. All other products in the same order would then be grouped together and calculated using the standard UPS weight basis. Am I reading or understanding something wrong? Partially you are right, for the items that are not ready-to-ship you don't need to enter dimensions. However, for those ready-to-ship items the dimensions are needed. So in fact you need to install the dimensions support code to make it work, but you don't need to enter dimensions for all your products. The function more_dimensions_to_productsArray (close to the bottom of shipping/upsxml) was supposed to catch the weight being zero, by giving dimensions based on an assumed density for products, using the weight of the product. Apparently that didn't work as intended... :'( Quote Link to comment Share on other sites More sharing options...
awarner20 Posted April 2, 2007 Share Posted April 2, 2007 (edited) You can bump this as much as you want but since this problem seems to be pretty unique (I never read about this, nor seen it ever) you are the only one in a position to research it. So what have you done to research it? Did you try several destinations, did you try to enable more shipping methods and if so what happened, did you look at the HTML of that page: are these strange letters in the UPS quote or is it from somewhere else, did you setup and enable logging to see what UPS returns? Hi Jan, Yes, I have tried all shipping methods, same result. I have tried enabling other shipping methods by themselves, same result. I am looking into the other things you suggested and will post back with further troubleshooting results. I'm not sure how to enable logging, I will check with the contributions instructions to see if that tells me how... Edited April 2, 2007 by awarner20 Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
Guest Posted April 3, 2007 Share Posted April 3, 2007 Partially you are right, for the items that are not ready-to-ship you don't need to enter dimensions. However, for those ready-to-ship items the dimensions are needed. So in fact you need to install the dimensions support code to make it work, but you don't need to enter dimensions for all your products. Thanks for eh reply JanZ. All of my products do have a default package size entered into the fields as 12x12x12. I have taken a look at the function you specified earlier and it seems to want to find a package size of 0x0x0. Once it finds that, it will calculate a package density of 0.7. Should I set them all to 0? I guess I could try it. (Just did, but didn't seem to change anything. Still got 0 weight) Now, does the size of the box that the "ready to ship" item goes in need to be set up in the Packaging section for the function to work properly? Just enetered that, and it didn't seem to do much either.... I also have another problem where we have several products that need to be shipped in 2 separate boxes by themselves. I have yet to figure out a way to make this happen and get accurate shipping. I thought that the ready to ship function might work, but as I dig into it a little more, it doesn't seem to. I have also installed an "Individual Shipping" method, but when that is activated, the UPSXML method ceases to work at all. Does anyone have any idea how I might pull this off? Quote Link to comment Share on other sites More sharing options...
awarner20 Posted April 3, 2007 Share Posted April 3, 2007 (edited) Hi Jan, Yes, I have tried all shipping methods, same result. I have tried enabling other shipping methods by themselves, same result. I am looking into the other things you suggested and will post back with further troubleshooting results. I'm not sure how to enable logging, I will check with the contributions instructions to see if that tells me how... After further testing and research, I have not yet been able to figure out what in the world is going on. Here's what I have tried... I enabled logging per the instructions in includes/modules/shipping/upsxml.php so my code looks like this... // end insurance addition // to enable logging, create an empty "upsxml.log" file at the location you set below, give it write permissions (777) and uncomment the next line $this->logfile = '/tmp/upsxml.log'; // to enable logging of just the errors, do as above but call the file upsxml_error.log $this->ups_error_file = '/srv/www/htdocs/catalog/includes/modules/shipping/upsxml_error.log'; // when cURL is not compiled into PHP (Windows users, some Linux users) // you can set the next variable to "1" and then exec(curl -d $xmlRequest, $xmlResponse) // will be used $this->use_exec = '0'; I created the upsxml.log file with 777 permissions and placed in /tmp/ directory on the root of my server. My catalog is in root. I created the upsxml_error.log and left the code as it is. I then went to my store and placed things in the cart, changed locations, received different UPS quotes, and still experienced the same error my original post was about. Also, neither of these log files are being written to. I had one of our programmers here at work take a look too, and everything looked good according to him. So, now I can't log these either??? As a refresher, here's an image of what the screen looks like with all the weird letters. Also, please know that no matter what shipping method, number of products, number of products in cart, etc., the same series of letters are displayed. When I loded that page, I viewed the page source in Firefox and I can see that the HTML for these letters are being written, but I don't know what to look for to tell what is triggering this...here's the beginning of the rouge HTML containing these letters on the checkout_shipping page... </table></td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr> <td><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" colspan="3"><b>F</b> F</td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" colspan="3">F</td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> </table> Just for some more info on my setup, I am using GoDaddy (linux) and have added the additional cURL code needed for GoDaddy servers. I am also using the correct GoDaddy cURL address... curl_setopt ($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE); curl_setopt ($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP); curl_setopt ($ch, CURLOPT_PROXY, "http://proxy.shr.secureserver.net:3128"); curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE); I am using the same UPSXML Rates on another store on another GoDaddy (linux) server without this problem. I realize that this may not be a UPSXML Rates specific problem, but since this started happening only after I installed this contrib, I'm keeping the post here for now. Can someone please suggest what other troubleshooting steps I might take to find out where and what code is triggering the writing of these tables containing this series of letters??? Thanks you in advance for any assistance you can offer. Edited April 3, 2007 by awarner20 Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 3, 2007 Share Posted April 3, 2007 I enabled logging per the instructions in includes/modules/shipping/upsxml.php so my code looks like this...I created the upsxml.log file with 777 permissions and placed in /tmp/ directory on the root of my server. My catalog is in root. I created the upsxml_error.log and left the code as it is. I then went to my store and placed things in the cart, changed locations, received different UPS quotes, and still experienced the same error my original post was about. Also, neither of these log files are being written to. I had one of our programmers here at work take a look too, and everything looked good according to him. So, now I can't log these either??? Never had much luck with that. Always had to use a full path like the one I described for the error log... As a refresher, here's an image of what the screen looks like with all the weird letters. It looks as if they are shown as additional shipping methods (as if you have for example UPS, USPS and FedEx etc.). Weird, very weird. Quote Link to comment Share on other sites More sharing options...
awarner20 Posted April 3, 2007 Share Posted April 3, 2007 Never had much luck with that. Always had to use a full path like the one I described for the error log... It looks as if they are shown as additional shipping methods (as if you have for example UPS, USPS and FedEx etc.). Weird, very weird. Ok, I changed to my full server path and have successfully created a upsxml.log file. Can you please explain what i should be looking for in this file? Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
awarner20 Posted April 3, 2007 Share Posted April 3, 2007 Ok, I changed to my full server path and have successfully created a upsxml.log file. Can you please explain what i should be looking for in this file? Well, I've looked through the log file and have done text search for for these weird characters and haven't found anything that looks suspicious. I was concentrating especiall on the UPS RESPONSE at the end of the file and everything seems to be like it should. At least that's my best guess. Man, I'm really stuck now, I have no idea of where to look next. I guess I'll turn off the UPS Rates and turn it back on to see if that changes anything. After that, I'll have to uninstall this contrib and reinstall to see if I get the same results. If anyone here has any other ideas, please feel free to put them forth. I won't be uninstalling for another day probably. Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 3, 2007 Share Posted April 3, 2007 Well, I've looked through the log file and have done text search for for these weird characters and haven't found anything that looks suspicious. I was concentrating especiall on the UPS RESPONSE at the end of the file and everything seems to be like it should. At least that's my best guess. I agree with you there. Looking at the HTML (all methods of a shipping module stay in one table) it seems these are all loaded as additional shipping modules. For example: <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" colspan="3"><b>United Parcel Service (XML) (1 pkg x 17 lbs total)</b> <img src="images/icons/shipping_ups.gif" border="0" alt="United Parcel Service (XML)" title=" United Parcel Service (XML) "></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr id="defaultSelected" class="moduleRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, 0)"> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" width="75%">UPS Ground, <acronym title='Estimated Delivery Date'>EDD</acronym>: April 05, 2007</td> <td class="main">$7.93</td> <td class="main" align="right"><input type="radio" name="shipping" value="upsxml_UPS Ground" CHECKED></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, 1)"> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" width="75%">UPS 3 Day Select</td> <td class="main">$14.74</td> <td class="main" align="right"><input type="radio" name="shipping" value="upsxml_UPS 3 Day Select"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, 2)"> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" width="75%">UPS 2nd Day Air A.M.</td> <td class="main">$22.77</td> <td class="main" align="right"><input type="radio" name="shipping" value="upsxml_UPS 2nd Day Air A.M."></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, 3)"> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" width="75%">UPS 2nd Day Air</td> <td class="main">$19.25</td> <td class="main" align="right"><input type="radio" name="shipping" value="upsxml_UPS 2nd Day Air"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, 4)"> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" width="75%">UPS Next Day Air Saver, <acronym title='Estimated Delivery Date'>EDD</acronym>: April 05, 2007</td> <td class="main">$31.13</td> <td class="main" align="right"><input type="radio" name="shipping" value="upsxml_UPS Next Day Air Saver"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, 5)"> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> <td class="main" width="75%">UPS Next Day Air, <acronym title='Estimated Delivery Date'>EDD</acronym>: April 05, 2007</td> <td class="main">$35.64</td> <td class="main" align="right"><input type="radio" name="shipping" value="upsxml_UPS Next Day Air"></td> <td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> </table></td> <td><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> </tr> The first three (FTP) seem to coincide with Flat rate, Per item, Table Rate, part of the standard available shipping modules in osC. Then it continues with United Parcel Service, which doesn't seem to show up. Might be something in your class shipping. Check also the define MODULE_SHIPPING_INSTALLED in the table configuration. Different modules are separated by semi-colons. Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 3, 2007 Share Posted April 3, 2007 All of my products do have a default package size entered into the fields as 12x12x12. I have taken a look at the function you specified earlier and it seems to want to find a package size of 0x0x0. Once it finds that, it will calculate a package density of 0.7. Should I set them all to 0? I guess I could try it. (Just did, but didn't seem to change anything. Still got 0 weight) If that function finds a dimension missing it will do the guessing of the dimensions based on density. For items that are not ready-to-ship the function doesn't make a difference, it is not used in the calculations.Now, does the size of the box that the "ready to ship" item goes in need to be set up in the Packaging section for the function to work properly? No, you enter that in the product (categories.php). I double checked this feature again now, but it works fine for me. I have no clue why you get 0 weight (unless you have a very low weight items, UPS get sent a minimum weight of 1 lbs; see function _addItem, weight = 1 but should not need to show up on checkout_shipping where a simple round is done). I also have another problem where we have several products that need to be shipped in 2 separate boxes by themselves. I have yet to figure out a way to make this happen and get accurate shipping. I thought that the ready to ship function might work, but as I dig into it a little more, it doesn't seem to. I have also installed an "Individual Shipping" method, but when that is activated, the UPSXML method ceases to work at all. Does anyone have any idea how I might pull this off? When you look at the function quote you will notice that $productsArray = $cart->get_products(); After that you can add code to look for specific items and split them in two or more items. Quote Link to comment Share on other sites More sharing options...
awarner20 Posted April 4, 2007 Share Posted April 4, 2007 The first three (FTP) seem to coincide with Flat rate, Per item, Table Rate, part of the standard available shipping modules in osC. Then it continues with United Parcel Service, which doesn't seem to show up. Might be something in your class shipping. Check also the define MODULE_SHIPPING_INSTALLED in the table configuration. Different modules are separated by semi-colons. Oooh, I think you're onto something, and I really appreciate your help with this. However, could you please specify what you mean by "class shipping" and "define MODULE_SHIPPING_INSTALLED in the table configuration"??? Are these in the UPS Rates files or my regular store files? Thanks again for your help. Once I get this solved, it'll be one for the books;) Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 4, 2007 Share Posted April 4, 2007 could you please specify what you mean by "class shipping" and "define MODULE_SHIPPING_INSTALLED in the table configuration"??? Are these in the UPS Rates files or my regular store files? With class shipping I mean the file catalog/includes/classes/shipping.php and define MODULE_SHIPPING_INSTALLED is in your database, table configuration (semi-colon seperated list of installed shipping modules). You need to use phpMyAdmin to check it. Quote Link to comment Share on other sites More sharing options...
awarner20 Posted April 4, 2007 Share Posted April 4, 2007 With class shipping I mean the file catalog/includes/classes/shipping.php and define MODULE_SHIPPING_INSTALLED is in your database, table configuration (semi-colon seperated list of installed shipping modules). You need to use phpMyAdmin to check it. Hi Jan, Thanks for the clarification. In the Configuration Table, these are the what were the table. 1 Next Day Air, 2nd Day Air, Worldwide Express, Worldwide Express Plus, Worldwide Expedited, Express, Standard, 3 Day Select, Next Day Air Saver, Next Day Air Early A.M., Expedited, 2nd Day Air A.M., Saver, Express Early A.M., Express Plus I have checked my catalog/includes/classes/shipping.php file, I don't know what I'm looking for. I didn't want to post the whole thing here. May I post it here for you to take a look at? Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
steveosc Posted April 5, 2007 Share Posted April 5, 2007 Wondering how to deal with this error: UPSXML Rates Error: 111286: AE is not a valid state abbreviation for United States. experienced by customer with id 61 on 2007-03-02 09:46:16 Apparently UPS doesn't ship to Armed Forces Europe, or do you think it's just a limitation of UPSXML? Thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted April 5, 2007 Share Posted April 5, 2007 PLEASE HELP!!! My Storefront semms to be getting this error when I install this module... ************************************** UPSXML Rates Error: 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 experienced by customer with id 2 on 2007-04-05 13:01:29 ***************************************************************************** and ***************************************************************************** Error from cURL: Error [7]: experienced by customer with id 2 on 2007-04-05 13:01:29 ***************************************************************************** I am hosted on godaddy.com and my url is www.technastarcomp.com is this normal or am I screwing up big time? Thanks in advance... Lynk Quote Link to comment Share on other sites More sharing options...
awarner20 Posted April 5, 2007 Share Posted April 5, 2007 (edited) PLEASE HELP!!! My Storefront semms to be getting this error when I install this module... ************************************** UPSXML Rates Error: 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 experienced by customer with id 2 on 2007-04-05 13:01:29 ***************************************************************************** and ***************************************************************************** Error from cURL: Error [7]: experienced by customer with id 2 on 2007-04-05 13:01:29 ***************************************************************************** I am hosted on godaddy.com and my url is www.technastarcomp.com is this normal or am I screwing up big time? Thanks in advance... Lynk GoDaddy requires some additional cURL code. Do this... Go to catalog/includes/modules/shipping/upsxml.php. Look on the page about 3/4 of the way toward the end for this chunk of code... } else { // default behavior: cURL is assumed to be compiled in PHP $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); // uncomment the next line if you get curl error 60: error setting certificate verify locations //curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); // uncommenting the next line is most likely not necessary in case of error 60 // curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $xmlRequest); curl_setopt($ch, CURLOPT_TIMEOUT, (int)$timeout);....etc..etc... Then add this code after the above.... //ADDED THIS CURL BECAUSE OF GODADDY ERROR curl_setopt ($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE); curl_setopt ($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP); curl_setopt ($ch, CURLOPT_PROXY, "http://proxy.shr.secureserver.net:3128"); curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE); That solved it for me. Edited April 5, 2007 by awarner20 Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
Guest Posted April 5, 2007 Share Posted April 5, 2007 Awarner20, THAT DID IT !!!! Thanks a ton!!! Lynk Quote Link to comment Share on other sites More sharing options...
awarner20 Posted April 5, 2007 Share Posted April 5, 2007 Awarner20, THAT DID IT !!!! Thanks a ton!!! Lynk Your're welcome;) Now, if I could only solve my problem in the above posts, the world will make sense again;) Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
awarner20 Posted April 5, 2007 Share Posted April 5, 2007 Awarner20, THAT DID IT !!!! Thanks a ton!!! Lynk Your're welcome;) Now, if I could only solve my problem in the above posts, the world will make sense again;) Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
Annie Dragon Posted April 7, 2007 Share Posted April 7, 2007 Well, I just copied a product from one category to another to test it and it works on mine moving all the data. I looks like you don't have all the data on the product you are trying to copy, but I just get by with manipulating code. Here is the query insert from my admin/categories.php. case 'copy_to_confirm': if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['categories_id'])) { $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']); if ($HTTP_POST_VARS['copy_as'] == 'link') { if ($categories_id != $current_category_id) { $check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$categories_id . "'"); $check = tep_db_fetch_array($check_query); if ($check['total'] < '1') { tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$categories_id . "')"); } } else { $messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error'); } } elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') { // LINE MODED: Added "products_ship_price" $product_query = tep_db_query("select products_ship_price, products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); // LINE CHANGED: MS2 update 501112 - Added :(empty($product['products_date_available']) ? "null" : ...{some code}... ") . " // LINE MODED: Added "products_ship_price" tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, products_ship_price, products_image, products_price, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . $product['products_ship_price'] . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ". '" . tep_db_input($product['products_weight']) . "', '0', '" . $product['products_length'] . "', '" . $product['products_width'] . "', '" . $product['products_height']. "', '" . $product['products_ready_to_ship'] . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = tep_db_insert_id(); Hope this helps Quote It's not a learning curve, it's a cliff! Link to comment Share on other sites More sharing options...
Annie Dragon Posted April 7, 2007 Share Posted April 7, 2007 John - Very belated, but much appreciated THANK YOU! I found my error by comparing our codes. In case anyone else has made my small, but frustrating mistake, here's the exact code that I ended up using. // begin ups xml mod // added following to tep_db_query: "products_length, products_width, products_height, products_ready_to_ship," // added following to tep_db_input: " $product['products_length'] . "', '" . $product['products_width'] . "', '" . $product['products_height']. "', '" . $product['products_ready_to_ship'] . "', '" . tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . $product['products_length'] . "', '" . $product['products_width'] . "', '" . $product['products_height']. "', '" . $product['products_ready_to_ship'] . "', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); Muchimas Gracias! Annie o:) Quote It's not a learning curve, it's a cliff! Link to comment Share on other sites More sharing options...
scheda Posted April 13, 2007 Share Posted April 13, 2007 I have completed the installation up to step 7 correctly, triple checked to make sure I did it right. However, when I go to install it in the modules section of the admin, it doesn't show up. Maybe the most recent download is missing a file, or maybe my eyes are tricking me. I don't know. Either way, it won't show up in the modules section. I'm pretty sure that I need to have a file in /includes/modules/shipping but I don't have a file to place there. Any ideas as to what I should do to resolve this? Thanks. Quote Link to comment Share on other sites More sharing options...
Code Red Posted April 18, 2007 Share Posted April 18, 2007 Is anyone else in the UK using this contribution? I've installed the module and it all seems to run correctly with no errors, but the prices I'm getting don't seem right. The client is based in London and has special rates with UPS. I've registered on the UPS site and got the UPS rates access key etc. Initially it wasn't picking up the address information correctly, but I installed Hobbzilla's World Zones contribution and as long as the postcode is entered correctly it produces a shipping cost, but comparing it to the rates spreadsheet I have from UPS they look pretty weird to me - 30kg package London to UK (Zone 1) - £12.40 should be £11.74 30kg package London to USA (Zone 3) - £9.40 should be £30.26 30kg package London to Germany (Zone 2) - £12.40 should be £21.98 30kg package London to Norway (Zone 2) - £12.40 should be £21.98 30kg package London to Japan (Zone 3) - £9.40 should be £30.26 The immediate thing that strikes me is that sending a package to the US or Japan should be more than sending it within the UK or to the EU, so have I not set the module up correctly? These are the settings I've entered - Enable UPS Shipping True UPS Rates Access Key **************** UPS Rates Username ******** UPS Rates Password ******** Pickup Method Daily Pickup Packaging Type Package Customer Classification Code 01 Shipping Origin European Union Origin Origin City London Origin State/Province ((Don't know what the two letter code is so I've left this blank - does this just apply to the US?)) Origin Country GB Origin Zip/Postal Code N1 9UU Test or Production Mode Production Unit Weight KGS Unit Length CM Dimensions Support No Quote Type Residential Negotiated rates True UPS Account Number ****** Handling Type Flat Fee Handling Fee 1.40 ((This is for residential address deliveries, I think this may be already added at source)) Enable Insurance True UPS Currency Code GBP Tax Class Taxable Goods 1 Shipping Zone --none-- Sort order of display. 1 Disallowed Shipping Methods ((Everything except UPS Standard)) Shipping Delay 1 Email UPS errors Yes Time in Transit View Type Detailed I'd appreciate some feedback from any other UK users of this module - it looks great, but at the moment I can't use it. Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 18, 2007 Share Posted April 18, 2007 it produces a shipping cost, but comparing it to the rates spreadsheet I have from UPS they look pretty weird to me - I'd appreciate some feedback from any other UK users of this module - it looks great, but at the moment I can't use it. I'm not from the UK, but from the looks of things I would say that the UPS server is not returning you negotiated rates. For some interesting reason the code returns the number of the shipping option in that case. Fore example UPS Standard: number 11 plus 1.40 makes £ 12.40, the 9.40 doesn't seem to fit but perhaps there is a £ 1 insurance fee since there is no number 8, there is a number 7: UPS Express). Try it without negotiated rates on and see if that works better. Only UPS can tell you why their server doesn't return the special rates. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 20, 2007 Share Posted April 20, 2007 After I made all of the changes I get the following error when I try to install the module. 1366 - Incorrect integer value: '' for column 'configuration_id' at row 1 insert into configuration ( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('', 'Shipping Delay', 'SHIPPING_DAYS_DELAY', '1', 'How many days from when an order is placed to when you ship it (Decimals are allowed). Arrival date estimations are based on this value.', '6', '21', NULL, now(), NULL, NULL) I'm on a Windows box. Any ideas? Thanks, Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 20, 2007 Share Posted April 20, 2007 After I made all of the changes I get the following error when I try to install the module. 1366 - Incorrect integer value: '' for column 'configuration_id' at row 1 insert into configuration ( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('', 'Shipping Delay', 'SHIPPING_DAYS_DELAY', '1', 'How many days from when an order is placed to when you ship it (Decimals are allowed). Arrival date estimations are based on this value.', '6', '21', NULL, now(), NULL, NULL) You could try changing the '' to NULL (look for that in the /shipping/upsxml.php file): insert into configuration ( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (NULL, 'Shipping Delay', 'SHIPPING_DAYS_DELAY', '1', 'How many days from when an order is placed to when you ship it (Decimals are allowed). Arrival date estimations are based on this value.', '6', '21', NULL, now(), NULL, NULL) Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.