djmonkey1 Posted April 18, 2006 Share Posted April 18, 2006 (edited) I use oscommerce with joomla/mambo and all my variable are $_REQUEST in my store this is the way to my order.php this is the way to my edit_orders.php but when i will add a product in step 3 of the edit_orders.php, so i have this way and its wrong: the error is here: <form action=' . $_SERVER['PHP_SELF'] .'?oID=' . Have you tried <form action=' . $PHP_SELF .'?oID=' . Edited April 18, 2006 by djmonkey1 Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Guest Posted April 18, 2006 Share Posted April 18, 2006 is the same error :-( Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 19, 2006 Share Posted April 19, 2006 is the same error :-( How about echo '<tr class="dataTableRow"><form action='&action=' . $_GET['action'] . ' method="POST">' . "\n"; Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
evilbaka Posted April 19, 2006 Share Posted April 19, 2006 Hi guys, love this contribution but I'm getting a small error on the details page. Under Payment Method it says authorize.net, which I'm using but under data I get : Data: Error in encryption What's causing this? I'm sure I probably didn't set something up right, can someone point me in the right direction? Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 19, 2006 Share Posted April 19, 2006 Hi guys, love this contribution but I'm getting a small error on the details page. Under Payment Method it says authorize.net, which I'm using but under data I get : Data: Error in encryption What's causing this? I'm sure I probably didn't set something up right, can someone point me in the right direction? Could you be more specific? Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
evilbaka Posted April 19, 2006 Share Posted April 19, 2006 (edited) Could you be more specific? Edited April 19, 2006 by evilbaka Quote Link to comment Share on other sites More sharing options...
pieterj Posted April 19, 2006 Share Posted April 19, 2006 I think it should work ok for you- could you describe your tax setup in more detail? I've got one zone (The Netherlands) in which I vreated 2 taxgroups: One for 6% VAT, and one for 19%. Both of them are used in my shop (the lower tax is for medical instruments). If a costumer orders articles from both taxgroups, and I want to edit this order, first the problem were that both taxes were calculated as 19% (the highets rate), now both taxgroups are calculated twice: Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 20, 2006 Share Posted April 20, 2006 Gotcha- Order Editor doesn't use encryption, just straight data transfer. You would have to custom modify it to encrypt the data in whatever way the code for authorize.net is expecting. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 20, 2006 Share Posted April 20, 2006 I've got one zone (The Netherlands) in which I vreated 2 taxgroups: One for 6% VAT, and one for 19%. Both of them are used in my shop (the lower tax is for medical instruments). If a costumer orders articles from both taxgroups, and I want to edit this order, first the problem were that both taxes were calculated as 19% (the highets rate), now both taxgroups are calculated twice: Find this section of code at about line 341: if (is_array ($_POST['update_totals'])){//1 foreach($_POST['update_totals'] as $total_details) {//2 extract($total_details,EXTR_PREFIX_ALL,"ot"); $ot_tax_found = 0; if (($ot_class == "ot_tax") && ($ot_title == $key)) {//3 $ot_tax_found = 1; break; }//end 3 }//end 2 and change it to this: if (is_array ($_POST['update_totals'])){//1 foreach($_POST['update_totals'] as $total_details) {//2 extract($total_details,EXTR_PREFIX_ALL,"ot"); $ot_tax_found = 0; if (($ot_class == "ot_tax") && (preg_replace("/:$/","",$ot_title) == $key)) {//3 $ot_tax_found = 1; break; }//end 3 }//end 2 Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Curly Posted April 20, 2006 Share Posted April 20, 2006 I also have the problem with the extra tax field appearing after an update. I searched this thread but I couldn't find an answer. Is there a solution for this problem? Or at least some kind of a solution to remove the extra tax field again, because now I can't get rid of it once it is there. Thanks in advance! Quote Link to comment Share on other sites More sharing options...
Curly Posted April 20, 2006 Share Posted April 20, 2006 Also, when I want to give a discount of lets say 5 euro, the discount is substracted from the total, but the amount of tax is not changed. In my opinion the tax amount should also have to change, because it is a percentage of the order total. Is it possible to also have the tax amount change when you apply a discount? Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 20, 2006 Share Posted April 20, 2006 I also have the problem with the extra tax field appearing after an update.I searched this thread but I couldn't find an answer. Is there a solution for this problem? Or at least some kind of a solution to remove the extra tax field again, because now I can't get rid of it once it is there. Thanks in advance! Delete the field from the database. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 20, 2006 Share Posted April 20, 2006 Also, when I want to give a discount of lets say 5 euro, the discount is substracted from the total, but the amount of tax is not changed. In my opinion the tax amount should also have to change, because it is a percentage of the order total.Is it possible to also have the tax amount change when you apply a discount? Read post #763 for an example of how to accomplish this. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
pieterj Posted April 20, 2006 Share Posted April 20, 2006 Find this section of code at about line 341: if (is_array ($_POST['update_totals'])){//1 foreach($_POST['update_totals'] as $total_details) {//2 extract($total_details,EXTR_PREFIX_ALL,"ot"); $ot_tax_found = 0; if (($ot_class == "ot_tax") && ($ot_title == $key)) {//3 $ot_tax_found = 1; break; }//end 3 }//end 2 and change it to this: if (is_array ($_POST['update_totals'])){//1 foreach($_POST['update_totals'] as $total_details) {//2 extract($total_details,EXTR_PREFIX_ALL,"ot"); $ot_tax_found = 0; if (($ot_class == "ot_tax") && (preg_replace("/:$/","",$ot_title) == $key)) {//3 $ot_tax_found = 1; break; }//end 3 }//end 2 YES!!! It works! Thank you very much, djmonkey! :thumbsup: Quote Link to comment Share on other sites More sharing options...
Pilly Posted April 26, 2006 Share Posted April 26, 2006 Ive just installed v.2.4.1 Has anyone had this problem? I added a product via the editor, then updated. I now have 2 vat boxes? Original Added product Updated Any ideas? Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 26, 2006 Share Posted April 26, 2006 Ive just installed v.2.4.1 Has anyone had this problem? I added a product via the editor, then updated. I now have 2 vat boxes? Original Any ideas? Read the post directly above yours. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
varnco Posted April 26, 2006 Share Posted April 26, 2006 Is the latest version the one that is recommended to be installed on a heavily modified site? Thanks. Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 26, 2006 Share Posted April 26, 2006 Is the latest version the one that is recommended to be installed on a heavily modified site? Thanks. It's the one that works the best. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
patator Posted April 26, 2006 Share Posted April 26, 2006 Hello I've been using version 1.72 up to now and decided to upgrade it to version 2.4 (deletion problems). I'm now facing two problems : 1- After adding a product, the total is not calculated : 2- If I click on update or delete, I get an error message : Warning: Division by zero in /home/httpd/vhosts/clubfitting.net/httpdocs/admin/edit_orders.php on line 476 Could somebody help ? Thanks in advance Pat Quote Link to comment Share on other sites More sharing options...
varnco Posted April 26, 2006 Share Posted April 26, 2006 It's the one that works the best. thanks... I'll give it a try. Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 27, 2006 Share Posted April 27, 2006 Hello I've been using version 1.72 up to now and decided to upgrade it to version 2.4 (deletion problems). I'm now facing two problems : 1- After adding a product, the total is not calculated : 2- If I click on update or delete, I get an error message : Warning: Division by zero in /home/httpd/vhosts/clubfitting.net/httpdocs/admin/edit_orders.php on line 476 Could somebody help ? Thanks in advance Pat Are you sure that you made all the changes as required by the installation instructions? Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
patator Posted April 27, 2006 Share Posted April 27, 2006 Are you sure that you made all the changes as required by the installation instructions? I believe so, here is what I did : - change edit_order.php (v2.4.1) - run the sql - amend admin/includes/functions/general.php - partly amend catalog/admin/includes/classes/order.php (it's an upgrade for me) : Find this starting at line 80: $index = 0; $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); $subindex = 0; $attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'"); if (tep_db_num_rows($attributes_query)) { while ($attributes = tep_db_fetch_array($attributes_query)) { $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price']); Replace it with this: $index = 0; $orders_products_query = tep_db_query(" select op.orders_products_id, op.products_name, op.products_model, op.products_price, op.products_tax, op.products_quantity, op.final_price, p.products_tax_class_id from " . TABLE_ORDERS_PRODUCTS . " op join " . TABLE_PRODUCTS . " p on op.products_id = p.products_id where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'tax_description' => tep_get_tax_rates_description($orders_products['products_tax_class_id']), 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price'], 'orders_products_id' => $orders_products['orders_products_id']); $subindex = 0; $attributes_query = tep_db_query("select * from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'"); if (tep_db_num_rows($attributes_query)) { while ($attributes = tep_db_fetch_array($attributes_query)) { $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price'], 'orders_products_attributes_id' => $attributes['orders_products_attributes_id']); Di I forget shtg ? (I'm running Paypal Devosc) Quote Link to comment Share on other sites More sharing options...
Pilly Posted April 27, 2006 Share Posted April 27, 2006 Any thanks for previous help. And it has worked. I have another question if anyone could help or point me in the correct direction of what i should be doing. 1. I have an extra address line, how do i incorporate this? 2. Also I wish to add a tracking number after the order has been placed, any ideas on how this should be done? Ive looked at the contributions but none really fit.... Any thoughts? Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted April 27, 2006 Share Posted April 27, 2006 Any thanks for previous help. And it has worked. I have another question if anyone could help or point me in the correct direction of what i should be doing. 1. I have an extra address line, how do i incorporate this? 2. Also I wish to add a tracking number after the order has been placed, any ideas on how this should be done? Ive looked at the contributions but none really fit.... Any thoughts? Which second address line contribution are you running? There are two that I know of. FedEx Automated Labels automatically generates a tracking number, writes it to the database, and includes it in the email sent to the customer. that it automatically sends when you generate a label. If you care at all for FedEx it's an excellent contribution. UPS Order Tracking XML offers real-time tracking for your customers via your site. I use UPS and have found this contribution to be very helpful. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Pilly Posted April 27, 2006 Share Posted April 27, 2006 Using Extra Address Line v1.4.zip http://www.oscommerce.com/community/contri...tra+address+1.4 Ill take a look at the tracking contribs... I dont use fedex or UPS will that make a difference, or can i customise it. Also, Ive tried to make the "new Status / comments" area/table smaller in width but with no luck. It should be easy Im sure.. I am at this moment looking through the code to do this but ive also installed improved order number http://www.oscommerce.com/community/contri...,improved+order I assume this would be easy to incorporate. Quote Link to comment Share on other sites More sharing options...
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.