Edit Orders v4.0 Support Thread

[lhungil]

Usually means the subtotal stored in the database is no longer synced (it is not recalculated by Edit Orders). I've also seen this in the past when 'ot_subtotal' (Subtotal Order Total Module) is disabled (needs to be enabled for Edit Orders to work correctly). The most common cause is if there was an ERROR while updating an order (such as the `p` one you saw). Quickest fix is to just update the two related database tables by hand (if you really need to keep the order), or just delete and re-create the order.

For reference it will be the row in the table 'orders_total' corresponding to the row storing the value of 'ot_subtotal' for the order.

[jerrygarciuh]

OK, thank lhungil! I appreciate your time and the mods! Order Sub-Total was enabled so I will dig in and see what I find. If anything useful comes up I will post here.

Peace,

David

[jerrygarciuh]

I grepped files for EO_DEBUG_ACTION_LEVEL to see where it was being defined()ed but it looks like in my distro it is not defined. Since all references in codebase come from edit_orders.php I define()ed it at top of that file.

Debug output appears to show the new products being added and subsequently removed by the update routine...

I tried enabling SQL logging for whole store briefly but while edit_orders.php select statements appear to be logged, the update SQL was not.

Digging further now...

============================================================

= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 11435
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_local_sales_taxes;ot_loworderfee;ot_gv;ot_total

Order Subtotal: 0.0000
Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$16.24',
    'class' => 'ot_total',
  ),
)

Order Tax (total): 1.59
Order Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
)

Requested Products:
array (
  17668 => 
  array (
    'qty' => '1',
    'name' => '6oz. [snipped] (Case of 24)',
    'model' => '',
    'tax' => '4',
    'final_price' => '19.88',
  ),
  17669 => 
  array (
    'qty' => '1',
    'name' => '6oz. [snipped] (Case of 24)',
    'model' => '',
    'tax' => '4',
    'final_price' => '19.88',
  ),
)


============================================================
= Processing Requested Updates to Products
============================================================



Products in Original Order: 
array (
  0 => 
  array (
    'qty' => 1,
    'id' => '29',
    'name' => '6oz. [snipped] (Case of 24)',
    'model' => '',
    'tax' => '4.0000',
    'price' => '19.8800',
    'final_price' => '19.8800',
    'onetime_charges' => '0.0000',
    'products_priced_by_attribute' => '0',
    'product_is_free' => '0',
    'products_discount_type' => '0',
    'products_discount_type_from' => '0',
  ),
  1 => 
  array (
    'qty' => 1,
    'id' => '29',
    'name' => '6oz. [snipped] (Case of 24)',
    'model' => '',
    'tax' => '4.0000',
    'price' => '19.8800',
    'final_price' => '19.8800',
    'onetime_charges' => '0.0000',
    'products_priced_by_attribute' => '0',
    'product_is_free' => '0',
    'products_discount_type' => '0',
    'products_discount_type_from' => '0',
  ),
)

Order Product ID: 17668 Row ID: 0
Product in Request: 
array (
  'qty' => 1,
  'name' => '6oz. [snipped] (Case of 24)',
  'model' => '',
  'tax' => '4',
  'final_price' => '19.88',
)

Old Product:
array (
  'qty' => 1,
  'id' => '29',
  'name' => '6oz. [snipped] (Case of 24)',
  'model' => '',
  'tax' => '4.0000',
  'price' => '19.8800',
  'final_price' => '19.8800',
  'onetime_charges' => '0.0000',
  'products_priced_by_attribute' => '0',
  'product_is_free' => '0',
  'products_discount_type' => '0',
  'products_discount_type_from' => '0',
)

Old Order Subtotal: 0.0000
Old Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$16.24',
    'class' => 'ot_total',
  ),
)

Old Tax (total): 1.59
Old Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
)

Removed Product Order Subtotal: -19.88
Removed Product Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$-19.88',
    'class' => 'ot_subtotal',
    'value' => -19.88,
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$0.79',
    'class' => 'ot_tax',
    'value' => 0.7948,
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$-7.94',
    'class' => 'ot_total',
    'value' => -7.9352,
  ),
)

Removed Product Tax (total): 0.7948
Removed Product Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 0.7952,
)

Added Product:
array (
  'id' => 29,
  'qty' => 1,
  'name' => '6oz. [snipped] (Case of 24)',
  'model' => '',
  'price' => '19.8800',
  'products_discount_type' => '0',
  'products_discount_type_from' => '0',
  'products_priced_by_attribute' => '0',
  'product_is_free' => '0',
  'products_virtual' => '0',
  'product_is_always_free_shipping' => '0',
  'tax' => '4',
  'tax_description' => '4.0% Louisiana Sales Tax',
  'onetime_charges' => 0,
  'final_price' => '19.88',
)

Added Product Order Subtotal: 0
Added Product Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
    'value' => 0,
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
    'value' => 1.59,
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$12.74',
    'class' => 'ot_total',
    'value' => 12.74,
  ),
)

Added Product Tax (total): 1.59
Added Product Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
)

Order Product ID: 17669 Row ID: 0
Product in Request: 
array (
  'qty' => 1,
  'name' => '6oz. [snipped] (Case of 24)',
  'model' => '',
  'tax' => '4',
  'final_price' => '19.88',
)

Old Product:
array (
  'qty' => 1,
  'id' => '29',
  'name' => '6oz. [snipped] (Case of 24)',
  'model' => '',
  'tax' => '4.0000',
  'price' => '19.8800',
  'final_price' => '19.8800',
  'onetime_charges' => '0.0000',
  'products_priced_by_attribute' => '0',
  'product_is_free' => '0',
  'products_discount_type' => '0',
  'products_discount_type_from' => '0',
)

Old Order Subtotal: 0
Old Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
    'value' => 0,
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
    'value' => 1.59,
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$12.74',
    'class' => 'ot_total',
    'value' => 12.74,
  ),
)

Old Tax (total): 1.59
Old Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
)

Removed Product Order Subtotal: -19.88
Removed Product Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$-19.88',
    'class' => 'ot_subtotal',
    'value' => -19.88,
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$0.79',
    'class' => 'ot_tax',
    'value' => 0.7948,
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$-7.94',
    'class' => 'ot_total',
    'value' => -7.9352,
  ),
)

Removed Product Tax (total): 0.7948
Removed Product Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 0.7952,
)

Added Product:
array (
  'id' => 29,
  'qty' => 1,
  'name' => '6oz. [snipped] (Case of 24)',
  'model' => '',
  'price' => '19.8800',
  'products_discount_type' => '0',
  'products_discount_type_from' => '0',
  'products_priced_by_attribute' => '0',
  'product_is_free' => '0',
  'products_virtual' => '0',
  'product_is_always_free_shipping' => '0',
  'tax' => '4',
  'tax_description' => '4.0% Louisiana Sales Tax',
  'onetime_charges' => 0,
  'final_price' => '19.88',
)

Added Product Order Subtotal: 0
Added Product Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
    'value' => 0,
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
    'value' => 1.59,
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$12.74',
    'class' => 'ot_total',
    'value' => 12.74,
  ),
)

Added Product Tax (total): 1.59
Added Product Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
)

Updated Products in Order:
array (
  0 => 
  array (
    'qty' => 1,
    'id' => '29',
    'name' => '6oz. [snipped] (Case of 24)',
    'model' => '',
    'tax' => '4.0000',
    'price' => '19.8800',
    'final_price' => '19.8800',
    'onetime_charges' => '0.0000',
    'products_priced_by_attribute' => '0',
    'product_is_free' => '0',
    'products_discount_type' => '0',
    'products_discount_type_from' => '0',
  ),
  1 => 
  array (
    'qty' => 1,
    'id' => '29',
    'name' => '6oz. [snipped] (Case of 24)',
    'model' => '',
    'tax' => '4.0000',
    'price' => '19.8800',
    'final_price' => '19.8800',
    'onetime_charges' => '0.0000',
    'products_priced_by_attribute' => '0',
    'product_is_free' => '0',
    'products_discount_type' => '0',
    'products_discount_type_from' => '0',
  ),
)

Updated Products Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$16.24',
    'class' => 'ot_total',
  ),
)

Updated Products Tax (total): 1.59
Updated Products Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
)

Requested Order Totals:
array (
  0 => 
  array (
    'code' => 'ot_shipping',
    'shipping_module' => 'fedexwebservices',
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'value' => '11.1500',
  ),
  1 => 
  array (
    'code' => 'ot_loworderfee',
    'title' => 'Handling Fee:',
    'value' => '3.5000',
  ),
  2 => 
  array (
    'code' => 'ot_coupon',
    'title' => '',
    'value' => '',
    'shipping_module' => '',
  ),
)


============================================================
= Processing Requested Updates to Order Totals
============================================================



Starting Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
  ),
  3 => 
  array (
    'title' => 'Handling Fee:',
    'text' => '$3.50',
    'class' => 'ot_loworderfee',
  ),
  4 => 
  array (
    'title' => 'Total:',
    'text' => '$16.24',
    'class' => 'ot_total',
  ),
)

Starting Tax (total): 1.59
Starting Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
)

Updated Order Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
  ),
  3 => 
  array (
    'title' => 'Total:',
    'text' => '$16.24',
    'class' => 'ot_total',
  ),
)

Updated Tax (total): 1.59
Updated Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
  '' => 0,
)


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


Final Subtotal: 0.0000
Final Totals:
array (
  0 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
  ),
  1 => 
  array (
    'title' => 'FedEx (1 x 2.00lbs) (Ground Home Delivery):',
    'text' => '$11.15',
    'class' => 'ot_shipping',
  ),
  2 => 
  array (
    'title' => '4.0% Louisiana Sales Tax:',
    'text' => '$1.59',
    'class' => 'ot_tax',
  ),
  3 => 
  array (
    'title' => 'Total:',
    'text' => '$16.24',
    'class' => 'ot_total',
  ),
)

Final Tax (total): 1.59
Final Tax Groups:
array (
  '4.0% Louisiana Sales Tax' => 1.5904,
  '' => 0,
)

[jerrygarciuh]

New clue- the original order had a cap which I removed when adding the new products. When I add cap back to order the subtotal correctly reflects the cap but not the added products. Remove cap and subtotal goes back to zero.

[lhungil]

Once the subtotal is out of sync it will remain out of sync unless you either manually update the database table mentioned previously or the order is deleted and recreated. Continuing to play with the order via Edit Orders will not help until one of those two items is done.

Is this the same order as the one you were trying to edit when you received the "WARNING -" and the associated Zen Cart DEBUG log? If it is, this was probably the cause for the subtotal going out of sync on the order (as the process crashed while modifying the order).

[jerrygarciuh]

OK, thank you!

Once the subtotal is out of sync it will remain out of sync unless you either manually update the database table mentioned previously or the order is deleted and recreated. Continuing to play with the order via Edit Orders will not help until one of those two items is done.

Is this the same order as the one you were trying to edit when you received the "WARNING -" and the associated Zen Cart DEBUG log? If it is, this was probably the cause for the subtotal going out of sync on the order (as the process crashed while modifying the order).

[cefyn]

Using zen cart 1.5.4 , edit orders 4 ,stock by attribute 1.5.4.
In step 1 of adding a product to order , a search box appears. Could someone tell me if there is a way for that function to be told to include the customid column of the products with attributes stock database table and output the item that goes with the customid ?

[B-Noid]

Hello everyone!
I've been poking around this thread for about a week now and i can't seem to find why my sub total and total doesn't update.
I reinstalled twice and it still doesn't work.
I use ZC 1.5.4 and as lhungil said, i tried with new order to rule out the out of sync problem with the DB.

If someone can give me a hint on where to look, that would be awesome.

Thanks in advance

Here is the log file :

============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 4
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_gv;ot_total

Order Subtotal: 129.9500
Order Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$129.95',
    'class' => 'ot_subtotal',
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$149.41',
    'class' => 'ot_total',
  ),
)

Order Tax (total): 0.00
Order Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 19.460012499999998,
)

Requested Products:
array (
  51 => 
  array (
    'qty' => '2',
    'name' => '30" Lifegard Aquatics Ultra-Slim Blue/White LED Light',
    'model' => '',
    'tax' => '14.975',
    'final_price' => '129.95',
  ),
)


============================================================
= Processing Requested Updates to Products
============================================================



Products in Original Order: 
array (
  0 => 
  array (
    'qty' => 1,
    'id' => '477',
    'name' => '30" Lifegard Aquatics Ultra-Slim Blue/White LED Light',
    'model' => '',
    'tax' => '14.9750',
    'price' => '129.9500',
    'final_price' => '129.9500',
    'onetime_charges' => '0.0000',
    'products_priced_by_attribute' => '0',
    'product_is_free' => '0',
    'products_discount_type' => '0',
    'products_discount_type_from' => '0',
  ),
)

Order Product ID: 51 Row ID: 0
Product in Request: 
array (
  'qty' => 2,
  'name' => '30" Lifegard Aquatics Ultra-Slim Blue/White LED Light',
  'model' => '',
  'tax' => '14.975',
  'final_price' => '129.95',
)

Old Product:
array (
  'qty' => 1,
  'id' => '477',
  'name' => '30" Lifegard Aquatics Ultra-Slim Blue/White LED Light',
  'model' => '',
  'tax' => '14.9750',
  'price' => '129.9500',
  'final_price' => '129.9500',
  'onetime_charges' => '0.0000',
  'products_priced_by_attribute' => '0',
  'product_is_free' => '0',
  'products_discount_type' => '0',
  'products_discount_type_from' => '0',
)

Old Order Subtotal: 129.9500
Old Order Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$129.95',
    'class' => 'ot_subtotal',
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$149.41',
    'class' => 'ot_total',
  ),
)

Old Tax (total): 0.00
Old Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 19.460012499999998,
)

Removed Product Order Subtotal: 0
Removed Product Order Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$0.00',
    'class' => 'ot_subtotal',
    'value' => 0,
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$-19.46',
    'class' => 'ot_total',
    'value' => -19.460012499999998,
  ),
)

Removed Product Tax (total): -19.4600125
Removed Product Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 0,
)

Added Product:
array (
  'id' => 477,
  'qty' => 2,
  'name' => '30" Lifegard Aquatics Ultra-Slim Blue/White LED Light',
  'model' => '',
  'price' => '129.9500',
  'products_discount_type' => '0',
  'products_discount_type_from' => '0',
  'products_priced_by_attribute' => '0',
  'product_is_free' => '0',
  'products_virtual' => '0',
  'product_is_always_free_shipping' => '0',
  'tax' => '14.975',
  'tax_description' => 'TPS/TVQ (14.975%)',
  'onetime_charges' => 0,
  'final_price' => '129.95',
)

Added Product Order Subtotal: 259.9
Added Product Order Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$259.90',
    'class' => 'ot_subtotal',
    'value' => 259.89999999999998,
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$279.36',
    'class' => 'ot_total',
    'value' => 279.36001249999998,
  ),
)

Added Product Tax (total): 19.4600125
Added Product Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 38.920024999999995,
)

Updated Products in Order:
array (
  0 => 
  array (
    'qty' => 2,
    'id' => '477',
    'name' => '30" Lifegard Aquatics Ultra-Slim Blue/White LED Light',
    'model' => '',
    'tax' => '14.9750',
    'price' => '129.9500',
    'final_price' => '129.9500',
    'onetime_charges' => '0.0000',
    'products_priced_by_attribute' => '0',
    'product_is_free' => '0',
    'products_discount_type' => '0',
    'products_discount_type_from' => '0',
  ),
)

Updated Products Order Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$129.95',
    'class' => 'ot_subtotal',
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$149.41',
    'class' => 'ot_total',
  ),
)

Updated Products Tax (total): 0.00
Updated Products Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 38.920024999999995,
)

Requested Order Totals:
array (
  0 => 
  array (
    'code' => 'ot_shipping',
    'shipping_module' => 'storepickup',
    'title' => 'Store Pickup (Walk In):',
    'value' => '0.0000',
  ),
  1 => 
  array (
    'code' => 'ot_coupon',
    'title' => '',
    'value' => '',
    'shipping_module' => '',
  ),
)


============================================================
= Processing Requested Updates to Order Totals
============================================================



Starting Order Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$129.95',
    'class' => 'ot_subtotal',
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$149.41',
    'class' => 'ot_total',
  ),
)

Starting Tax (total): 0.00
Starting Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 38.920024999999995,
)

Updated Order Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$129.95',
    'class' => 'ot_subtotal',
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$149.41',
    'class' => 'ot_total',
  ),
)

Updated Tax (total): 0.00
Updated Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 38.920024999999995,
)


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


Final Subtotal: 129.9500
Final Totals:
array (
  0 => 
  array (
    'title' => 'Store Pickup (Walk In):',
    'text' => '$0.00',
    'class' => 'ot_shipping',
  ),
  1 => 
  array (
    'title' => 'Sub-Total:',
    'text' => '$129.95',
    'class' => 'ot_subtotal',
  ),
  2 => 
  array (
    'title' => 'Total:',
    'text' => '$149.41',
    'class' => 'ot_total',
  ),
)

Final Tax (total): 0.00
Final Tax Groups:
array (
  'TPS/TVQ (14.975%)' => 38.920024999999995,
)

[B-Noid]

I've been poking around this thread for about a week now and i can't seem to find why my sub total and total doesn't update.

Nevermind my last post... I finally found my problem!

Turns out i didn't delete line 44 of /includes/classes/order_total.php like i was suppose to...

$module_file = DIR_WS_MODULES . 'order_total/' . $value; 

Thank you for your time and this is a great plugin BTW
Have a good one!

[chibipaw]

I've been using ZC for quite a while, and have been using Edit Orders as a staple add-on.
At first I thought this might be related to rewards points, but after installing both the latest version of Rewards Points 2.5e and Edit order 4.1.4. Im beginning to think it's something else.

While editing an order, changing, updating any user information, adding products, or no change made at all, edit order will throw an error of the following after pressing the "update" button:
WARNING: An Error occurred, please refresh the page and try again.

If it's editing user information or adding a product, refreshing the order page will show the changes even after the error will show the changes.
However, trying to delete a product from an order, will throw the same error, but does not actually remove the product from the order.

Debug file shows this:
[01-Oct-2015 23:31:19 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `products` WHERE `p`.`products_id` = '5646' ==> (as called by) /home/webuser/shopping/someadmin/includes/functions/extra_functions/edit_orders_functions.php on line 1028 <== in /home/webuser/shopping/includes/classes/db/mysql/query_factory.php on line 155

My configuration is the following:
Zen-Cart v1.5.4 Database Patch Level: 1.5.4 (From Server_info.php)
Edit Order 4.1.4
Reward Points 2.5e
Centos 6 Linux 2.6.32-504.23.4.el6.x86_64
MySQL 5.6.23-log (AWS RDS)
Apache/2.2.15
PHP 5.6.10

I can't seem to figure what's causing this, and kinda stumped on how to go about fixing it. Any insight would be most appreciated!