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:

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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:

Attachment 14412
Attachment 14413


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

Attachment 14414

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

And now the "surprise":

Attachment 14415

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:

Code:

---

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

Code:

---

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

---

Else it trows an error like:

Quote:

---

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

---

Quote:

---

Originally Posted by 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:

Code:

---

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

Code:

---

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

Quote:

---

Originally Posted by 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...

Quote:

---

Originally Posted by 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.