Edit Orders v4.0 Support Thread

Thank you!

lat9:

Now available for download.

Just updated my EO on Zen 155f. Very easy and straightforward update and the new version has some very nice new features. Thanks

One strange thing!

My tax is 7.7%. If I use "as entered" and enter a price of 107.7 in Unit Price (Gross) it then calculates Unit Price (Net) as 100.6542 instead of 100. When I press "update" it recalculates Unit Price (Gross) as 108.404573 instead of the correct 107.7.

Which implies it is using a tax rate of 7% not 7.7% for the net of tax calculation but using the correct 7.7% for the gross price calculation!

If I enter 100 in Unit Price (Net) then the gross price is OK.

marton_1:

One strange thing!

My tax is 7.7%. If I use "as entered" and enter a price of 107.7 in Unit Price (Gross) it then calculates Unit Price (Net) as 100.6542 instead of 100. When I press "update" it recalculates Unit Price (Gross) as 108.404573 instead of the correct 107.7.

Which implies it is using a tax rate of 7% not 7.7% for the net of tax calculation but using the correct 7.7% for the gross price calculation!

If I enter 100 in Unit Price (Net) then the gross price is OK.
I'm looking into this right now.

lat9:

I'm looking into this right now.
... and have created a GitHub issue to track the change required. I should have the change uploaded real-soon-now.

lat9:

... and have created a GitHub issue to track the change required. I should have the change uploaded real-soon-now.

great! :smile:

... and am now preparing to release v4.4.2. The changes required can be found here (change to /YOUR_ADMIN/edit_orders.php).

lat9:

... and am now preparing to release v4.4.2. The changes required can be found here (change to /YOUR_ADMIN/edit_orders.php).

Thanks, change works fine :)

marton_1:

Thanks, change works fine :)
Thanks for the confirmation! The update's on its way.:smile:

Update: Just submitted to the plugin moderators for review; I'll post back when it's available for download.

 This release contains changes associated with the following GitHub issues:

#122: Correct handling for non-integer tax rates
#123: Simplify and center the top order-navigation.

lat9:

Thanks for the confirmation! The update's on its way.:smile:

Update: Just submitted to the plugin moderators for review; I'll post back when it's available for download.

 This release contains changes associated with the following GitHub issues:

#122: Correct handling for non-integer tax rates
#123: Simplify and center the top order-navigation.
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1513

Hi,
My store is using Zen Cart v1.5.5f and Edit Orders Version 4.1.4 and only recently we have had the problem that when the shipping is increased the international order fee remains the same? We did have someone inexperienced working on the site briefly. Could he have changed a setting that would cause this problem?

Jeff Holden:

Hi,
My store is using Zen Cart v1.5.5f and Edit Orders Version 4.1.4 and only recently we have had the problem that when the shipping is increased the international order fee remains the same? We did have someone inexperienced working on the site briefly. Could he have changed a setting that would cause this problem?
You're using a woefully old version of EO (v4.4.2 was just released). There have been many, many, corrections and interface changes to EO over the past 5 1/2 years.

I suggest that you update.

I am getting this error when i try to update order,
PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM products WHERE p.products_id = '1160' in /var/www/xxxx/xxxxx/xxxx/xxxx/xxxxx/xxxxx/db/mysql/query_factory.php on line 120
yes i know i am using a older version, with super orders and ty package tracker

nevermind fixed it with the bug fix

order total modules not totaling on edit screen

jimmie:

order total modules not totaling on edit screen

Are you still using that moldy-oldy (and no longer supported) version of EO?

If so, please upgrade. If not, please identify the order-total modules currently being used on the site.

i am using version 4.1.4 cause i am using zencart 1.51 with super orders, readme in super orders said to not replace the orders file from edit orders or ty package tracker
order_total modules
optional insurance module
paymentmodule fee
store credit

jimmie:

i am using version 4.1.4 cause i am using zencart 1.51 with super orders, readme in super orders said to not replace the orders file from edit orders or ty package tracker
order_total modules
optional insurance module
paymentmodule fee
store credit
Understood. Unfortunately, as I mentioned before, that version of EO is no longer supported.

Hi,

I have a sore running ZC 1.5.5e, with EO 4.4.2 and Super Orders installed. If an order is split and the child order is opened in EO and anything to do with pricing is edited, then updated, the a blank page coating an error message is generated. The log file shows the following:

[02-Sep-2019 15:27:59 Australia/Sydney] Request URI: /zc_admin/edit_orders.php?page=1&oID=6554&action=update_order, IP address: xxx.xxx.xxx.xxx
#1 trigger_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php:273]
#5 editOrders->initializeOrderShippingTax() called at [/home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php:155]
#6 editOrders->eoInitializeShipping() called at [/home/xxxxxx/public_html/zc_admin/edit_orders.php:359]

[02-Sep-2019 15:27:59 Australia/Sydney] PHP Fatal error: 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 'WHERE orders_id = 6554
LIMIT 1' at line 3 :: UPDATE zen_orders
SET shipping_tax_rate =
WHERE orders_id = 6554
LIMIT 1 ==> (as called by) /home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php on line 273 <== in /home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 167

If an additional product is added to the child order, or removed, then editing pricing works correctly.

Would appreciate any help on this.

@donw, a couple of things you could do:

1. Install Report All Errors (https://www.zen-cart.com/downloads.php?do=file&id=1792) and then set Configuration->Logging->Report All Errors Admin to IgnoreDups and Backtrace on Notices to true). That will help me to determine some of what's going on.
2. Enable Edit Orders' debug (Configuration->Edit Orders->Debug Action Level) to 1.

Create a test order, split it and then attempt to edit it. I'll be 'looking for' two types of logs:

1. /logs/myDEBUG-adm-*.log ... files that were created during (a) the initial EO 'view' of the order and (b) the one that includes the fatal error.
2. /logs/edit_orders/debug_edit_orders_xxx.log, where xxx is the split order being edited.

I'll PM you my direct email address, as those logs (especially the edit_orders one) can get pretty big.