One2remember

Stew, You did it again! Thanks!

This is an example of an order this I hav'nt change with the editor. Product: € 20.90 Total from products Excl. TAX: € 17,56 Shipping : € 5,50 (Total Excl. TAX: € 22,18) TAX 19 %: € 4,22 Total: € 26,40 This is the same order if I only used the update button in the editor. The Total Excl. TAX is changed. Product: € 20.90 Total from products Excl. TAX: € 17,56 Shipping : € 5,50 (Total Excl. TAX: € 23,06) TAX 19 %: € 4,22 Total: € 26,40 I hope you can see what I meen.

I don't understand. Must I change the shippingcosts in excl TAX if I change the order in order editor?? All mine shippingcosts arie incl TAX.

This is only happening when the order is editted en updated!

Yes that's te same shop! It works fine, there's only a little problem. The Tax from the shipping is counting twice in the order total ex TAX. Like this: Product (incl TAX): 10.00 Subtotal products (ex. VAT): 8.40 Shipping (incl. TAX): 5.00 TAX 19%: 2.40 Order Total (ex TAX): 13.40 (0.80 to much) Total (incl TAX): 15.00 Do you now what's wrong??

Dear Stew, I now, I'm a very irritated person. :huh: If you don't want to answer this question I can understand, but I have to ask you. In my shop I have a "products Sub-total" and a "end-sub-total". For example: Product price: € 20,-- Product sub-total: € 16.81 Shipping costs: € 5.-- Total excl VAT: 21.01 VAT 19% : 3.99 Order Total: 25.00 That last one (the End Total excl. VAT) I have made with the contribution ot_netto: http://www.oscommerce.com/community/contributions,1926 On the order it looks very good, but when I edit the order with the order editor the Total Excl. VAT becomes a part of the SUM. Is there a possibility to make that price a non-editable. And is it possible that it is not a part of the SUM after update. Screenshot of the problem.

Thanks Stew!!! It works excelent now!! 1000 times thanks!

Yes they are!!!

Stew, Strange? If I going to edit the order realy, for example I change the quantity from teh atributes from one in two and click update, then it works fine. The price by Sub total ex is fine. If I change the shipping costs and give no shipping tax, then the tax is wrong. If I give shipping tax 19% then there are two Tax items ??

No, the price from the atributes are ex. 19% BTW (VAT) The file edit_orders is changed like post 1937, 1940 and 1947 This is the order as I click on details Artikelen Model BTW Prijs (excl.) Prijs (incl.) Totaal (excl.) Totaal (incl.) 1 x 1GB Kingston Secure Digital SD/1GB 19% € 8,74 € 10,40 € 8,74 € 10,40 Subtotaal Excl.: € 8,74 Standaard verzending (gratis): € 0,00 BTW 19 %: € 1,66 Totaal: € 10,40 But by clicking edit order I have this:

Dos it make any difference where the sub-total is locate? See the Image????

This is the complete code for the first part: //update subtotal and total during update function $RunningSubTotal += (($products_details['tax']/100 + 1) * ($products_details['qty'] * $products_details['final_price'])); $RunningSubTotal_EX += $products_details["qty"] * $products_details["final_price"]; $RunningTax[$products_details['tax_description']] += (($products_details['tax']/100) * ($products_details['qty'] * $products_details['final_price'])); // Update Any Attributes This is the complete code for the second part: if (is_array ($_POST['update_totals'])) { foreach($_POST['update_totals'] as $total_index => $total_details) { extract($total_details,EXTR_PREFIX_ALL,"ot"); if (trim($ot_title)) { $sort_order++; if ($ot_class == "ot_subtotal") { $ot_value = $RunningSubTotal; } if ($ot_class == "ot_subtotal_ex") { $ot_value = $RunningSubTotal_EX; } if ($ot_class == "ot_tax") { $ot_value = $RunningTax[preg_replace("/:$/","",$ot_title)]; }if ($ot_class == "ot_total") { $ot_value = $RunningTotal; if ( !$ot_subtotal_found ) I can't see the problem but I'm not a very good php'r

Used: order_editor_3_0_2_1 and Order_Total_excluding_VAT. I've the same problem and do everthing you tell before from post 1929 to post 1952, but I have still the same problem. This is the screenshot, as you see the subtotal is the same as the total I've you want to see the complete code I can post it!

Thanks, thanks, thanks, and that for a thousand times! It works!

Hello, I've update the order editor from 2.5 uo to 3_0_2_1. It looks likes it works fine I've just one problem. I've compared the general.php file from the old version and the new version. This piece of code I have delete from the old one to let it work: /// Begin mods for Order Editor // Return the tax description for a zone / class // TABLES: tax_rates; function tep_get_tax_description($class_id, $country_id, $zone_id) { $tax_query = tep_db_query("select tax_description from " . TABLE_TAX_RATES . " tr left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id) left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '" . (int)$country_id . "') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '" . (int)$zone_id . "') and tr.tax_class_id = '" . (int)$class_id . "' order by tr.tax_priority"); if (tep_db_num_rows($tax_query)) { $tax_description = ''; while ($tax = tep_db_fetch_array($tax_query)) { $tax_description .= $tax['tax_description'] . ' + '; } $tax_description = substr($tax_description, 0, -3); return $tax_description; } else { return ENTRY_TAX; } } //// // Function : tep_get_country_id // Arguments : country_name country name string // Return : country_id // Description : Function to retrieve the country_id based on the country's name function tep_get_country_id($country_name) { $country_id_query = tep_db_query("select * from " . TABLE_COUNTRIES . " where countries_name = '" . $country_name . "'"); if (!tep_db_num_rows($country_id_query)) { return 0; } else { $country_id_row = tep_db_fetch_array($country_id_query); return $country_id_row['countries_id']; } } // Function : tep_get_zone_id // Arguments : country_id country id string zone_name state/province name // Return : zone_id // Description : Function to retrieve the zone_id based on the zone's name function tep_get_zone_id($country_id, $zone_name) { $zone_id_query = tep_db_query("select * from " . TABLE_ZONES . " where zone_country_id = '" . $country_id . "' and zone_name = '" . $zone_name . "'"); if (!tep_db_num_rows($zone_id_query)) { return 0; } else { $zone_id_row = tep_db_fetch_array($zone_id_query); return $zone_id_row['zone_id']; } } // Function : tep_html_quotes // Arguments : string any string // Return : string with single quotes converted to html equivalent // Description : Function to change quotes to HTML equivalents for form inputs. function tep_html_quotes($string) { return str_replace("'", "'", $string); } /////end Order Editor mods The order editor is works fine!!! But if I use in "orders" the button "details" I get: Fatal error: Call to undefined function: tep_get_country_id() in /home/remember/domains/one2remember.nl/public_html/admin/includes/classes/order.php on line 90 If I put back the old general.php everything works fine exept the order-editor. Then I get this: Fatal error: Cannot redeclare tep_get_tax_description() (previously declared in /home/remember/domains/one2remember.nl/public_html/admin/includes/functions/general.php:15) in /home/remember/domains/one2remember.nl/public_html/admin/includes/functions/oe_functions.php on line 35 What's going wrong?? Can somebody help me?? :'(