Edit Orders v4.0 Support Thread

michaelchu:

Any chance this can be made fully compatible with 1.5.4 soon?
Edit Orders 4.1.4 should work in Zen Cart 1.5.4 for most stores. The only challenge is applying the required patches to core Zen Cart files (DO NOT simply overwrite the Zen Cart 1.5.4 files). If installing Edit Orders 4.1.4 in a new store, don't forget to sift through this thread for bugfixes against Edit Orders 4.1.4 and apply them (when applicable).

NOTE: There is a BETA release in development (includes bugfixes, enhancements, a new installer, and the list gos on). The new installer should hopefully simplify "patching" core Zen Cart files for most stores. There is no ETA at this time for a future release.

Hello everyone!
I'm using Edit Orders 4.1.4 on a clean ZC 1.5.3 installation with no other modules.
I'm having an issue I seem not to find the answer for: when I edit an order I make all the necessary changes and then I save it and it's ok. But then if I go to a product page in admin the prices are wrong, that is, Products Price (Net) and Products Price (Gross) are the same, even if it was selected a Tax Class from this dropdown menu. There's no way to make the two prices different, I have to logout from admin and the log in again, so they work correctly.
I have this issue only when I previously access the edit order page, can someone help me?
Thanks a lot!

sporty:

... When I edit an order I make all the necessary changes and then I save it and it's ok. But then if I go to a product page in admin the prices are wrong, that is, Products Price (Net) and Products Price (Gross) are the same, even if it was selected a Tax Class from this dropdown menu. ...
I would not rely on the (Gross) calculations found on the page for editing products. The current Zen Cart administrative interface only adds tax to the (Net). The tax calculation is only based upon a single location (usually the store location; not customer locations). So basically (Gross) is not accurate for all transactions as different tax rates may apply to different customers (and purchases).

If you really, really, really want... Can try the following "bugfix" to force the tax calculation to revert to the store location (instead of the last customer order edited). Edit "/admin/edit_orders.php" adding the line in red (around line 1755):

</html>
<?php
unset($_SESSION['customer_id']);
require(DIR_WS_INCLUDES . 'application_bottom.php');

thank you lhungil!
it works now, the prices are correct!

sporty:

... it works now, the prices are correct!
Thank You for reporting the proposed fix worked in your environment :)

Using Zen Cart 1.5.1. Installed EO 4.1.2

When editing an order, then selecting add a new product if the product has drop-down attributes, it displays only the first option...no drop-down. Check-box attributes display correctly as check boxes.

The cart is highly customized but I don't believe any affect the attribute controller.

jeking:

Using Zen Cart 1.5.1. Installed EO 4.1.2 ...
Attribute handling has been overhauled since version 4.1.2. Newer versions of Edit Orders also automatically repair damage to the attribute options sometimes caused by other modules (removing entries in configuration under gid=0). This damage can affect the display of attributes (among other things).

Please install and try adding the product using the current version of Edit Orders (4.1.4).

I am getting ready to install this on a fresh install of 1.5.4. Is there a list of things that need to be done differently than the packaged instructions so I don't have to read through the 69 pages of this thread? I wish I had the time, but I do not.

Thanks,
Christy

christymreed:

I am getting ready to install this on a fresh install of 1.5.4. Is there a list of things that need to be done differently than the packaged instructions so I don't have to read through the 69 pages of this thread?

Not sure you'd need to go through ALL 69 pages.. but I digress..

So in short, you'd like someone else to review the support thread for any fixes and modifications required to be made to Edit Orders for compatibility with Zen Cart v1.5.4 that probably have already been posted here in the support thread, and put that in a summary post for you??

christymreed:

I wish I had the time, but I do not.That makes two of us.. Hopefully someone less busy than the busy people here on this forum can post the information you are looking for..

Dear Zenners,

The last 2 days I've been reading through the forum pages to figure out why I can't get Edit Orders to work.
The problem is (I've read about multiple users having this issue) that when I create an order and edit it with Edit Orders (add or remove an item) the subtotal amount displays the wrong price (see example image)

In the image you can see that I have only 1 product left which costs € 0,94 the subtotal states € 2,60

The store is recently upgraded from ZenCart 1.3.9h to 1.5.1 edit orders was running fine in 1.3.9h also.
When the store was upgraded to 1.5.1 I also upgraded Edit Orders to version 4.1.4 ( I read in the support thread that there where issues with updating off the subtotals in Edit orders 4.0)

I only have a view other modules installed:

Testimonial Manager Version 1.5.4
Easy Populate For ZenCart v1.5.x
Sales Report 3.1.0

In the order totals I have the following installed:

Code voor groepsbestellingen ot_coupon 280
Groepskorting ot_group_pricing 290
Toeslag kleine ordergrootte ot_loworderfee 400
Verzenden ot_shipping 200
Subtotaal ot_subtotal 100
BTW ot_tax 300
Totaal ot_total

When I enable the Debug log in Edit Orders I get no error messages.

I also uninstalled Edit orders and installed it again.

I'm really stuck on this and really need to edit my orders, I'm hoping anyone can point me in the right direction :(

Hello. I'm having a problem installing edit orders. I downloaded the latest version 4.1.4. and my store is zc 1.5.0. I did a clean install last June and updated the database from 1.3.9 at that time. No issues with the store since then.
Server OS: LINUX .12.35 14186451
PHP version: 5.2.17 (ZEND: 2.20)
MySQL 5.5.40-36
HTTP Server: Apache
Add-ons: Image Handler 4_v4_0, ckeditor, backup_MySQL_plugin_v5

I followed the instructions in the read me and uploaded all the files under "modified core files" and "new files" and checked to see they were all there with the proper structure. I logged into the admin and then uploaded the install files. When I then go to the admin page and click on a link (admin home) I get a page that says "Warning An error occurred. Please refresh the page and try again". After that, I am stuck with that page and cannot get back into the admin. The only thing I can do at that point is delete files via ftp to access the admin again.

This is the debug code I am getting:
[CODE][28-Feb-2015 16:43:44] PHP Fatal error: 1146:Table 'mendo11d_organic1. configuration' doesn't exist :: SELECT configuration_value FROM configuration WHERE configuration_key = 'EO_VERSION' in /home4/mendo11d/public_html/includes/classes/db/mysql/query_factory.php on line 101 [\COD]

Seems like it might be something with the database.
I can post more details if needed. Any help would be greatly appreciated.

Check your "/admin/includes/configure.php" file. In particular check DB_PREFIX to see if it contains a space (should not contain any spaces).

lhungil:

Check your "/admin/includes/configure.php" file. In particular check DB_PREFIX to see if it contains a space (should not contain any spaces).

Hi. Thank you for the quick response. Here is what I have in admin/includes/configure.php :
define('DB_PREFIX', ' ');

mendo1:

Hi. Thank you for the quick response. Here is what I have in admin/includes/configure.php :
define('DB_PREFIX', ' ');

And so when the space (space only) is removed to have:

define('DB_PREFIX', '');

Is the problem resolved?

That absolutely did the trick! Edit orders seems to be working fine now. What one little space in the wrong place can do. Thanks very much everyone!

When I click to update the order after editing, I get a blank page.

Logs say:

[09-Mar-2015 12:26:48] [09-Mar-2015 12:37:45] PHP Fatal error:  Call to undefined function  validate_for_category() in /home/sjenkins/public_html/shop/saffire_admin/includes/functions/extra_functions/edit_orders_functions.php on line 331

Here's what is in that section:

		$allow_for_category = validate_for_category($product_id, $coupon_id);
		$allow_for_product = validate_for_product($product_id, $coupon_id);
		//    echo '#'.$product_id . '#' . $allow_for_category;
		//    echo '#'.$product_id . '#' . $allow_for_product;
		if ($allow_for_category == 'none') {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === true) {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === false) {
			if ($allow_for_product === 'none') return false;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		return false; //should never get here
	}
}

Any ideas?

Sorry, found my answer: http://www.zen-cart.com/showthread.php?200407-Edit-Orders-v4-0-Support-Thread&p=1242779#post1242779

abcisme:

When I click to update the order after editing, I get a blank page.

Logs say:

[09-Mar-2015 12:26:48] [09-Mar-2015 12:37:45] PHP Fatal error: Call to undefined function validate_for_category() in /home/sjenkins/public_html/shop/saffire_admin/includes/functions/extra_functions/edit_orders_functions.php on line 331

> 
> Here's what is in that section:
> 
> ```
		$allow_for_category = validate_for_category($product_id, $coupon_id);
		$allow_for_product = validate_for_product($product_id, $coupon_id);
		//    echo '#'.$product_id . '#' . $allow_for_category;
		//    echo '#'.$product_id . '#' . $allow_for_product;
		if ($allow_for_category == 'none') {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === true) {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === false) {
			if ($allow_for_product === 'none') return false;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		return false; //should never get here
	}
}

Any ideas?

ZC 1.5.3
EO 4.1.4
SO 4.0.5

Tax doesn't seem to be recalculating at all. I've tried clicking update.. I've tried just hitting enter. Tax never adjusts.

100 ## Sub-Total ot_subtotal
102 ## Discount Coupon ot_coupon
103 ## Group Discount ot_group_pricing
200 ## Shipping ot_shipping
291 ## Combination Discounts ot_combination_discounts
292 ## Combination Discount ot_better_together
299 ## Signature Upon Delivery ot_insurance
300 ## Tax ot_tax
312 ## Gift Certificates ot_gv
999 ## Total ot_total

We are experiencing this same situation as carlwhat.

Tax is being deleted from some orders and the tax is not being recalculated on others.. Would love to know if we have something installed in common.

carlwhat:

first off, i want to say that this module is shareware... i never paid for it, so the idea that we can make demands on the developer seems a bit lame to me...

i stand by my previous comment about deleting and re-adding items in the orders products table. no developer can for-see everything going on in other users implementations. but as i said previously i do not agree with that decision.

with the comments above, i am experiencing the same situation. i have ot_tax records from the orders_total table getting deleted; and adding products after a coupon has already been established does not re-calculate the coupon value nor does it accurately recalculate the tax.

i have yet to really dig into these issues, but i no doubt will. i'm sure there were reasons why this module was designed the way that it is, but unfortunately for me, there are SO many problems that i have a difficult time with recommending it. perhaps i will find an easy fix, but TAX not getting calculated correctly? discount coupons that do not update when you add new products?

i know editing an order affects a number of different tables, but frankly i'm really at a loss on this code. and i do not remember this level of problems with the super-orders module; but hey that was a long time ago when i implemented that.

So far what I've come up with is that is has to do with the settings of ot_coupon and ot_group_pricing. Is there some specific setting that these should use?

Here's what I have for settings:

Discount Coupon

This module is installed
true

Sort Order
102

Include Shipping
false

Include Tax
false

Re-calculate Tax
Standard

Tax Class
--none--
**
Group Discount**

This module is installed
true

Sort Order
103

Include Shipping
false

Include Tax
false

Re-calculate Tax
Standard

Tax Class
--none--

My order totals are incorrect when trying to edit the order:

Sub-Total: CDN $64.91
$10 Coupon: -CDN $10.00
3% Discount - 3%: -CDN $1.69 (Should be $1.65 [$64.91 - $10 coupon = $54.91 * .03 = $1.65])
Shipping: $12.11
13% Tax (ON): CDN $8.50 (includes tax on shipping)
Total: CDN $74.88 (Should be $73.87.. no idea where it is getting $74.88, since the numbers it's giving me add up to $73.83??)

Any help would be greatly appreciated.