Edit Orders v4.0 Support Thread

izar74:

Hi all,

i've installed a new zen cart 1.5.4 and add the Edit Order module along with Rewar point, again :P. It works well except for one little thing, here two images to explai it simly:
Here before i modified the order:
Attachment #15114

Here after the edit.
Attachment #15115

The last line "Punti guadagnati" (Earned Reward Points) got the € symbol even if i completely ignore that field (i just modified from 3 to 5 the shipping cost).
Is there a way to avoid this?

It's a known issue with Rewards Points.. I think there is a fix for this posted on the Rewards Points support thread.. not really an Edit Orders issue..

DivaVocals:

It's a known issue with Rewards Points.. I think there is a fix for this posted on the Rewards Points support thread.. not really an Edit Orders issue..

Hi Diva :P,

i found the culprit, in \admin\edit_orders.php line 432 is:

$order_total['text'] = $currencies->format($order_total['value'], true, $order->info['currency'], $order->info['currency_value']);

tell me if i get it right, basically It take the order_total['value'] and put it in the order_total['text'] after formatting it with currencies.

Would something like ```php
$order_total['text'] = $order_total['value'];

Thanks

izar74:

Hi Diva :P,

i found the culprit, in \admin\edit_orders.php line 432 is:

$order_total['text'] = $currencies->format($order_total['value'], true, $order->info['currency'], $order->info['currency_value']);

> 
> tell me if i get it right, basically It take the order_total['value'] and put it in the order_total['text'] after formatting it with currencies.
> 
> Would something like ```php
$order_total['text'] =  $order_total['value'];
``` do the same but without formatting?
> 
> Thanks
Nope.. The fix would NOT be in the \admin\edit_orders.php file at all.. because like I said.. It's not an **Edit Orders issue**.. It's a **Rewards Points issue**..

DivaVocals:

Nope.. The fix would NOT be in the \admin\edit_orders.php file at all.. because like I said.. It's not an Edit Orders issue.. It's a Rewards Points issue..

Sorry Diva, maybe i'm a little odd buy i cannot understand how this error could be related to Reward Point... It ìs generated when i edit an order using Edit order...
Maybe I explained bad..

1. I put ad order
2. I went to admin and edited the order using Edit order to change the shipping price
3. After udating i saw that in the field of the points there was a "€" more" , added by the editing. Checking the database i found that the Value field was unchanged, but the TEXT field had a "€" (i'm referring to the order_total table in the database).

The thing that i'm traying to say is that the Reward point module is not involved after i put the order, all the admin part regards the edit order module. It is the Edit Order module that Edit the fields and modified it... or my logic is wrong?

By the way thanks for the advice

The issue you are reporting is caused by the way Reward Points was implemented. This is not a bug in Edit Orders.

There is a long dicsussion about the issue in the Reward Points thread. The discussion includes known workarounds (and the issues introduced by the workarounds). The discussion also includes the WHY and suggestions for improving / refactoring a future version of Reward Points.

Further discussion on the topic of Reward Points should occur in the Reward Points support thread.

The site I manage has a lot of call for price products. We've begun to input the orders with the Edit Orders/Super Orders modules. I see from the support thread that these modules don't actually process the credit cards. Is it possible to make this happen (we use usaepay for credit card processing)? Any help would be appriciated.
Thanks,
Tadj

Tadj Hemingway:

The site I manage has a lot of call for price products. We've begun to input the orders with the Edit Orders/Super Orders modules. I see from the support thread that these modules don't actually process the credit cards. Is it possible to make this happen (we use usaepay for credit card processing)? Any help would be appriciated.
Thanks,
Tadj

You will need custom code to process credit cards from the back end.. not likely that anyone will do this development for free..

lhungil:

Thank you for confirming my suspicion. I have a few guesses as to the cause, but will need time to investigate further in order to determine the cause and best fix.

Have you had a chance to make any progress on the fix for this?

Since I can't get the calculations to work right with EO 4.1.4, I uninstalled and installed EO 4.0.4. When I load the edit orders page, I'm getting "Failed to connect database:opai" at the advanced attributes editor. Anyone have any idea why this would happen?

Edit Orders 4.0.x is not compatible with Zen Cart >= 1.5.2.

lhungil:

Edit Orders 4.0.x is not compatible with Zen Cart >= 1.5.2.

Ugh... Bummer. I am desperate for a solution to the miscalculation errors in EO 4.1.4.

I have zen cart 1.5.0 with edit orders 4.1 installed. I also have isbn/upc fields installed. When i attempt to edit a customer order i get the following error on the top in the admin window (There was a problem retrieving transaction details. ) the associated log file contains: [14-Apr-2015 22:27:53 America/Chicago] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM zen_products WHERE p.products_id = '19492' in /home4/pitstopc/public_html/store/includes/classes/db/mysql/query_factory.php on line 120.

I have tried to resolve it by uninstalling the add-on and reinstalling it without any success. I have the feeling I put a file in the wrong place and in the right place. so it is creating this problem.

Any ideas?

0ldgeezer:

I have zen cart 1.5.0 with edit orders 4.1 installed. ... the log file contains: [14-Apr-2015 22:27:53 America/Chicago] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM zen_products WHERE p.products_id = '19492' in /home4/pitstopc/public_html/store/includes/classes/db/mysql/query_factory.php on line 120. ...
Please follow the instructions in the posted fix to resolve this error message.

lhungil:

Please follow the instructions in the posted fix to resolve this error message.

I tried the fix that was listed and it changed the results a bit. Now I get a blank white screen when i attempt to update an order and no longer get a generated logfile. So after waiting a few moments I go back to the original screen and there is no error at the top either. Still no joy in being able to update an order.

I have even gone as far as upgrading from zencart 1.5.1 to 1.5.4 and upgraded my database accordingly. Didn't seem to make a difference. So i started over from scratch and still have the problem carried over.

I appreciate your help with this, I am getting slightly over cooked.

Should be a log file if you see a "white screen" when clicking "update" (if using FTP to access the logs be sure to clear any cache in your FTP client).

If you are seeing a white screen when trying to access "/admin/edit_orders.php" it could indicate something not quite merged correctly (or a bad upload)... Could also be a number of other things... Are there any errors in the Apache error log?

lhungil:

Edit Orders 4.0.x is not compatible with Zen Cart >= 1.5.2.

For anyone who has been having the same troubles I was having with group discounts causing calculation errors in 4.1.4, I do now have a copy of 4.0.4 that will work on ZC 1.5.3. At least now I can edit my orders in the admin panel, rather than having to go directly into the database.

Thanks for the resolution. I hadn't thought of updating my other plug-ins. lhungil, Thank you..

geezerly:

Thanks for the resolution. I hadn't thought of updating my other plug-ins. lhungil, Thank you..
No problem. For other people who may stumble across these posts in the future, after the posted fix was applied additional error logs were identified. The logs indicated an older version of a 3rd party "Order Total" module was installed. Updating the "Order Total" module appears to have resolved the "white screen".

Were there any other changes / fixes needed geezerly?

Hello,

I have a problem with the Edit Orders 4.1.4 plugin (Zencart 1.5.0). Prices of products, taxes and shipping charge are calculated correctly, but the edit doesn't consider additional prices (e.g. insured shipment or cash on delivery ). How can I solve this problem?

Thank you in advance for your reply.

Attachment #15242

Order Total pricing IS NOT calculated by Edit Orders. Your installed Order Total modules are responsible for returning the correct data for Zen Cart to update Order Totals (such as "Totale").

Would suggest taking a look at the two Order Total modules you have installed (Insured Shipment and Cash on Delivery) to determine why they are not working when loaded from the Zen Cart administration interface. Would also suggest checking the Zen Cart debug logs (if any).