Edit Orders v4.0 Support Thread

**wsworx** · 27 Oct 2020, 07:25 PM

1.5.7 New Installation with upgraded database from 1.5.6
PHP7.4
Name: Current PlugIn List.png
Views: 126
Size: 3.0 KB

The twitch Hidden Model has been removed for now, the list is an image not actual typing, but all other plugins are installed and functioning

When I update the prices of the order and click "Update" the price stay the same.
I enabled debugging for one attempt at changing prices but the log is too long to post and I cannot figure out how to attach a .txt file as the system just keeps telling me it is an invalid file. So I posted the portion of the log pertaining to the change of pricing.
I have removed the beginning of the URL for security
Your assistance would be greatly appreciated.

Code:

============================================================
= Creating display of Order Product #31725
============================================================
Product Details:
{"qty":1,"id":"1740",
"orders_products_id":"31725",
"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG",
"model":"Varies, See List on item page",
"tax":"0.0000",
"price":"229.9900",
"final_price":"229.9900",
"onetime_charges":"0.0000",
"products_priced_by_attribute":"0",
"product_is_free":"0",
"products_discount_type":"0",
"products_discount_type_from":"0",
"products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0,"attributes":[{"option":"Big Dog Model",
"value":"Ridgeback",
"option_id":"28",
"value_id":"98",
"prefix":"+",
"price":"0.0000",
"product_attribute_is_free":1}]}


Options ID #28
Product Attribute: 
["3617"]
Options Info:
{"options":{"1469":"Boxer",
"1470":"Bulldog",
"1471":"Chopper",
"1472":"Mastiff",
"1473":"Pitbull",
"1474":"Ridgeback"},"name":"Big Dog Model",
"type":"0",
"length":"32",
"size":"32",
"rows":"5"}

2020-10-27 17:56:34, Edit Orders entered (4.5.3) action (update_order)
Enabled Order Totals: ot_subtotal.php;ot_onetime_discount.php;ot_shipping.php;ot_tax.php;ot_loworderfee.php;ot_total.php
getOrderInfo(update_order), on entry: Called by ***/edit_orders.php on line #326
	Subtotal: (not set), Shipping: (not set), Shipping Tax-Rate:  (not set), Shipping Tax-Description:  (not set), Shipping Tax: (not set), Tax: 0.0000, Total: 788.2900, Tax Groups: {"0.0000":"1"}
	$_SESSION['shipping']: (not set)

Order Totals
		ot_subtotal. Text: $779.99, Value: 779.9900
		ot_shipping. Text: $8.30, Value: 8.3000
		ot_total. Text: $788.29, Value: 788.2900


getProductTaxes(Tax)
{"products_tax_class_id":"1"}{"qty":1,"id":"1932","orders_products_id":"31724","name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2","model":"000-00005-8Cv2","tax":"0.0000","price":"550.0000","final_price":"550.0000","onetime_charges":"0.0000","products_priced_by_attribute":"0","product_is_free":"0","products_discount_type":"0","products_discount_type_from":"0","products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0}
getProductTaxes, returning 0.


getProductTaxes(Tax)
{"products_tax_class_id":"0"}{"qty":1,"id":"1740","orders_products_id":"31725","name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG","model":"Varies, See List on item page","tax":"0.0000","price":"229.9900","final_price":"229.9900","onetime_charges":"0.0000","products_priced_by_attribute":"0","product_is_free":"0","products_discount_type":"0","products_discount_type_from":"0","products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0,"attributes":[{"option":"Big Dog Model","value":"Ridgeback","option_id":"28","value_id":"98","prefix":"+","price":"0.0000","product_attribute_is_free":1}]}
getProductTaxes, returning 0.

getOrderInfo(update_order), on exit:

	Subtotal: 779.99, Shipping: (not set), Shipping Tax-Rate:  (not set), Shipping Tax-Description:  (not set), Shipping Tax: (not set), Tax: 0.0000, Total: 788.2900, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: (not set)

Order Totals
		ot_subtotal. Text: $779.99, Value: 779.9900
		ot_shipping. Text: $8.30, Value: 8.3000
		ot_total. Text: $788.29, Value: 788.2900


Order Subtotal: 779.99

Order Totals
		ot_subtotal. Text: $779.99, Value: 779.9900
		ot_shipping. Text: $8.30, Value: 8.3000
		ot_total. Text: $788.29, Value: 788.2900
Order Tax (total): 0.0000
Order Tax Groups:
{"Tax":0}
eoInitializeShipping(7489, update_order), on entry: 
	Subtotal: 0, Shipping: 0, Shipping Tax-Rate:  (not set), Shipping Tax-Description:  (not set), Shipping Tax: 0, Tax: 0, Total: 0, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: (not set)

Order Totals

initializeShippingCostFromPostedValue, ot_shipping: {"code":"ot_shipping","shipping_module":"usps","title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","value":"8.3000"}, shipping cost: 8.3.
calculateOrderShippingTax returning 0, rate = '0.0000', cost = 8.3.
eoInitializeShipping(7489, update_order), on exit: 
	Subtotal: 0, Shipping: 8.3, Shipping Tax-Rate: 0.0000, Shipping Tax-Description:  (not set), Shipping Tax: 0, Tax: 0, Total: 0, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: {"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","id":"usps_","cost":8.300000000000000710542735760100185871124267578125}

Order Totals


Requested Products:
{"31724":{"qty":"1",
"name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2",
"model":"000-00005-8Cv2",
"tax":"0.0",
"final_price":"495.00"},"31725":{"qty":"1",
"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG",
"onetime_charges":"0.0000",
"attr":{"28":{"value":"1474",
"type":0}},"model":"Varies, See List on item page",
"tax":"0.0",
"final_price":"206.99"}}
Products in Original Order: 
[{"qty":1,"id":"1932",
"orders_products_id":"31724",
"name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2",
"model":"000-00005-8Cv2",
"tax":"0.0000",
"price":"550.0000",
"final_price":"550.0000",
"onetime_charges":"0.0000",
"products_priced_by_attribute":"0",
"product_is_free":"0",
"products_discount_type":"0",
"products_discount_type_from":"0",
"products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0},
{"qty":1,"id":"1740",
"orders_products_id":"31725",
"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG",
"model":"Varies, See List on item page",
"tax":"0.0000",
"price":"229.9900",
"final_price":"229.9900",
"onetime_charges":"0.0000",
"products_priced_by_attribute":"0",
"product_is_free":"0",
"products_discount_type":"0",
"products_discount_type_from":"0",
"products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0,"attributes":[{"option":"Big Dog Model",
"value":"Ridgeback",
"option_id":"28",
"value_id":"98",
"prefix":"+",
"price":"0.0000",
"product_attribute_is_free":1}]}]

Order Product ID: 31724 Row ID: 0
Product in Request: 
{"qty":1,"name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2",
"model":"000-00005-8Cv2",
"tax":"0.0",
"final_price":"495.00"}

Old Product:
{"qty":1,"id":"1932",
"orders_products_id":"31724",
"name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2",
"model":"000-00005-8Cv2",
"tax":"0.0000",
"price":"550.0000",
"final_price":"550.0000",
"onetime_charges":"0.0000",
"products_priced_by_attribute":"0",
"product_is_free":"0",
"products_discount_type":"0",
"products_discount_type_from":"0",
"products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0}
Old Order Subtotal: 0
Old Order Totals: Old Tax (total): 0
Old Tax Groups:
{"Tax":0}

Removed Product Order Subtotal: 0
Removed Product Order Totals: Removed Product Tax (total): 0
Removed Product Tax Groups:
{"Tax":0}
eo_update_order_subtotal (1), taxes on entry.  Called by ***/edit_orders.php on line #476
	Subtotal: 0, Shipping: 8.3, Shipping Tax-Rate: 0.0000, Shipping Tax-Description:  (not set), Shipping Tax: 0, Tax: 0, Total: 0, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: {"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","id":"usps_","cost":8.300000000000000710542735760100185871124267578125}

Order Totals


getProductTaxes(Tax)
false{"qty":1,"name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2","model":"000-00005-8Cv2","tax":0,"final_price":"550.0000","id":1932,"price":"550.0000","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_description":"Tax","onetime_charges":0}
getProductTaxes, returning 0.

eo_update_order_subtotal, taxes on exit. 
	Subtotal: 550, Shipping: 8.3, Shipping Tax-Rate: 0.0000, Shipping Tax-Description:  (not set), Shipping Tax: 0, Tax: 0, Total: 558.3, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: {"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","id":"usps_","cost":8.300000000000000710542735760100185871124267578125}

Order Totals


Pricing was automatically calculated, without specials pricing.
Added Product:
{"qty":1,"name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2",
"model":"000-00005-8Cv2",
"tax":0,"final_price":"550.0000",
"id":1932,"price":"550.0000",
"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_description":"Tax",
"onetime_charges":0}
Added Product Order Subtotal: 550
Added Product Order Totals:Added Product Tax (total): 0
Added Product Tax Groups:
{"Tax":0}

Order Product ID: 31725 Row ID: 0
Product in Request: 
{"qty":1,"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG",
"onetime_charges":"0.0000",
"attr":{"28":{"value":"1474",
"type":0}},"model":"Varies, See List on item page",
"tax":"0.0",
"final_price":"206.99"}

Old Product:
{"qty":1,"id":"1740",
"orders_products_id":"31725",
"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG",
"model":"Varies, See List on item page",
"tax":"0.0000",
"price":"229.9900",
"final_price":"229.9900",
"onetime_charges":"0.0000",
"products_priced_by_attribute":"0",
"product_is_free":"0",
"products_discount_type":"0",
"products_discount_type_from":"0",
"products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0,"attributes":[{"option":"Big Dog Model",
"value":"Ridgeback",
"option_id":"28",
"value_id":"98",
"prefix":"+",
"price":"0.0000",
"product_attribute_is_free":1}]}
Old Order Subtotal: 550
Old Order Totals: Old Tax (total): 0
Old Tax Groups:
{"Tax":0}

Removed Product Order Subtotal: 550
Removed Product Order Totals: Removed Product Tax (total): 0
Removed Product Tax Groups:
{"Tax":0}
eo_get_new_product, adding attribute: {"value":"1474","type":0}, {"option_id":"28","value_id":"98","value":"Ridgeback"}
eo_update_order_subtotal (1), taxes on entry.  Called by ***/edit_orders.php on line #476
	Subtotal: 550, Shipping: 8.3, Shipping Tax-Rate: 0.0000, Shipping Tax-Description:  (not set), Shipping Tax: 0, Tax: 0, Total: 558.3, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: {"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","id":"usps_","cost":8.300000000000000710542735760100185871124267578125}

Order Totals


getProductTaxes(Tax)
false{"qty":1,"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG","onetime_charges":0,"model":"Varies, See List on item page","tax":0,"final_price":229.990000000000009094947017729282379150390625,"id":1740,"price":"229.9900","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_description":"Tax","attributes":[{"option_id":"28","value_id":"98","value":"Ridgeback"}]}
getProductTaxes, returning 0.

eo_update_order_subtotal, taxes on exit. 
	Subtotal: 779.99, Shipping: 8.3, Shipping Tax-Rate: 0.0000, Shipping Tax-Description:  (not set), Shipping Tax: 0, Tax: 0, Total: 788.29, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: {"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","id":"usps_","cost":8.300000000000000710542735760100185871124267578125}

Order Totals


Pricing was automatically calculated, without specials pricing.
Added Product:
{"qty":1,"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG",
"onetime_charges":0,"model":"Varies, See List on item page",
"tax":0,"final_price":229.990000000000009094947017729282379150390625,"id":1740,"price":"229.9900",
"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_description":"Tax",
"attributes":[{"option_id":"28",
"value_id":"98",
"value":"Ridgeback"}]}
Added Product Order Subtotal: 779.99
Added Product Order Totals:Added Product Tax (total): 0
Added Product Tax Groups:
{"Tax":0}

Updated Products in Order:
[{"qty":1,"name":"BIG DOG EHC 05 to 11 CARB OR EFI VERSION 2",
"model":"000-00005-8Cv2",
"tax":0,"final_price":"550.0000",
"id":1932,"price":"550.0000",
"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_description":"Tax",
"onetime_charges":0,"stock_reduce":1},
{"qty":1,"name":"BACKBONE WIRE HARNESS MAIN 04 BIG DOG",
"onetime_charges":0,"model":"Varies, See List on item page",
"tax":0,"final_price":229.990000000000009094947017729282379150390625,"id":1740,"price":"229.9900",
"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_description":"Tax",
"attributes":[{"option_id":"28",
"value_id":"98",
"value":"Ridgeback"}],"stock_reduce":1}]
Updated Products Order Totals:Updated Products Tax (total): 0
Updated Products Tax Groups:
{"Tax":0}


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

Requested Order Totals:
[{"code":"ot_shipping",
"shipping_module":"usps",
"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):",
"value":"8.3000"},
{"code":"ot_onetime_discount",
"title":"",
"value":"",
"shipping_module":"usps"},
{"code":"ot_tax",
"title":"",
"value":0}]
Starting Order Totals:Starting Tax (total): 0
Starting Tax Groups:
{"Tax":0}
eo_update_database_order_total: and_clause: (), found (0), {"code":"ot_shipping",
"shipping_module":"usps",
"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):",
"value":8.300000000000000710542735760100185871124267578125,"text":"$8.30",
"sort_order":104}
eo_update_database_order_total: and_clause: (), found (1), {"code":"ot_onetime_discount",
"title":"",
"value":0,"shipping_module":"usps",
"text":"$0.00",
"sort_order":102}
eo_update_database_order_total: and_clause: (), found (1), {"code":"ot_tax",
"title":"",
"value":0,"text":"$0.00",
"sort_order":"300"}

eo_update_database_order_totals, taxes/totals on entry.  Called by ***/edit_orders.php on line #648
	Subtotal: 779.99, Shipping: 8.3, Shipping Tax-Rate: 0.0000, Shipping Tax-Description:  (not set), Shipping Tax: 0, Tax: 0, Total: 788.29, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: {"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","id":"usps_","cost":8.300000000000000710542735760100185871124267578125}

Order Totals
		ot_shipping. Text: $8.30, Value: 8.3
		ot_onetime_discount. Text: $0.00, Value: 0
		ot_tax. Text: $0.00, Value: 0

Checking taxes for ot_onetime_discount: Tax class (MODULE_ORDER_TOTAL_ONETIME_DISCOUNT_TAX_CLASS:), 0
eo_update_database_order_totals, after adjustments: {"order_id":7489,"currency":"USD",
"currency_value":"1.000000",
"payment_method":"Check\/Money Order",
"payment_module_code":"moneyorder",
"shipping_method":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):",
"shipping_module_code":"usps",
"coupon_code":"",
"cc_type":"",
"cc_owner":"",
"cc_number":"",
"cc_cvv":null,"cc_expires":"",
"date_purchased":"2020-10-27 17:36:39",
"orders_status":"1",
"total":788.2899999999999636202119290828704833984375,"tax":0,"last_modified":"2020-10-27 17:56:34",
"ip_address":"107.204.159.118 - 107.204.159.118",
"language_code":"en",
"tax_groups":{"Tax":0},"subtotal":779.990000000000009094947017729282379150390625,"shipping_cost":8.300000000000000710542735760100185871124267578125,"shipping_tax":0,"shipping_tax_rate":"0.0000"}
eoUpdateOrderShippingTax(, 0.0000, Tax): {"0.0000":"Tax","0":"Tax"}
eo_update_database_order_totals, after process: {"order_id":7489,"currency":"USD",
"currency_value":"1.000000",
"payment_method":"Check\/Money Order",
"payment_module_code":"moneyorder",
"shipping_method":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):",
"shipping_module_code":"usps",
"coupon_code":"",
"cc_type":"",
"cc_owner":"",
"cc_number":"",
"cc_cvv":null,"cc_expires":"",
"date_purchased":"2020-10-27 17:36:39",
"orders_status":"1",
"total":788.2899999999999636202119290828704833984375,"tax":0,"last_modified":"2020-10-27 17:56:34",
"ip_address":"107.204.159.118 - 107.204.159.118",
"language_code":"en",
"tax_groups":{"Tax":0},"subtotal":779.990000000000009094947017729282379150390625,"shipping_cost":8.300000000000000710542735760100185871124267578125,"shipping_tax":0,"shipping_tax_rate":"0.0000"}
[{"code":"ot_subtotal",
"title":"Sub-Total:",
"text":"$779.99",
"value":779.990000000000009094947017729282379150390625,"sort_order":"100"},
{"code":"ot_shipping",
"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day))::",
"text":"$8.30",
"value":8.300000000000000710542735760100185871124267578125,"sort_order":104},
{"code":"ot_total",
"title":"Total:",
"text":"$788.29",
"value":788.2899999999999636202119290828704833984375,"sort_order":"999"}]
[{"class":"ot_shipping",
"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):",
"value":8.300000000000000710542735760100185871124267578125,"text":"$8.30",
"sort_order":104},
{"class":"ot_onetime_discount",
"title":"",
"value":0,"text":"$0.00",
"sort_order":102},
{"class":"ot_tax",
"title":"",
"value":0,"text":"$0.00",
"sort_order":"300"}]
eo_update_database_order_total: and_clause: (), found (0), {"code":"ot_subtotal",
"title":"Sub-Total:",
"text":"$779.99",
"value":779.990000000000009094947017729282379150390625,"sort_order":"100"}
eo_update_database_order_total: and_clause: (), found (0), {"code":"ot_shipping",
"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):",
"text":"$8.30",
"value":8.300000000000000710542735760100185871124267578125,"sort_order":104}
eo_update_database_order_total: and_clause: (), found (0), {"code":"ot_total",
"title":"Total:",
"text":"$788.29",
"value":788.2899999999999636202119290828704833984375,"sort_order":"999"}
Removing order-total, and-clause: title = '' OR `class` = 'ot_onetime_discount'
Removing order-total, and-clause: title = '' OR `class` = 'ot_tax'
eo_update_database_order_totals, removing tax groups NOT IN ('Tax:').
eo_update_database_order_totals, taxes on exit. 
	Subtotal: 779.99, Shipping: 8.3, Shipping Tax-Rate: 0.0000, Shipping Tax-Description: Tax, Shipping Tax: 0, Tax: 0, Total: 788.29, Tax Groups: {"Tax":0}
	$_SESSION['shipping']: {"title":"United States Postal Service (2.50lbs) (Priority Mail\u2122 Small Flat Rate Box (2-day)):","id":"usps_","cost":8.300000000000000710542735760100185871124267578125}

Order Totals
		ot_shipping. Text: $8.30, Value: 8.3
		ot_onetime_discount. Text: $0.00, Value: 0
		ot_tax. Text: $0.00, Value: 0


Order Totals
		ot_shipping. Text: $8.30, Value: 8.3
		ot_onetime_discount. Text: $0.00, Value: 0
		ot_tax. Text: $0.00, Value: 0

Updated Tax (total): 0
Updated Tax Groups:
{"Tax":0}

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

Final Subtotal: 779.99
Final Totals:		ot_shipping. Text: $8.30, Value: 8.3
		ot_onetime_discount. Text: $0.00, Value: 0
		ot_tax. Text: $0.00, Value: 0
Final Tax (total): 0
Final Tax Groups:
{"Tax":0}

**lat9** · 27 Oct 2020, 07:47 PM

@wsworx, to manually apply pricing, you need to change EO's setting for the Product Price Calculation method.

Code:

Pricing was automatically calculated, without specials pricing.

**wsworx** · 27 Oct 2020, 07:54 PM

Thank You for the response
I figured it had to be something I was or was not doing.

**lat9** · 31 Oct 2020, 01:40 PM

I've just submitted v4.5.4 of Edit Orders for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#171: Correct PHP notice during product addition.
#172: Correct PHP notices thrown by the ot_shipping constructor.
#173: Correct coloring of EO buttons/icons added to a zc157 version of the admin's Orders listing.
#177: Use role="table" for the EO address-block as an aid to screen readers (thanks, @jage9!).

**lat9** · 5 Nov 2020, 01:35 PM

Originally Posted by lat9

I've just submitted v4.5.4 of Edit Orders for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#171: Correct PHP notice during product addition.
#172: Correct PHP notices thrown by the ot_shipping constructor.
#173: Correct coloring of EO buttons/icons added to a zc157 version of the admin's Orders listing.
#177: Use role="table" for the EO address-block as an aid to screen readers (thanks, @jage9!).

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1513

**OldNGrey** · 6 Nov 2020, 10:44 PM

When a new product is added to an order the products_weight value is set to null. This occurs every time. The field "products_weight" is defined as float in the db.

Code:

============================================================
= Creating display of Order Product #19865
============================================================
Product Details:
{"qty":1,"id":"19",
"orders_products_id":"19865",
"name":"Clutch springs, Norton (set 3)",
"model":"EM608",
"tax":"10.0000",
"price":"13.6364",
"final_price":"13.6364",
"onetime_charges":"0.0000",
"products_priced_by_attribute":"0",
"product_is_free":"0",
"products_discount_type":"0",
"products_discount_type_from":"0",
"products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0}

environment Dev: Zen Cart 157a; Apache 2.4.46; PHP 7.4.9; MySQL 5.7.31; Windows 10

**lat9** · 7 Nov 2020, 02:47 PM

Originally Posted by OldNGrey

When a new product is added to an order the products_weight value is set to null. This occurs every time. The field "products_weight" is defined as float in the db.

Code:

============================================================
= Creating display of Order Product #19865
============================================================
Product Details:
{"qty":1,"id":"19",
"orders_products_id":"19865",
"name":"Clutch springs, Norton (set 3)",
"model":"EM608",
"tax":"10.0000",
"price":"13.6364",
"final_price":"13.6364",
"onetime_charges":"0.0000",
"products_priced_by_attribute":"0",
"product_is_free":"0",
"products_discount_type":"0",
"products_discount_type_from":"0",
"products_weight":null,"products_virtual":0,"product_is_always_free_shipping":0,"products_quantity_order_min":null,"products_quantity_order_units":null,"products_quantity_order_max":null,"products_quantity_mixed":0,"products_mixed_discount_quantity":0}

environment Dev: Zen Cart 157a; Apache 2.4.46; PHP 7.4.9; MySQL 5.7.31; Windows 10

... and it's been like that as far back as EO v4.1.5! Thanks for the report, I've opened this GitHub issue to track the required changes.

**lat9** · 7 Nov 2020, 04:31 PM

Originally Posted by lat9

... and it's been like that as far back as EO v4.1.5! Thanks for the report, I've opened this GitHub issue to track the required changes.

Ah, the underlying cause is that EO hasn't 'kept up' with the database schema changes introduced in zc156:

Code:

ALTER TABLE orders_products ADD products_weight float default NULL;
ALTER TABLE orders_products ADD products_virtual tinyint(1) default NULL;
ALTER TABLE orders_products ADD product_is_always_free_shipping tinyint(1) default NULL;
ALTER TABLE orders_products ADD products_quantity_order_min float default NULL;
ALTER TABLE orders_products ADD products_quantity_order_units float default NULL;
ALTER TABLE orders_products ADD products_quantity_order_max float default NULL;
ALTER TABLE orders_products ADD products_quantity_mixed tinyint(1) default NULL;
ALTER TABLE orders_products ADD products_mixed_discount_quantity tinyint(1) default NULL;
ALTER TABLE orders_products_download ADD products_attributes_id int(11) default NULL;

**lat9** · 7 Nov 2020, 04:44 PM

Noting, too, that the orders table was also updated to include an order_weight field for zc156; that field's not updated on order-update/addition either.

**marton_1** · 8 Nov 2020, 05:39 PM

On my English language web site I see a nice picture of a wrench on the right side of the order page and when I click on it I jump into edit order mode.
On my foreign language site, I see the default text; the link to edit order mode works OK.
It is not a bug, just a nice to have if you ever have some spare time.

Thread: Edit Orders v4.0 Support Thread

Thread Tools

Search Thread

Display

Re: Edit Orders v4.0 Support Thread

Re: Edit Orders v4.0 Support Thread

Re: Edit Orders v4.0 Support Thread

Re: Edit Orders v4.0 Support Thread

Re: Edit Orders v4.0 Support Thread

Edit Orders - not copying products_weight value

Re: Edit Orders - not copying products_weight value

Re: Edit Orders - not copying products_weight value

Re: Edit Orders - not copying products_weight value

Re: Edit Orders - not copying products_weight value

Similar Threads

v150 Super Orders v4.0 Support Thread for ZC v1.5.x

v150 Orders Status History -- Updated By [Support Thread]

Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

v139h Super Orders v3.0 Support Thread (for ZC v1.3.9)

RE: Super Orders v3.0 Support Thread

Bookmarks

Bookmarks

Posting Permissions