Printable View
Is there a way in admin to modify order details? For instance how would one delete a line item in an order, or perhaps add an additional item to an existing order, override system price, change quantity, change attributes, etc.?
My store is very new, and already we are getting people phoning in wanting modify their orders.
I don't want to have to edit the database through something like phpMyAdmin.
I couldn't find a contribution listed for editing order details. Have I miss something?
Ron
I have the same question...I this possible?
thanks for any help.
Rob
Doesn't the contribution 'Super Orders' allow you to edit orders?
It should be in the downloads section.
Alex is right...super orders is what you need. It's great. Here's the link:Quote:
Originally Posted by Alex Clarke
http://www.zen-cart.com/index.php?ma...roducts_id=257
I need super order mod as well... but it says 1.3.0, we just got upgraded to 1.3.5.
Any ideas?
I 'think' it works with 1.3.5.
Just testing it out on one of my latest shops now and will report back in the morning. :)
Thanks Alex, anxiously waiting for your results!
I've had a problem importing the sql file to my database.
So have not got Super Order up and running yet. However, I'll try again and post back.
I just added Super Orders and from what I can see, it won't accomplish what I am trying to do:
- Change quantities of items and recalcute order
- Delete items and recalculate order
- Manually add items and recalculate order
Can someone confirm this OR let me know if there is any way to accomplish what I've described above? I really need the ability to truly edit the products that have been ordered.
Thanks,
Jane
Like missjane, this is exactly what I need to be able to do too --
- Change quantities of items and recalcute order
- Delete items and recalculate order
- Manually add items and recalculate order
Is it possible to do this with the latest version of Zen Cart and any add-on modules? Currently I'm reduced to either making the changes by hand on the invoice or asking the client to delete his old order and reinput it.
This thread stopped in Oct. Any one can advise how to edit order without going through database. Superorders orders does not accomplish this and the mod doesn't system to be for 1.3.6
Can someone help.
tks
CC
I need to do these things, as well. When I was running ZC 1.2.7 I used the old Edit Orders module along with Super Orders to do what I needed. The only draw back to Edit Orders was that it wouldn't let you edit attributes, but I would just add in the new item with the correct attrib and then delete the incorrect one. It DID recalculate the order totals, which is crucial.
You can find Edit Orders in the download archives here:
http://www.zen-cart.com/archived_con...s/admin-tools/
I'm now upgrading to 1.3.6 and it doesn't look like Edit Orders has been upgraded.
I'm going to attempt to install it and see if it works in the new regime. I'll post back with results. However, if it doesn't work I don't think I know enough php to fix it.
I have a very small shop and so I can't believe that others don't need to edit orders. I do it constantly!
Thanks for feed back. I tried installing Super order, but its not what I needed. So far I been going to the database and updating manually which is a hassle. I installed the old Edit orders mod and it didn't seem to work on 1.3.6. Well now there is a new release 1.3.7 so dont know if it will work with new version.
tks
The old version of edit orders does infact work.
In the readme file you are instructed to find and replace in admin/orders.php don't use that info. Use the below
all you need to do is find line 770 or...
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
and change the FILENAME_ORDERS to FILENAME_ORDER_EDIT
I also added this just below the above line which links to the order shipment tracking mod if you have it installed:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_TRACK, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_orders_tracking.gif', IMAGE_EDIT) . '</a>');
OK, that's great info! I got it kinda working. I am still having these issues:
- EO is not recalculating the total after products are added. It did this in my previous store version, is there code or some button that will make it do this?
- I want to try to link to EO from SO, rather than from the regular orders page. I think I know what code to add to super_orders.php I just don't know where to add it.
- When on the EO page, the rollover effects of the Admin bar. so I have to click on the Customers link and then I can get back to SO or Orders.
The first is major, the other two are mildly cosmetic but would be helpful. Is anyone else having these issues or have found a way to fix them?
Oh, oh, oh! I just figured out how to integrate EO with SO a little better. (this is big for me since I'm not really a php coder).
I did this on ZC 1.3.6 with SO 2.0 (rev 45) and Edit Orders 1.3:
1) Edit super_orders.php
at line 1193 add this code:
// integrate with Edit Orders
echo '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, 'oID=' . $orders->fields['orders_id'] . '&action=edit', 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', IMAGE_EDIT) . '</a> ';
// end edit
and at line 1253 add this code:
// integrate with Edit Orders
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
// end edit
2) Edit edit_orders.php
find this line (around 555)
<td class="pageHeading" align="right"><?php echo '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action'))) . '">' . zen_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
change to read:
<td class="pageHeading" align="right"><?php echo '<a href="' . zen_href_link(FILENAME_SUPER_ORDERS, zen_get_all_get_params(array('action'))) . '">' . zen_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
I'm using the old edit order mod on 1.3.6 not using SO at all. I made above changes to the old mod still doesn't work for me. When I go into the order there is an edit button, but doens't let you change anything
?????
the changes I posted in my previous posting were for integrating Edit Orders with Super Orders specifically. I believe that all you need to do to get EO working with the regular Orders page is what soapin_mama suggested:
all you need to do is find line 770 or...
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
and change the FILENAME_ORDERS to FILENAME_ORDER_EDIT
I also added this just below the above line which links to the order shipment tracking mod if you have it installed:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_TRACK, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_orders_tracking.gif', IMAGE_EDIT) . '</a>');
Correct the top EDIT button is not the one you use on the ORDERS page you must use the bottom EDIT button.
As for super orders, that's great I don't use it so I can't help in that area.
If you'd like to change the top EDIT button then change line 726 this: FILENAME_ORDERS to this: FILENAME_ORDER_EDIT
that should make the top EDIT button work to go straight to the order edit page.
Well, I wish I could say that this is working for me, but it's not. In adding new products, the attributes are not displayed on the Order details and the totals are not calculated (they reset to zero).
Are there any other solutions to editing orders? This is absolutely crucial to my operation.
Sorry can't help with super orders. Just stand alone edit orders :(
hi all,
In the Downloads section, someone has uploaded a bug-fixed version of Edit Orders and its compatible with the latest Zen Cart. Check it out here! I installed it and its working BUT I didn't yet test the 'Notify Customer' function...
But still one issue though... EO did not display the attribute of one product! This is very important as we need to see also the product that we want to edit or delete...What happen if one particular order having products that has attributes on it and it would be difficult to determine if among the products are the same product but different attributes?! :wacko: ehm, I just noticed that the fixed EO was uploaded by soapin_mama! TQ for the hardwork...:D
Well, there were still a lot of issues to your EO soapin_mama! I used EO together with the built-in orders administration. When we adding a product that has attributes with prices, somehow the EO wont update the price to the existing order and causing the 'sub total' and 'total' to display in $ sign, not the default currency. When I preview the order using the built-in orders admins, attribute is not displayed and the price shown is zero. [ see Image1 ].
forgot to attach the image! :DQuote:
Originally Posted by tajul_ashyqin
Hi guys,
I know you are working hard on this! Just wanted to confirm if the edit orders is working or not at the moment?
Thanks guys!
Best Regards,
Chris
as you can see on my previous posts, we need to fix a lot of bugs...:yes:
Thanks so much, I have just moved over from Cubecart which I have been using for about three years and the option of editing orders was vital, this has really saved my bacon. Tried to install it last night but needed this edit to get it to work.Quote:
Originally Posted by soapin_mama
As usual a great service from the forum - wish I had found Zen sooner!
H
Just checking in to see what the status on this mod is... sounds like just what I need, but also sounds as if there were some bugs. I downloaded the version dated 1/7/07, but looks as if this is the one that still has some issues. Thanks for any info - this would be great to use!
Has anyone else had trouble with edit orders not including tax in the subtotal?
The fix for me, to get edit orders to include Tax (GST Australia) is this:
edit admin/orders.php
Code:Find:
$RunningSubTotal += $products_details["qty"] * $products_details["final_price"];
Replace:
$RunningSubTotal += $products_details["qty"] * ($products_details["final_price"] + ($products_details["final_price"] * ($products_details["tax"]/100)));
Hope this helps someone.Code:Find:
$RunningSubTotal += ($order->products[$i]['qty'] * $order->products[$i]['final_price']);
Replace:
$RunningSubTotal += ($order->products[$i]['qty'] * ($order->products[$i]['final_price'] + ($order->products[$i]['final_price'] * ($order->products[$i]['tax'] / 100))));
Reuben
Issues that I can see with this contrib are:
- defaults to ex tax price
- if you change price to incl. tax price during edit, you get incorrect final_price in orders_products_table
- doesn't observe specials
Is anyone else having these problems with EO?
Reuben
I noticed also that Edit Orders does not deduct funds from a customer's gift certificate if you modify the gift certificate amount from the edit orders window.
Anyone got this module work with stock by attribute and group discount?
Thanks!
I installed this mod yesterday. Worked perfect. I then installed the Stock by Attribute mod and now Edit Orders does not work. Hopefully someone knows how to fix this?Quote:
Originally Posted by mkm
Anyone got this module work with stock by attribute and Super Orders? I install this mod and it won't work at all. Using Zen Cart 1.3.7. If anyone has this working inlighten me please.:blush:
I am getting the following error with the Edit Order mod.
Quote:
Parse error: parse error, unexpected $end in C:\Program Files\EasyPHP 2.0b1\www\Shop\admin\edit_orders.php on line 1312
Quote:
require(DIR_WS_INCLUDES . 'application_bottom.php');
?>
One problem I have with this mod....It doesn't show me the customer credit card number so I can actually process the order. It shows me the last 4 but that doesn't exactly help, since I only get sent the middle digits in email. So where do I find the credit card number now?
I am still having the same problem..Quote:
Originally Posted by Darkwander
Anyone have any ideas?
Darkwander,
I have had the same issue but at line 929. ( I know that does not solve the problem). I also noted that that file Orders.php does not have that many lines
I have been back through my files this morning doing a compare and removing several mods and agree it does seem to be this mod causing the problem. Originally it seemed to fall over when adding a product with attributes, now it fails to get to the first page.
Have you had any joy?
MG
p.s. frogster, Khopek agree it relates to stock by attributes as my compare software pulled all those elements out of the orders.php file I had.
Nope, i just removed the mod..Quote:
Originally Posted by MikeyG
Anyone got this working yet?
I am guessing that everyone who is seeing this error is running PHP 5. The problem is due to short open tags.Quote:
Originally Posted by Darkwander
edit_orders uses "short open tags" in many places. This is the style of enclosing PHP code in "<? ... ?>" instead of "<?php ... ?>". Short open tags have been deprecated in PHP 5.
There are two possible solutions:
1) Edit the php.ini file on the server and set "short_open_tag" to "On". This will allow the use of the tags in all PHP files on the server.
2) Edit admin/edit_orders.php to change all "<? " tags to "<?php ". Here is a diff that shows where the changes need to be made.
Hopefully this will work for everyone. Good luck.Code:772c772
< <?
---
> <?php
839c839
< <td align='center' valign='top'><br><a href="<? print $PHP_SELF . "?oID=$oID&action=add_product&step=1"; ?>"><u><b><font size='3'><?php echo TEXT_DATE_ORDER_ADDNEW; ?> </font></b></u></a></td>
---
> <td align='center' valign='top'><br><a href="<?php print $PHP_SELF . "?oID=$oID&action=add_product&step=1"; ?>"><u><b><font size='3'><?php echo TEXT_DATE_ORDER_ADDNEW; ?> </font></b></u></a></td>
917c917
< <? if($CommentsWithStatus) { ?>
---
> <?php if($CommentsWithStatus) { ?>
919c919
< <? } ?>
---
> <?php } ?>
960c960
< <?
---
> <?php
983c983
< <? if($CommentsWithStatus) { ?>
---
> <?php if($CommentsWithStatus) { ?>
987c987
< <? } ?>
---
> <?php } ?>
1011c1011
< <?
---
> <?php
1181c1181
< <?
---
> <?php
Andy
I think I found another bug. The instructions in the readme.txt say that the "details" button should take you to the old order description screen while the "edit" button should take you to the new screen. That didn't match the behavior I was seeing. Both buttons were taking me to the new edit screen.
I changed the instructions in the readme.txt a little and things worked as expected. Basically the first search and replace has you change "FILENAME_ORDERS" to "FILENAME_ORDER_EDIT". I am pretty sure this is wrong. I changed it back to FILENAME_ORDERS and things seemed to work as expected. I haven't tested that modification throughly though. Caveat emptor.
The readme.txt should read:
Code:1) This add the "Details" button - see explanations below:
FIND
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
REPLACE WITH:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_details.gif', IMAGE_DETAILS) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
this mod has alot of problem but no choice.. there is only 1 zen cart mod we hav here....
unless some 1 willing to contribute the perfect 1 :)
Whoever makes this mod tidy will be a popular person!
Any solutions to this one yet? Such a vital piece of the puzzle. I have to edit all orders before they even can be authorized because of our impossible shipping variables. We're working on learning a bit more about zen cart before we decide to fix edit orders or write a new one. Any help is appreciated!
I'm in exactly the same boat. I need to edit orders, quantities, attributes and shipping costs at the very least. I'll be watching this thread in case anyone comes up with a solution. If I ever get my php skills (currently non-existing) up to snuff, I'll do my best. But that'll take a loooong time. :lookarounQuote:
Originally Posted by thoseguys26
I too need this feature!
I installed Edit Orders 1.1 mod yesterday and it works for me for the most part, however it won't send email after you edit the order.
There is no 'edit' button either. I have to click on 'details', then have to click 'back', then click on 'details' again before I get to the edit screen.
I wish I knew how to fix it, as there is ALWAYS someone wanting to change their order!
TLC
Also installed the Mod and having tax problems.
Besides going to ex tax prices the tax for the shipping is not calculated.
Another problem is with adding products.
The added product defaults to english while the default language for the shop is dutch.
I just want to be able to edit an order for a customer after the order placed and CC info captured. NOT READ 5 PAGES OF BS ABOUT WHETHER IT WORKS OR NOT IN WHAT VERSION
:blink: ElSlozzo, calm down.
The newest version has no bugs that I am aware of. It should fix all your problems. See my signature to download it. Its free, just change all the options to the free ones and go through the checkout.
Enjoy, and go do something to relax! :D
Hi all. This is labraxmauler from Spain. I'm new to the forum.
I recently downloaded and installed Edit Orders 2.1 from srturner47's website, but for some reason I can't manage to make it work. I can edit orders (add & modify products with their attributes) but once I make a single modification, my order total price resets to "0.00". There's no way I can change it once I start editing orders. Moreover, this "0.00" order total stays there when I go to Admin > Customers > Orders.
However, if I go to Admin > Reports > Customer-Order totals I can see the real order amount.
Any ideas about where the mistake is and how to solve it?
My Zen Cart version is the latest available, as stated by the "Check for updates" tool.
Thank you very much for your help.
I downloaded Edit Orders 2.03 from http://www.zencartmod.com/index.php?...&products_id=3 and its work OK for me.
Is there an option to enable the order changes also for the customers? I need it for one of my clients.
alto: Not sure what you mean here, but the customers won't be able to edit their orders if their credit card has already been processed. Otherwise they should be able to edit items in their own shopping cart no problem already.
Hi everyone. Thanks for making this mod available. I followed the instructions exactly but get a "syntax error" at line 854. Any help would be appreciated!
Is the error happening on orders.php or edit_orders.php? Does the error give you any more information? Are you using v2 from my signature?
nice job. Congrats
I made minor changes to fit my Mall application (multiple stores in the same site)
I have come across a problem when updating orders. The problem is linked to a product that has an attribute. The item attribute doesn't have a +/- in the price change box. It is just blank. I believe that this is part of the problem. I am not sure exactly how to fix this. I have listed the error code below.
the 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '133'' at line 5
in:
[update zen_orders_products_attributes set products_options = 'Size', price_prefix = '', options_values_price = '91.8400', products_options_values = '26" x 15'' where orders_products_attributes_id = '133';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Thank You
Paul
i've install the latest version but customers are still not notified when orders are changed
I've install the v2.0 editorder. Once i edit the order, the shipping amount does not include in the total. Is there a way the shipping amount could be recalculated? Also during edit order, can admin change the method of shipping?
Is there any more feedback on editorder2?
I've been searching the forum for hours and I'm not sure sure where to look - apologies in advance if it's been asked and answered before, if someone could point me in the right direction, I would be grateful.
I'm looking for something that will let us order customers orders:
- change customer details (and point to the right customer as I can do in super orders)
- let me add and remove products
- calculate the shipping accordingly (or at least let me add it correctly)
- recalculate the tax correctly (including shipping and low order fee) when appropriate (some customers are tax exempt)
At the moment we're having to do manual invoices any time something changes as the totals are all wrong.
Thanks for your help
To use the old order edit, in my ZC Ver 1.3.8, you have to modify line # 901, which looks line this...
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
As in the previous post, change FILENAME_ORDERS to FILENAME_ORDER_EDIT
Does "edit orders v2" work with super orders ?
ended up using
http://www.zen-cart.com/index.php?ma...roducts_id=444
however using this removed the approval code sent back from the bank, so the following changes were made to orders.php
Code:This is almost the same except the details image, this keeps the approval code in the invoice
Find:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
Replace With:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_details.gif', IMAGE_DETAILS) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
this is the part which allows editing of the order
Find:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
Replace With:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
I have the same exact problem.. been looking everywhere but haven't found a solution. I noticed this after moving my site to a new webhost, but I'm not sure if that's where the problem is, since I rarely use the edit feature.Quote:
Originally Posted by Pablo1719
any ideas?
thanks!
i just found it easier to go into the database and change the order details for the customer....
only needed to change 1 product, but worked for me :D
I have just downloaded and installed Order Edit 2.03 on my Zencart v1.3.9h.
However, whenever I want to add a product to the person's order I am returned to the admin homepage.
I click on "Add Product" and it send me straight back to the home page.
Any ideas why?
I also see this error on I.E
Quote:
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C)
Timestamp: Tue, 2 Nov 2010 08:44:12 UTC
Message: 'null' is null or not an object
Line: 17
Char: 7
Code: 0
URI: https://rebeltech.co.za/***/edit_ord...67&action=edit