Jump to content

cg-tbear

Members
  • Content count

    57
  • Joined

  • Last visited

Everything posted by cg-tbear

  1. cg-tbear

    NEW! Complete Order Editing Tool!

    I am having the same problem as Maxxis and Chris and have installed the same Shipping Insurance mod as them. Insurance appears, but becomes non-editable after a change is made in the editor, and the insurance amount is not added to the total. Chris posted a fix for this; but for the life of me, I can't figure out what he did to make the insurance show up in the total. (I was able to make it editable.) He says he added a line before these lines: $written_ot_totals_array[] = $ot_class; $written_ot_titles_array[] = $ot_title; The problem is that these two lines occur six times in the edit_orders.php file. I have no clue how to fix it because my php and javascript are very limited. Add in that AJAX thing and I'm completely lost. I've been searching this thread for three afternoons. :blink: HELP PLEASE! Chris's posts were #2701 & #2702 dated April 2008. Maxxis, any clue? Corinne
  2. cg-tbear

    NEW! Complete Order Editing Tool!

    Try checking your "admin/includes/languages/english/index.php" file. Usually when something like this happens to me, I find that I have accidentally uploaded the root file with the same name (in your case "admin/index.php") instead of the one with the english definitions. Corinne
  3. cg-tbear

    New UPS XML Shipping Module available

    Hey, Jan! The logging really helped. It turns out that the problem was a combination of a couple of things. First, the cases of cassette albums are oversized and I didn't think they were (My bad!). That accounted for about $10.00 of the extra $15.00. The second thing I'm not sure if its a bug or just how the module is supposed to work. I had checked the box for insurance, which means that there will be extra charges for this. The order was about $106.00, so the insurance charge should have been $1.50. For whatever reason, when UPS sends back the info, it is charging $1.50 PER BOX and not $1.50 for the entire order. Is this fixable? Its nice to have a little cushion on the shipping charges, but I still would like to be as accurate as possible on our quotes. Thanks again for your continued help! :thumbsup: Corinne
  4. cg-tbear

    New UPS XML Shipping Module available

    Jan, you are amazing at this! It worked! The correct weight is now shown! Yea! BUT....there is now another problem. I guess this is what you call debugging. The UPS quotes are off for the products that are ready-to-ship AND from the pulldown menu. Its quoting significantly high. I did several orders and it was averaging about $15.00 too much (not always the same amount off). In my tests, the rates were dead on for regular items and for items from a pulldown menu. Any thoughts? By the way, the e-mail error messages have stopped. Maybe these kinds of cURL and transit errors are just symptoms of other errors and not indications of independent cURL and transit errors. FYI, they looked like this: Error from cURL: Error [6]: Couldn't resolve host 'www.ups.com' experienced by customer with id 2 on 2006-08-07 14:04:24 UPSXML TimeInTransit Error: : experienced by customer with id 2 on 2006-08-07 14:04:24 Corinne
  5. cg-tbear

    New UPS XML Shipping Module available

    Hi Jan, The reason we did it that way is because the weight and packaging of our products varies so much that its easier for us just to put in the total shipping weight than try and figure out how much we have to add to each one. Anyway, it didn't work. I KNOW that we need to subtract the original product weight, but I don't know how. Here's the whole "get_products" function again. Maybe I defined "$products_weight" in the wrong place, but I did it the same way the "function caclulate()" has it. function get_products() { global $languages_id; if (!is_array($this->contents)) return false; //BOF Price Break Module $pf = new PriceFormatter; //EOF Price Break Module $products_array = array(); reset($this->contents); while (list($products_id, ) = each($this->contents)) { //BOF Price Break Module if ($products = $pf->loadProduct($products_id, $languages_id)) { $products_price = $pf->computePrice($this->contents[$products_id]['qty']); //EOF Price Break Module $products_weight = $product['products_weight']; //UPS XML //BOF phpmom.com advanced attribute price //hadir $attributes_price = 0; if (isset($this->contents[$products_id]['attributes'])) { reset($this->contents[$products_id]['attributes']); while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $attribute_price_query = tep_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and options_id = '" . (int)$option . "' and options_values_id = '" . (int)$value . "'"); $attribute_price = tep_db_fetch_array($attribute_price_query); if ($attribute_price['price_prefix'] == '') { $attributes_price += ($attribute_price['options_values_price']-$products_price); } elseif ($attribute_price['price_prefix'] == '+') { $attributes_price += $attribute_price['options_values_price']; } elseif ($attribute_price['price_prefix'] == '-') { $attributes_price -= $attribute_price['options_values_price']; } } } //EOF phpmom.com advanced attribute price//hadir // BOF: UPS XML Rates & Services ? Attributes Fix // determine total weight of attributes to add to weight of product $attributes_total_weight = 0; if (isset($this->contents[$products_id]['attributes'])) { reset($this->contents[$products_id]['attributes']); $where = ' AND (('; while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $where .= 'options_id=' . $option . ' AND options_values_id=' . $value . ') OR ('; } $where=substr($where, 0, -5) . ')'; $attribute_weight_query = tep_db_query('SELECT options_values_weight FROM ' . TABLE_PRODUCTS_ATTRIBUTES . ' WHERE products_id=' . (int)$products_id . $where); if (tep_db_num_rows($attribute_weight_query)) { while ($attributes_weight_array = tep_db_fetch_array($attribute_weight_query)) { $attributes_total_weight += $attributes_weight_array['options_values_weight']-$products_weight; } } // end if (tep_db_num_rows($attribute_weight_query)) } // end if (isset($this->contents[$products_id]['attributes'])) // EOF: UPS XML Rates & Services ? Attributes Fix $products_array[] = array('id' => $products_id, 'name' => $products['products_name'], 'model' => $products['products_model'], 'image' => $products['products_image'], 'price' => $products_price, 'quantity' => $this->contents[$products_id]['qty'], // BOF: UPS XML Rates & Services ? Attributes Fix 'weight' => $products['products_weight'] + $attributes_total_weight, // EOF: UPS XML Rates & Services ? Attributes Fix // BOF: UPS XML Rates & Services 'length' => $products['products_length'], 'width' => $products['products_width'], 'height' => $products['products_height'], 'ready_to_ship' => $products['products_ready_to_ship'], // EOF: UPS XML Rates & Services 'final_price' => ($products_price + $attributes_price), //BOF phpmom.com advanced attribute price 'attributes_price' => $attributes_price, //EOF phpmom.com advanced attribute price 'tax_class_id' => $products['products_tax_class_id'], 'attributes' => (isset($this->contents[$products_id]['attributes']) ? $this->contents[$products_id]['attributes'] : '')); } } return $products_array; } Maybe my syntax is off. Do I need parentheses around the Thanks again for your help. Corinne
  6. cg-tbear

    New UPS XML Shipping Module available

    Hi again, John, Our site is actually divided up into two parts. We have a normal HTML part and then we have the osCommerce cart. The way our ISP has things set up, its just much easier to put the whole cart onto the SSL cert. It doesn't seem like there are any problems with it. I think it just means the whole thing is secure. Thanks for the input, though. Corinne
  7. cg-tbear

    New UPS XML Shipping Module available

    Hi John, We're not quite out of the woods yet. Feel free to jump in. Corinne
  8. cg-tbear

    New UPS XML Shipping Module available

    Hi Jan, I really appreciate the time you're taking to help me with this. You were right! That fixed it! The $prid thing makes total sense. HallMark referenced it in the attribute fix because it would normally be there, but in my version, it was taken out by the Price Break module. We are sooooo close. The function is adding the original weight to attributes weight. Bear with me on this. In the previous "function calculate()" in the "Add Weight To Product Attributes" module, the author, kumar, gives you the option of adding the weight to the original weight: if(!empty($attribute_price['options_values_weight'])) { $this->weight += ($qty * $attribute_price['options_values_weight']); } or imputting the total weight: if(!empty($attribute_price['options_values_weight'])) { $this->weight += ($qty * $attribute_price['options_values_weight'])-($qty * $products_weight); } I chose the second one. To me, these looks similar to what is in HallMark's fix. It looks like we need to subtract out the original product weight since I did so before. So, if in the "get_products" function I define $products_weight as: $products_weight = $product['products_weight']; Will this code (or something like it) work? if (tep_db_num_rows($attribute_weight_query)) { while ($attributes_weight_array = tep_db_fetch_array($attribute_weight_query)) { $attributes_total_weight += $attributes_weight_array['options_values_weight'] - $products_weight; My syntax could be way off. I am by no means a PHP programmer. Am I at least on the right track? Corinne
  9. cg-tbear

    New UPS XML Shipping Module available

    Hey Jan, It looks like I have a lot of work ahead of me. What a mess! I checked my e-mail and now I have the dreaded TimeInTransit and cURL error messages. I know I've seen those in this thread before, so you don't have to worry about them (for now, anyway). Yeah, I did. Right before I left work yesterday. That particular cart doesn't get a whole lot of business, so I wasn't terribly worried. I just thought it was kind-of funny. I think you may have identified the spot, but its not as easy to fix as you may think. That particular function already had code changes from three other modules, so the code I was supposed to change actually doesn't exist any more in my file. The Price Break module changes it to this: //BOF Price Break Module if ($products = $pf->loadProduct($products_id, $languages_id)) { $products_price = $pf->computePrice($this->contents[$products_id]['qty']); //EOF Price Break Module To me, it looked like they made some kind of function to run through the products, so I was hoping that it would be okay. It seemed to work with the other product modules that I had installed. Here is the whole "get_products" function. You will be able to see what a mess I'm dealing with. function get_products() { global $languages_id; if (!is_array($this->contents)) return false; //BOF Price Break Module $pf = new PriceFormatter; //EOF Price Break Module $products_array = array(); reset($this->contents); while (list($products_id, ) = each($this->contents)) { //BOF Price Break Module if ($products = $pf->loadProduct($products_id, $languages_id)) { $products_price = $pf->computePrice($this->contents[$products_id]['qty']); //EOF Price Break Module //BOF phpmom.com advanced attribute price //hadir $attributes_price = 0; if (isset($this->contents[$products_id]['attributes'])) { reset($this->contents[$products_id]['attributes']); while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $attribute_price_query = tep_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "' and options_id = '" . (int)$option . "' and options_values_id = '" . (int)$value . "'"); $attribute_price = tep_db_fetch_array($attribute_price_query); if ($attribute_price['price_prefix'] == '') { $attributes_price += ($attribute_price['options_values_price']-$products_price); } elseif ($attribute_price['price_prefix'] == '+') { $attributes_price += $attribute_price['options_values_price']; } elseif ($attribute_price['price_prefix'] == '-') { $attributes_price -= $attribute_price['options_values_price']; } } } //EOF phpmom.com advanced attribute price//hadir // BOF: UPS XML Rates & Services ? Attributes Fix // determine total weight of attributes to add to weight of product $attributes_total_weight = 0; if (isset($this->contents[$products_id]['attributes'])) { reset($this->contents[$products_id]['attributes']); $where = ' AND (('; while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $where .= 'options_id=' . $option . ' AND options_values_id=' . $value . ') OR ('; } $where=substr($where, 0, -5) . ')'; $attribute_weight_query = tep_db_query('SELECT options_values_weight FROM ' . TABLE_PRODUCTS_ATTRIBUTES . ' WHERE products_id=' . (int)$prid . $where); if (tep_db_num_rows($attribute_weight_query)) { while ($attributes_weight_array = tep_db_fetch_array($attribute_weight_query)) { $attributes_total_weight += $attributes_weight_array['options_values_weight']; } } // end if (tep_db_num_rows($attribute_weight_query)) } // end if (isset($this->contents[$products_id]['attributes'])) // EOF: UPS XML Rates & Services ? Attributes Fix $products_array[] = array('id' => $products_id, 'name' => $products['products_name'], 'model' => $products['products_model'], 'image' => $products['products_image'], 'price' => $products_price, 'quantity' => $this->contents[$products_id]['qty'], // BOF: UPS XML Rates & Services ? Attributes Fix 'weight' => $products['products_weight'] + $attributes_total_weight, // EOF: UPS XML Rates & Services ? Attributes Fix // BOF: UPS XML Rates & Services 'length' => $products['products_length'], 'width' => $products['products_width'], 'height' => $products['products_height'], 'ready_to_ship' => $products['products_ready_to_ship'], // EOF: UPS XML Rates & Services 'final_price' => ($products_price + $attributes_price), //BOF phpmom.com advanced attribute price 'attributes_price' => $attributes_price, //EOF phpmom.com advanced attribute price 'tax_class_id' => $products['products_tax_class_id'], 'attributes' => (isset($this->contents[$products_id]['attributes']) ? $this->contents[$products_id]['attributes'] : '')); } } return $products_array; } Thanks for clearing that up. It makes a little more sense now. So, to sum up - HELP! Corinne
  10. cg-tbear

    New UPS XML Shipping Module available

    Oh, one more thing. The USPS module is calculating the correct weight, so I know all of the information is correct. Its just not getting to the right places in the UPSXML module. Corinne
  11. cg-tbear

    New UPS XML Shipping Module available

    Hi Jan, I checked the database and "products_ready_to_ship" is there. The install also adds several "package_whatever" to the database, but not a "package_ready_to_ship". If that is needed, then it is missing from the install. I did the echo thing. Very interesting. Our cart is live, so if any of the customers see it, they're going to be very confused. Here's what I get with the echo: Array ( [0] => Array ( [id] => 58{2}34 [name] => Case of Cassette Albums: 0+2 & Other Sizes [model] => [image] => binders2.jpg [price] => 99.0000 [quantity] => 1 [weight] => 10 [length] => [width] => [height] => [ready_to_ship] => [final_price] => 77.75 [attributes_price] => -21.25 [tax_class_id] => 1 [attributes] => Array ( [2] => 34 ) ) [1] => Array ( [id] => 29{1}18 [name] => Single Copying Cassettes: C-10 & Other Lengths [model] => [image] => casstape.gif [price] => 0.3900 [quantity] => 5 [weight] => 0.06 [length] => [width] => [height] => [ready_to_ship] => [final_price] => 0.48 [attributes_price] => 0.09 [tax_class_id] => 1 [attributes] => Array ( [1] => 18 ) ) ) As you can see, none of the new fields (L,W,H,RTS) has any information stored in them, so there seems to be some kind of problem with entering the information. Do you know where this would happen? The weight for the cassette albums is wrong (the first array). It should be 20. This item was one from the pulldown menu. The 10 is from the page where you enter all the product information. Also, I just noticed that the module sets a default of 12 for all of the product dimensions. Since we aren't using the box dimensions for calculating, this won't affect anything. Right? Corinne
  12. cg-tbear

    New UPS XML Shipping Module available

    Hi Jan, John, and everyone! I'm back. I was here about a month ago asking about this module. I had some other projects I needed to attend to, but now I need to make this work. I've searched through the pages of this forum from August of last year and I can't find anything. If I've missed it, I apologize. I've installed the latest Feb. 7 version and the Attr w/ weights fix, but I'm still having two problems: First, the Ready-To-Ship option is not working (even though the box is checked), so it puts everything in one box. The second problem I think has to do with the Products Attributes Module. This creates a pulldown list of product options to choose what kind of product you want to put in the cart. For example, if you sell T-shirts the pull down could have the different sizes of S, M, L, & XL. Anyway, in my situation, each item in the pulldown list has a different weight. These items are cases of cassettes and the difference from the smallest case to the largest case is 10 lbs. This messes up the UPS quotes and we really eat it on the shipping. The UPSXML module is only adding the weight that you enter on the original product page and doesn't add the weight from each "attribute" in the pulldown list. The original UPS module that came with the cart had no problem with the attributes weights. Can anyone help? A little info: Cart version - 2.2ms2 Heavily Modded Tare - .03 lbs UPS Shipping Enabled - True Production Mode Dimensions Support - Ready-To-Ship only Handling Fee - Flat Rate, $0.00 Corinne
  13. cg-tbear

    UPSXML problem

    Hi Lobos34, The contribution support thread for this module has several discussions about this issue. You can probably find some help if you do a search on the thread. The search box is at the bottom lower left corner of the page and you have to be logged in to use it. Here is a link to the latest question posted: Gameprodigy's Post #950 - July 18, 2006 Good Luck! Corinne
  14. cg-tbear

    New UPS XML Shipping Module available

    Thanks for the module suggestion, John! I wrote it down on my module wish list for the future. On to coding. Corinne
  15. cg-tbear

    New UPS XML Shipping Module available

    Ted, I felt exactly the same way you did when I read the posts. I was less direct in my response, but you responded wonderfully! Good job! ******************************* Hey All! I spoke to my boss and its a go! I will be installing this module and also USPS Methods (for our international shipping). I have 19 modules already installed, so this could get really tricky if any of the code changes overlap. Wish me luck! Corinne
  16. cg-tbear

    New UPS XML Shipping Module available

    Ted, I apologize for my misinformation about the UPS module. I had no idea it was pulled. Just trying to help. Corinne
  17. cg-tbear

    New UPS XML Shipping Module available

    Hi John, Thank you very much for your response. It has been both informative and reassuring. I did read through several sections in this thread; through the "dimensions.txt", "readme.txt", and the "changes.txt" files from the download; and through the expanded list of updates on this contribution's download page before I placed my post. I guess after days of researching twenty or so shipping modules and searching through numerous threads, somehow my brain just did not absorb that section about "ready to ship" boxes. Anyway, thank you for bringing that feature to my attention and also letting me know where to start reading in the thread. This thread has over 47,000 posts, so its a like finding a needle in a haystack to get the information you need. Your direction to Fall '05 will, I'm sure, be very useful. Also, I did see Jan's mention (and now yours) about the "manual". I was never able to find that - unless its those text files from the download that I mentioned previously. Could you tell me where the manual is if it isn't those files? Thanks again for your help. You have helped to convince me that our shopping cart problem will be solved with the addition of this module. I will inform my boss of my findings and hopefully we will soon have a working solution. Sincerely, Corinne
  18. cg-tbear

    New UPS XML Shipping Module available

    Ted, This thread is actually for the UPS XML module, which is not the original UPS module that comes with the cart. The UPS module should show up in your admin section. You should also be able to see Flat Rate, Per Item, Table Rate, United States Postal Service, and Zone Rates. The default is the Flat Rate. If you want UPS, you need to install it there by first clicking on the UPS line to select it and then clicking on the install button on the right. Hope this helps! Any comments on my previous post? Corinne
  19. cg-tbear

    New UPS XML Shipping Module available

    Hi All, We had a serious shipping miscalculation in our cart recently and I'm hoping this module will fix it. We have a heavily modded 2.2ms2 version and are currently using the stock USPS and UPS modules. A customer ordered three cases of cassette albums. Each case weighs about 20 pounds and has to be shipped separately. Instead of calculating the shipping charges for separate boxes, the cart combined the weight as if we were shipping one huge package and undercharged the customer by $20.00. It did this for both UPS and USPS, which is exactly how the modules were designed to function. On smaller items in our cart, this is perfectly fine and we want the cart to do exactly what it did; but for cases of products, we need something that will know when a product is very large and is shipped separately and will charge the appropriate charges. We don't want to charge flat rates because local customers will end up paying way too much for shipping. I've looked through some of this thread and I think this module will work, but I need someone to verify that it meets our requirements. We need it to: 1. Have a way to differentiate between large products that are shipped separately and small products that will be shipped together in one package. 2. Charge the appropriate shipping charges based on what is determined in #1. 3. Allow us to choose what UPS methods we want to ship by. 4. Quote shipping charges that include insurance, fuel charges, residential/commercial rates, rural zones, etc. Also, all of our shipping has been weight based and we would like to continue that way if possible. As I said before, I think this module will work; but before I spend hours installing and testing the module, I would like someone to verify that it will work for us. Thanks! Corinne
  20. cg-tbear

    Flat rate decided by country

    Hi Jason, I see what you mean. Here's another couple of contributions that could possibly help: Multiple Flat Rates V2 - If I remember correctly, you can set it so that each flat rate only comes up for a certain zone. Here's the link: Multiple Flat Rates V2 Zipcode/Shipping Delivery - Delivery fee is based on zipcode "zones". Link: Zipcode/Shipping Delivery Hope this helps! Corinne
  21. cg-tbear

    Flat rate decided by country

    Hi Jason, You might try looking at contributions that are zone based. Then select the zones of those countries for the flat rate. There is a contribution that sets a surcharge based on the country, so maybe that one could work for you. Its the "Shipping Surcharge" module. I haven't used it, but its one of the ones I'm considering. The link is here: http://www.oscommerce.com/community/contri...pping+Surcharge I'm going to be looking around at some zone based modules. If I come across something else, I'll let you know. Corinne
  22. Hello, I have been searching for an hour or so and I can't seem to find a contribution that exactly solves my problem. We are able to ship to other countries, but for some international shipping methods we need to charge a handling fee because of all the time it takes filling out all of the forms and then going down to the post office to get the package stamped with the proper postmarks, etc. All of the contributions I've been reading about seem to charge the handling fee based on zones or weight or price, but I need something that charges it based on the method of shipping. For example, we have no problem shipping Airmail Letter Post, but Registered Airmail Letter Post has extra forms and gets stamped with a postmark. We don't want to limit the customer's options because we want them to be able to insure packages and/or get them by a faster method if they so desire. Does anyone know if any of the shipping contributions will do this or if something else can be modified to do this?
  23. I'm still having problems with the popup error messages. I've been thinking maybe there is a conflict with a couple of modules. I have about 19 modules added. The only ones that I think might have a possibility of a conflict are the "Purchase Without Account" and the "Cancelled Orders Module". If the Batch Print Center Module is going through an array of orders and comes to one of the cancelled ones, maybe it is causing it to go haywire because its not finding what it expected to find. Also, if its looking for a customer's account and they went through checkout without creating an account, maybe that is messing it up. Can someone tell me how it accesses the orders/accounts? Again, here is the list of typical errors I'm getting: "Illegal operation 'BT' inside a text object." "There were several parse errors on this page." "There were too many arguments." "An unrecognized token 'City,' was found." "There was a problem reading this document (114)." "An unrecognized token 'ETT' was found." "An unrecognized token 'F2' was found." "A drawing error occurred." Does anyone have any idea what these errors mean? Corinne
  24. Okay, I've been messing around a while and I got the date thing to work with two different admin/batch_print files. The space before "23:59:59" works on the 1054 file (THANKS GATTA!) and the date fix by Travis Wiznuik also works. I'm still getting those stupid popup problems. Here's yet another error message in the popup: "There were too many arguments." HELLLLLP PLEEEEASE! Corinne
  25. Hi Jodes, I have a suggestion, but I'm not sure if it will work. I can't test anything because I keep getting the error popups when the pdf files are generated. Looking at what you said in your post and at the invoice code, it looks like maybe the <br> isn't in quotes and it should be. It shouldn't be printing out with your shipping info. I would first check for the quotes and the I would try testing putting it in other places in the code where you know things are printing on the pdf file and then try to put it where you need to. Maybe find this line: And add a bunch of <br> characters between the quotes like this: And see if that works. Then I would try putting it in other spots and see what happens. Just a thought. Now, can anyone help me with my error popup problems? Here are two more: "Illegal operation 'BT' inside a text object." "There were several parse errors on this page." Corinne
×