Edit Orders v4.0 Support Thread

[jeanjean88]

Honestly being nice was to give an HINT on how to solve the problem...

I don't need a ready-to-go solution. Just an opinion.

Unfortunately for my store upgrading is not an option, otherwise I would not be here asking for that.

[delia]

Forgive me if this has been addressed before but the instructions state "We do not recommend clicking "edit" on completed orders." So exactly what is meant by completed? Final status change / actual payment taken? The cart is using the old CEON cc mod on purpose so that the owner can edit the order and add charges for shipping and discounts. So in his mind the order isn't completed until he does exactly that and then he changes the order status to shipped. What is the reality?

[lat9]

Forgive me if this has been addressed before but the instructions state "We do not recommend clicking "edit" on completed orders." So exactly what is meant by completed? Final status change / actual payment taken? The cart is using the old CEON cc mod on purpose so that the owner can edit the order and add charges for shipping and discounts. So in his mind the order isn't completed until he does exactly that and then he changes the order status to shipped. What is the reality?

That wording is carry-over from the v4.1.4 version of EO that I started with. I suppose that DivaVocals was just being cautious in her wording.

Things that can go wrong:
- A product in an old order is no longer stocked by the store.
- A product-option in an old order is no longer available for a product in the order.

[delia]

so in other words, the longer you wait to edit an order, the more problematic it could possibly be. Perhaps changing the wording in the instructions? Is this in github?

[lat9]

so in other words, the longer you wait to edit an order, the more problematic it could possibly be. Perhaps changing the wording in the instructions? Is this in github?

You bet: https://github.com/lat9/edit_orders

[swguy]

EO 4.5.0, Zen Cart 1.5.6. It appears that orders with a tax line item have the tax order total entry removed after an order update.
Is this an integration problem on my end or have others seen it?

[lat9]

EO 4.5.0, Zen Cart 1.5.6. It appears that orders with a tax line item have the tax order total entry removed after an order update.
Is this an integration problem on my end or have others seen it?

zc156, no suffix? What are you using for the product-pricing method?

I'm not seeing this on zc156c/eo450.

[swguy]

Sorry, 156c. Product Pricing - tested manual and auto, both had the same issue. OK I will dig in on my side.

[swguy]

Investigating ...

admin/includes/functions/extra_functions/edit_orders_functions.php lines 1429-1445 you are referencing $order->totals[$i]['class'].
This should be $order->totals[$i]['code'] shouldn't it?

(lines are same between EO 4.5.0 and 4.5.1)

[swguy]

The root cause of the deleted tax line is in the block that handles the "rogue" ot_tax value.
(Around 1449 of ./includes/functions/extra_functions/edit_orders_functions.php).

My tax title is Sales tax (if any) + Shipping Tax (0.0000%) + Tax:

which does not work for the clause

`title` NOT IN ($tax_groups)

Perhaps a LIKE would be better - something like

foreach ($tax_groups as &$tax_group) {
   $tax_group = '%' . $db->prepareInput($tax_group) .'%'. ':';
}
$tax_groups = "'" . implode("', '", $tax_groups) . "'";
...
$query = 
                "DELETE FROM " . TABLE_ORDERS_TOTAL . "
                  WHERE orders_id = $oID
                    AND `class` = 'ot_tax'
                    AND `title` NOT IN (";  
for ($i = 0; $i < count($tax_groups); $i++) {
   if ($i > 0) $query .= ","; 
   $query .= $tax_groups[$i]; 
}
$query .= ")";