[support thread] - "edit orders -> detail record copy"

[carlwhat]

plugin for a plugin!


if you have additional fields added to your orders_products table, and have been frustrated by those fields not being there when adjusting quantities via the Edit Orders plugin, be frustrated no longer!



this is the support thread for a new observer to properly copy all added fields when using edit orders.

this plugin can be downloaded here:

https://www.zen-cart.com/downloads.php?do=file&id=2292

[Elemi]

Is this based on the assumption that the "Edit orders" plugin is installed (and working) for 1.5.7?

Sorry, not quite clear in your description :-)

[swguy]

Only users of the Edit Orders plugin who also have added fields to the orders_products table need this plugin.
If that's not you, you don't need it.

[carlwhat]

Is this based on the assumption that the "Edit orders" plugin is installed (and working) for 1.5.7?

Sorry, not quite clear in your description :-)

what swguy said.

there are any number of us who have modified the orders products table by adding additional fields. if u use edit orders to let’s say adjust the customer quantity from 3 to 4, edit orders will delete the original record and create a new record. this has caused me tremendous frustration with clients over the years and a lot of work. apparently other people have noticed and complained about it.

with the addition of notifiers to the edit orders plugin, i created a little observer that now preserves those additional fields from the deleted record, and copies them to the new record.

unfortunately the notifier does not provide the exact fields it uses for the new record, so if those fields change, this observer will need to change. it’s a minor point but worth noting.

in the interim i think this is a little slick solution to address what has been a very frustrating problem.

thanks to @lat9 for the maintenance of the edit orders plugin and for the addition of the observer events.

[lat9]

The updated EO notification will be available in EO v4.5.5 (recently submitted) and later: https://www.zen-cart.com/downloads.php?do=file&id=1513

[carlwhat]

The updated EO notification will be available in EO v4.5.5 (recently submitted) and later: https://www.zen-cart.com/downloads.php?do=file&id=1513

[swguy]

Would you please clarify the installation instructions? It says,

> Unfortunately, the observers used in edit orders, do NOT give the exact fields updated. So those fields needed to be hard coded in this file. When edit orders changes this file may need to change.

Does this mean I need to add any new fields I have added in the orders_products table to the $updatedFields list?

[carlwhat]

Would you please clarify the installation instructions? It says,

> Unfortunately, the observers used in edit orders, do NOT give the exact fields updated. So those fields needed to be hard coded in this file. When edit orders changes this file may need to change.

Does this mean I need to add any new fields I have added in the orders_products table to the $updatedFields list?

@swguy, if you are running v4.5.5 of edit orders, there is no need to add any new fields...

as long as your notifier in YOUR_ADMIN/includes/functions/extra_functions/edit_orders_functions.php looks like:

$zco_notifier->notify('EDIT_ORDERS_ADD_PRODUCT', array('order_id' => (int)$order_id, 'orders_products_id' => $order_products_id, 'product' => $product, 'sql_data_array' => $op_sql_data_array)); 

you are good to go with no need to maintain the $updatedFields array.

best.

[swguy]

OK - I didn't realize 4.5.5 was the cutoff - I thought all that was needed was the EDIT_ORDERS_ADD_PRODUCT notifier. I will update EO; thanks for confirming.

[swguy]

Does this only work in 1.5.7? In 1.5.6, the class constructor doesn't seem to fire, and the compatibility information for the first version says 1.5.6.