Edit Orders v4.0 Support Thread

Hello Everybody.
how to add new inputs and can be displayed on the packing slips and invoices?

I want to add a phone number section that can be edited on "the delivery section"
so the phone number into a billing and shipping is different

What files should I change / add?

thx :smile:

lat9:

That's a known issue. See the quoted correction.

Just had this issue too and fixed it using your instructions - thanks! :)

No problem, there's a bunch of pages to be read to find that!

lat9:

No problem, there's a bunch of pages to be read to find that!

Hot tip for all who installed this mod (and other plugins):

Simply subscribe to this thread with instant email notifications and you won't be left in the dark. All you need to do is read the latest updates :smile:

To subscribe click on 'Thread Tools' on the header bar of this thread.

Hi everybody,
ZC 1.5.1 + Super Orders 4.1.4

I have no problems in VAT calculation when inserting new orders, but problems come while editing exixting orders.
Here's some exmple pic:

This is the order right after its creation:

1 item, net price is 1.64, gross price is 2.00, VAT is 22%, gross shipping is 7.00, net shipping is 5.7377

Following is the same order after editing it by modifying gross shipping to 8,00

Total is ok, but not VAT (it should be 1.80, not 2.12)

And now the "surprise":

I just put net shipping in shipping box instead of gross shipping: now VAT is OK, but Total is wrong.

Any idea about that?
Thanks in advance

Seems like there is a bug in Edit Orders 4.1.4 in the file admin/includes/functions/extra_functions/edit_orders_functions.php

Line 1025 - 1028:

				$check = $db->Execute(
					'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` ' .
				 	'WHERE `p`.`products_id` = \'' . (int)$query->fields['products_id'] . '\''
				);

Which probably instead should be (a p isn't defined):

				$check = $db->Execute(
					'SELECT `products_quantity` FROM `' . TABLE_PRODUCTS . '` ' .
				 	'WHERE `products_id` = \'' . (int)$query->fields['products_id'] . '\''
				);

Else it trows an error like:

PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM products WHERE p.products_id = '32' ==> (as called by) /public_html/admin/includes/functions/extra_functions/edit_orders_functions.php on line 1028 <== in /public_html/includes/classes/db/mysql/query_factory.php on line 155

rued:

Seems like there is a bug in Edit Orders 4.1.4 in the file admin/includes/functions/extra_functions/edit_orders_functions.php

Line 1025 - 1028:

			$check = $db->Execute(
				'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` ' .
			 	'WHERE `p`.`products_id` = \'' . (int)$query->fields['products_id'] . '\''
			);

> 
> Which probably instead should be (a p isn't defined):
> ```
				$check = $db->Execute(
					'SELECT `products_quantity` FROM `' . TABLE_PRODUCTS . '` ' .
				 	'WHERE `products_id` = \'' . (int)$query->fields['products_id'] . '\''
				);

Else it trows an error like:
Known issue; see post #577.

lat9:

Known issue; see post #577.

Hehe ... this tread is 59 pages, I surely didn't bother or take time to go trough it (as search didn't give me anything for some reason), I just fixed it. :)

Just wanted to ask a rather basic question...

I noticed that older versions of Edit Orders installs data into the SQL - but when going through the files of Edit Orders 4 I don't see anything that adds new columns or tables. I assume this version doesn't require SQL changes for installation? Or am I missing it...

yaseent:

Just wanted to ask a rather basic question...

I noticed that older versions of Edit Orders installs data into the SQL - but when going through the files of Edit Orders 4 I don't see anything that adds new columns or tables. I assume this version doesn't require SQL changes for installation? Or am I missing it...
v4.1.4 installs some items in the configuration menu (Configuration->Edit Orders) via the file /YOUR_ADMIN/includes/classes/eo_plugin.php.

lat9:

v4.1.4 installs some items in the configuration menu (Configuration->Edit Orders) via the file /YOUR_ADMIN/includes/classes/eo_plugin.php.

Thanks :)

Hi TIA.
My store is using text attributes with multiple lines of text, when editing a order the attribute looses the line breaks and combines into one line without spaces, is there any fix for it to keep the formatting?

ShopVille:

Hi TIA.
My store is using text attributes with multiple lines of text, when editing a order the attribute looses the line breaks and combines into one line without spaces, is there any fix for it to keep the formatting?
Try changing the "text" input box into a "textarea" (/admin/edit_orders.php). Most browsers strip newlines and extraneous spaces from "text" input boxes.

lhungil:

Try changing the "text" input box into a "textarea" (/admin/edit_orders.php). Most browsers strip newlines and extraneous spaces from "text" input boxes.
Thanks can you help with where in the file i have to edit?

ShopVille:

Thanks can you help with where in the file i have to edit?
Change the field type of your text attributes to a textarea..

DivaVocals:

Change the field type of your text attributes to a textarea..

I only have the following options:
Dropdown
Text
Radio
Checkbox
File
Read Only

ShopVille:

I only have the following options:
Dropdown
Text
Radio
Checkbox
File
Read Only

Not sure if there is a "fix" for your issue.. As lhungil pointed out "Most browsers strip newlines and extraneous spaces from "text" input boxes.". Not an issue caused persay by Edit Orders..

DivaVocals:

Not sure if there is a "fix" for your issue.. As lhungil pointed out "Most browsers strip newlines and extraneous spaces from "text" input boxes.". Not an issue caused persay by Edit Orders..
Right not caused by Edit Orders but only happens when editing since the browser will strip the lines

After looking a bit further, there is a real easy option to allow product attributes with user entered multiline text. So I was wrong earlier, no need to edit "/admin/edit_orders.php" (it has been awhile since I have looked through the product attribute display code in Zen Cart).

Zen Cart out of box supports changing individual "text" option names (attributes) to use a textarea HTML element instead of an input HTML element (with a type attribute of text). As Edit Orders uses almost the exact same code as a stock Zen Cart product page (minor modifications for handling of downloads), turning this option on for the "text" option name in Zen Cart will also switch to using a textarea HTML element.

How to enable support for multiline "text" product options:

1. Log into the Zen Cart administrative interface.
2. Navigate the menu's to "Catalog" -> "Option Name Manager".
3. Find the option name (option type: text) and click the associated "edit" button.
4. Change "rows" to the number of rows to display (for multiline input must be greater than 1).
5. Click the "update" button.

NOTE: Tested and verified to work under Zen Cart 1.5.1+ and Edit Orders 4.1.3+ (probably earlier as well - but these are my current test environments. The setting is documented in the wiki (Google FTW).

lhungil:

After looking a bit further, there is a real easy option to allow product attributes with user entered multiline text. So I was wrong earlier, no need to edit "/admin/edit_orders.php" (it has been awhile since I have looked through the product attribute display code in Zen Cart).

Zen Cart out of box supports changing individual "text" option names (attributes) to use a textarea HTML element instead of an input HTML element (with a type attribute of text). As Edit Orders uses almost the exact same code as a stock Zen Cart product page (minor modifications for handling of downloads), turning this option on for the "text" option name in Zen Cart will also switch to using a textarea HTML element.

How to enable support for multiline "text" product options:

2. Log into the Zen Cart administrative interface.

3. Navigate the menu's to "Catalog" -> "Option Name Manager".

4. Find the option name (option type: text) and click the associated "edit" button.

5. Change "rows" to the number of rows to display (for multiline input must be greater than 1).

6. Click the "update" button.

NOTE: Tested and verified to work under Zen Cart 1.5.1+ and Edit Orders 4.1.3+ (probably earlier as well - but these are my current test environments. The setting is documented in the wiki (Google FTW).

This is how i'm set up it keeps the line formatting in the order, however when editing it displays as one line