Edit Orders v4.0 Support Thread

[iqbal007]

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

[laurelsstitchery]

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

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

[lat9]

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

[frank18]

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

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

[moosesoom]

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

[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:

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

[lat9]

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.

[rued]

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. :)

[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...

[lat9]

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.