Editing order details

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?main_page=product_contrib_info&products_id=444

however using this removed the approval code sent back from the bank, so the following changes were made to orders.php

	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>');

Pablo1719:

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.

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.

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

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_orders.php?page=1&oID=5467&action=edit