Edit Orders v4.0 Support Thread

Hello Lhungil,

unfortunately, I'm still not so familiar with Zencart. Please, can you give me some more details? A have a problem with the price only when I try to change an order. I uploaded an image that shows you the difference of prices when I change "Cash on Delivery" from 7,9981 to 8,9981 (the same thing changing Insured Shipping). I think the field "ot_cod_fee" is not calculated. I also noticed that Zen Cart properly calculates the order without Edit order. If you need, I can attach the "log" created by edit orders.

Thank you for your reply.
Attachment #15247

JDanielsita:

Hello Lhungil,

unfortunately, I'm still not so familiar with Zencart. Please, can you give me some more details? A have a problem with the price only when I try to change an order. I uploaded an image that shows you the difference of prices when I change "Cash on Delivery" from 7,9981 to 8,9981 (the same thing changing Insured Shipping). I think the field "ot_cod_fee" is not calculated. I also noticed that Zen Cart properly calculates the order without Edit order. If you need, I can attach the "log" created by edit orders.

Thank you for your reply.
Attachment #15247
lhungil has already answered your question, but let me try and re-phrasing it.

The issue is not with Edit Orders, the issue is with the Insured Shipment and Cash on Delivery order total modules.

Insured Shipment and Cash on Delivery are not correctly re-calculating the COD or Insured Shipment totals when you edit the order using Edit Orders.

Again.. This is not an issue with Edit Orders, this is an issue with your two order total modules (Insured Shipment and Cash on Delivery

Installed order total modules are responsible for returning the correct data when an order is edited. Insured Shipment and Cash on Delivery are not working when loaded from the Zen Cart administration interface, and therefore they will not work with Edit Orders. Do you have any related Zen Cart logs? If so you should post them..

It seems as though when the values for non-built-in order totals are updated, the changes are not reflected in the final cart total - are the values which are entered on the screen not used? It looks like the order total module in question are rerun and those values are used. The fields in the orders_total show my edit updates but the final total doesn't match.

swguy:

It seems as though when the values for non-built-in order totals are updated, the changes are not reflected in the final cart total - are the values which are entered on the screen not used? It looks like the order total module in question are rerun and those values are used. The fields in the orders_total show my edit updates but the final total doesn't match.
Changes to the order total are calculated by individual Order Total Modules (and displayed / stored in the database by "ot_total"), not Edit Orders. This means when a third party Order Total module fails to return valid data or update $order->info['total'] as needed... The total for the order will not be updated.

The most common cause of issues reported regarding the total not being correct are Order Total modules not designed as "Standalone", but instead depending upon other modifications to the Zen Cart store front. The modifications needed to Zen Cart administrative interface (for these modules to work) are often not provided to end users. Edit Orders is an administrative tool (run from the Zen Cart administrative interface), so when run these third party Order Total modules do not function as expected or in some cases outright crash.

Another common cause is the third party Order Total module always recalculating (and not using the value from the database). Currently this can be addressed by the third party order total looking at the Global variable $order->totals at the start of the Order Total module's "process" function (or checking the database manually). When the value has been altered via Edit Orders, the altered value will be present (while the "process" function is being called).

There are some changes coming in the next version of Edit Orders (which may help some). This includes a reworked responsive interface, automatic removal of Order Total modules not returning a value when run, fields can be togged between "editable" or "automatically calculated", utilization of the additional PCI Compliance structures added in Zen Cart 1.5.4+ (when run under Zen Cart 1.5.4+), additional notifiers, an installer capable of merging required core files automatically during installation, and more. There is no ETA for the next release at this time.

Abbreviated list of steps in the Current Process (in regards to order totals):

1. User edit's Order Total value / name.
2. User clicks "update".
3. The Mock Shopping cart is loaded (reads data from $order - not fully implemented at this time).
4. Some verification, validation, and sanitization is performed.
5. Order, Order Status, Order Status History, Order Totals, etc are loaded from the database.
6. Global and Session variables are populated (to match the shopping_cart page).
7. Some special handling is applied based on DISPLAY_PRICE_WITH_TAX.
8. Order Total modules are run (and the result saved in the Global and Session variables).
9. Any Order Total modules not returning a value are removed from the Global and Session variables (Edit Orders 4.1.5+; not yet released).
10. Order Total values in the database are updated (from the Global and Session variables).
11. User's Order Total value / name in the Global and Session variables are updated (or added if not present).
12. The Order Total information in the database is updated from the Global and Session variables.
13. The order is reloaded (from the database).
14. The Order Total modules are run again (so they can apply any changes and to allow ot_subtotal, ot_tax, ot_coupon, and ot_total to recalculate).
15. Any Order Total modules not returning a value are removed from the Global and Session variables (Edit Orders 4.1.5+; not yet released).
16. Order Total values in the database are updated (from the Global and Session variables).
17. The Edit Orders page is reloaded (to display the updated order).

lhungil:

Changes to the order total are calculated by individual Order Total Modules (and displayed / stored in the database by "ot_total"), not Edit Orders. This means when a third party Order Total module fails to return valid data or update $order->info['total'] as needed... The total for the order will not be updated.

What I'm asking for is: if I update the value of the order total dollar amount, can you use this instead of using what the OT Module returns? Like an override capability.

swguy:

What I'm asking for is: if I update the value of the order total dollar amount, can you use this instead of using what the OT Module returns? Like an override capability.
Some thoughts based on this question... Feel free to add to the list...

Stop relying on the Order Total modules and have Edit Orders do the math?
The answer is no.

Doing so would be going backwards to the way Edit Orders 4.0.x operated.

Edit Orders 4.0.x did it's own math, calculations, etc (to allow overrides)... Order Total Modules were not loaded (and the code completely ignored including: settings, tax handling, and other behaviors)... The value (dollar amount) of order totals were always "added" (resulting in third party "discount" modules adding to the total instead of subtracting)... And in general leading to admin users needing to double check everything or risk wrong pricing (and the wrath of upset customers).

Product and attribute pricing was manually calculated instead of using the existing Zen Cart code (and some of the calculation rules were ignored). When adding a product to an existing order, the pricing did not always match the price shown to customers on the website. Again forcing admin users to spend valuable time double check everything or risk wrong pricing (and the wrath of upset customers).

Invalid data was sometimes injected into the database relating to orders (adding shipping to an existing order always failed to result in correctly normalized data). This could cause issues with core portions of Zen Cart as well as third party modules and code (for example code synchronization with other inventory / accounting software).

I'd be surprised if there were not other issues as well, but those are the ones I remember (off the top of my head).

End users manually override the value (dollar amount) of third party order totals?
The problem is: the Order Total system in Zen Cart was not designed to allow end users to "override" dollar amounts (and the API does not include methods to allow overrides). As such, 90% of the Order Totals are not written to take into account they may be overridden.

So if we want to allow overriding the value (dollar amount) of an order total... Until all third party Order Total modules are coded to check for and use an override (and adjust $order->info as appropriate)... Problems with the "Total" (ot_total) and "Tax" (ot_tax) will ensue.

I've thought about adding a "Mock Order Total Module" to better support overriding the value (dollar amount) of an order total... But at a glance I forsee problems with this approach... For example: how does the mock know how tax should be handled? How does the mock know when to add to total vs. subtract from total?

Another thought was to disable editing / overriding the value (dollar amount) of an order total unless the module defines a public variable such as "$override_allowed" (and implements the necessary functionality)... Ugly, but could lead into being added to the core API, so a potential route...

The above are some (of the many reasons) I've been tempted many times to switch Edit Orders 4.1.x back to "automatic calculation only" (no overrides allowed) for all order total modules... Prior to the first public release this was added back in due to OVERWHELMING DEMAND by alpha test participants (along with special handling for most of the "core" order total modules included with Zen Cart).

End user to manually override the value (dollar amount) of all order totals?
I am planning to add this functionality into a future release. Once certain items are overridden, the user will be forced to manually override "Tax" (ot_tax) and "Total" (ot_total). This should help by allowing people to manually update the values.

Long term, I suspect it would be better to just enforce "automatic calculations only" for the value (dollar amount) of all order totals. Or make changes to the Zen Cart API and the core Zen Cart code handling orders and order totals.

Other thoughts
Long term, I believe it would be beneficial to refactor the existing Zen Cart code handling pricing, the shopping cart, orders, and order processing. Perhaps creating an API and smaller classes separating handling of the database domain, business logic, and display logic. Sprinkle in plenty of notifier hooks and abstraction (and smaller methods to enable better code reuse).

Wish I had more time to start down this path (or help walk down this path).

lhungil:

End user to manually override the value (dollar amount) of all order totals?
I am planning to add this functionality into a future release. Once certain items are overridden, the user will be forced to manually override "Tax" (ot_tax) and "Total" (ot_total). This should help by allowing people to manually update the values.

Totally fair. Your gun, your bullet, your foot. :)
In the mean time, it might make sense to make those figures NOT editable since editing the values doesn't really work. (You can edit the labels, just not the values.)

Fair enough (gun smithing in process).

Will be a fair amount of work, so perhaps it would not be a bad idea to just disable the fields for third party modules (most of the stock Zen Cart OT modules can be successfully edited).

Just to be clear (to everyone), there is no ETA for the changes we have been discussing.

Hi

Just a quick note for anyone having the same problem as I did today. Hopefully this may save someone from much unnecessary stress.

In summary: a blank page after install without error messages in the log.

For you information, I have successfully installed this module about three times before this 'interesting' experience today, and can assure anybody thinking about Edit Orders that it is a 'Must Have' module!.

I have zc 1.5.4 installed (I successfully updated a 1.3.9 database). I had successfully installed several plugins and mods, but none overwrote any of the core files in Edit Orders 4.1.4. After logging into Admin, I then uploaded the install files as in the directions. When I went back to Admin and clicked a link the page went blank. There were no success or failure messages. Also, when checking the log files, none were created.

After much searching of this thread and after three re-installs I experimented. I removed the two install files from the server. I then clicked on Admin and the 'Admin Log In' page came up! I successfully logged in and Edit Orders was available. When updating an order I received the error message, and there was an error message in the log this time. So, I edited the edit_orders_functions.php file as in this post within this thread.

Tested and all appears to now be working!

Would appreciate if anyone can tell me why this happened though.

If you deleted the init_scripts, you disabled the installer... And the installation may not be complete... DO NOT disable / delete the init_scripts unless instructed to do so by the installer.

Usual cause of all admin pages blank after uploading the install init_scripts are either a corrupted upload or invalid paths specified in "/admin/includes/configure.php". Most commonly the cause is an invalid / incorrect path.

Thanks. I will look into that further...

lhungil:

If you deleted the init_scripts, you disabled the installer... And the installation may not be complete... DO NOT disable / delete the init_scripts unless instructed to do so by the installer.

Usual cause of all admin pages blank after uploading the install init_scripts are either a corrupted upload or invalid paths specified in "/admin/includes/configure.php". Most commonly the cause is an invalid / incorrect path.

Just did a fresh install of Edit Orders and there was no problem with the install except having to modify the edit_order_functions.php file with the ' AS p ' Fix.

Thanks once again for your help with this problem. :smile:

Cheers

Anthony

I have a client that wants to update orders and create a new invoice at the same time - will this module do that?
Thanks

Would love to see a feature added,
making adding a coupon post order more simple, now I can add a line when editing however in the database it is not stored as ot_coupon for reporting purposes

If you select "ot_coupon" and enter the coupon code Edit Orders does add the corresponding entries in the database table (storing order totals). So if the report queries this table, it should work.

Edit Orders does not however update the "# of uses" or other non-order specific coupon entries (at this time)... Which report (3rd party? built-in? steps to access) are you referring to (so I can add the info as a request in the project management system for future review).

We tend to adjust the shipping charges for our customers whenever possible. With the current version of EO we have to edit a coupon amount and then apply the coupon to the order totals. Is there a way to enter the shipping discount without using the coupon? Thank you.

ZC 1.5.4
OE 4.1.4

voltar:

We tend to adjust the shipping charges for our customers whenever possible. With the current version of EO we have to edit a coupon amount and then apply the coupon to the order totals. Is there a way to enter the shipping discount without using the coupon? Thank you.

ZC 1.5.4
OE 4.1.4
You should be able to directly change the amount for ot_shipping if desired... Or for reporting purposes (and to make the discount obvious to a customer) or you could clone "ot_onetime_discount" and modify it to fit your needs.

Hi lhungil,

I have Optional Shipping Insurance with Edit Orders 4.1.4 on ZenCart 1.5.4 and noticed that the Optional Insurance amount was not being included in the order total after editing the order.. I see you comment "returns nothing when loaded in the admin ($charge_it is set to 'false'), so will not recalculate the order total automatically."

Is this the problem I am having?

Do you have any idea how I can fix the problem?

Thanks!!!

Andy

Andy_M:

Hi lhungil,

I have Optional Shipping Insurance with Edit Orders 4.1.4 on ZenCart 1.5.4 and noticed that the Optional Insurance amount was not being included in the order total after editing the order.. I see you comment "returns nothing when loaded in the admin ($charge_it is set to 'false'), so will not recalculate the order total automatically."

Is this the problem I am having?

Do you have any idea how I can fix the problem?

Thanks!!!

Andy

If it helps.. here is the log that shows the order total is not including the insurance..

============================================================
= Done Processing Requested Updates to the Order
============================================================


Final Subtotal: 12.5000
Final Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$12.50',
    'class' => 'ot_subtotal',
  ),
  1 => 
  array (
    'title' => 'USPS Standard (Shipping to US):',
    'text' => '$4.75',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => 'WA TAX 8.4%:',
    'text' => '$1.45',
    'class' => 'ot_tax',
  ),
  3 => 
  array (
    'title' => 'Shipping Insurance',
    'text' => '$1.70',
    'class' => 'ot_insurance',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$18.70',
    'class' => 'ot_total',
  ),
)

Final Tax (total): 1.45
Final Tax Groups:
array (
  'WA TAX 8.4%' => 1.4490000000000000657252030578092671930789947509765625,
)