Zen Cart Logo
Forums / Addon Admin Tools / Edit Orders v4.0 Support Thread

Edit Orders v4.0 Support Thread

Views: 346,083

Results 1,601 to 1,620 of 1,927
25 Oct 2020, 5:08 PM
#1601
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Edit Orders v4.0 Support Thread

Carbonless:

From the downloads the zip did not contain a readme file... these instructions are what i'm looking for..

Yes it does.

See the zip's /docs/edit_orders/readme.html file. Double-click to open it with your browser.

25 Oct 2020, 5:54 PM
#1602
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

Elemi:

I tried installing this mod on my new 1.5.7 install on Friday evening (have it on my old 1.3.7h working fine for years) with the Westnminster-new template and it didn't like it at all. Followed all the steps in order, did the tax changes, etc. It didn't activate in the admin area, and then when I went to the storefront, no products were showing. Went through all the files again to make sure I hadn't missed one... nope, all there, So i uninstalled it and will hope that one day it actually becomes a built in feature as it is a very handy tool to have when clients want to add to their order.
"it didn't like it at all" doesn't tell me much. Were there debug-logs generated?

25 Oct 2020, 5:55 PM
#1603
carbonless avatar

carbonless

Zen Follower

Join Date:
Jan 2007
Location:
Illinois, USA
Posts:
329
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

THANK YOU! for whatever reason, when i opened the zip, my mac wasnt uncompressing that file, but i could open it from within the zip...

That is what I was looking for.

27 Oct 2020, 6:25 PM
#1604
wsworx avatar

wsworx

Zen Follower

Join Date:
Jun 2012
Location:
California
Posts:
260
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

1.5.7 New Installation with upgraded database from 1.5.6
PHP7.4
Attachment 19262

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.

============================================================
= 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}
27 Oct 2020, 6:47 PM
#1605
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

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

Pricing was automatically calculated, without specials pricing.
27 Oct 2020, 6:54 PM
#1606
wsworx avatar

wsworx

Zen Follower

Join Date:
Jun 2012
Location:
California
Posts:
260
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

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

31 Oct 2020, 12:40 PM
#1607
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

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!).

5 Nov 2020, 12:35 PM
#1608
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

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

6 Nov 2020, 9:44 PM
#1609
oldngrey avatar

oldngrey

Zen Follower

Join Date:
Apr 2008
Location:
Qld, Australia
Posts:
417
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

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.

============================================================
= 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

7 Nov 2020, 1:47 PM
#1610
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

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.

============================================================
= 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 ](https://github.com/lat9/edit_orders/issues/178)GitHub issue to track the required changes.
7 Nov 2020, 3:31 PM
#1611
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

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:

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;
7 Nov 2020, 3:44 PM
#1612
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

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.:(

8 Nov 2020, 4:39 PM
#1613
marton_1 avatar

marton_1

Totally Zenned

Join Date:
Apr 2013
Location:
eglisau switzerland
Posts:
568
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

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.

8 Nov 2020, 5:16 PM
#1614
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

marton_1:

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.
There were some additional language constants added for 'english'; you'll need to carry them over to your 'alternate' language definitions.

26 Nov 2020, 1:37 PM
#1615
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

Here's an odd one. A client has been using Edit Orders for a few years. We recently upgraded the site to Zen Cart 1.5.7a and EO 4.5.3.

They used to be able to enter a negative number for product quantity and price. They did this to track returns (yikes). It no longer allows negative numbers. I did a quick edit and when I enter a negative for the product quantity, the product is removed from the order.

What's the logic look like for quantity and price? Meaning is there a feasible way to allow them to use negative numbers for both?

26 Nov 2020, 3:30 PM
#1616
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

jeking:

Here's an odd one. A client has been using Edit Orders for a few years. We recently upgraded the site to Zen Cart 1.5.7a and EO 4.5.3.

They used to be able to enter a negative number for product quantity and price. They did this to track returns (yikes). It no longer allows negative numbers. I did a quick edit and when I enter a negative for the product quantity, the product is removed from the order.

What's the logic look like for quantity and price? Meaning is there a feasible way to allow them to use negative numbers for both?
What Zen Cart/EO version was in use previously? I'd need more information to see if there's a way to allow this non-standard use to be included in the EO base processing.

26 Nov 2020, 4:08 PM
#1617
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

lat9:

What Zen Cart/EO version was in use previously? I'd need more information to see if there's a way to allow this non-standard use to be included in the EO base processing.

Zen Cart 1.5.6c
EO 4.5.3, so the same

26 Nov 2020, 5:46 PM
#1618
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

jeking:

Zen Cart 1.5.6c
EO 4.5.3, so the same
OK, if the same version of EO was working on zc156c, then there's something going on with the zc157 interactions.

4 Dec 2020, 7:22 AM
#1619
oldngrey avatar

oldngrey

Zen Follower

Join Date:
Apr 2008
Location:
Qld, Australia
Posts:
417
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

Using Edit Orders 4.5.4 with zc 157b

The Total Price column is the total of the Net Price not the Gross Price for the row. The Sub-Total below the Total Price column is the Sub-Total of the Gross.[Attachment no longer available]

Previous versions hadn't shown the Gross price. Is it possible to show the Total Price as the actual Gross total for the row?

4 Dec 2020, 11:56 AM
#1620
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,069
Plugin Contributions:
56

Re: Edit Orders v4.0 Support Thread

OldNGrey:

Using Edit Orders 4.5.4 with zc 157b

The Total Price column is the total of the Net Price not the Gross Price for the row. The Sub-Total below the Total Price column is the Sub-Total of the Gross.[Attachment no longer available]

Previous versions hadn't shown the Gross price. Is it possible to show the Total Price as the actual Gross total for the row?
Absolutely. I've created a GitHub issue (https://github.com/lat9/edit_orders/issues/180) to track the associated change. That'll be part of EO v4.5.5, coming real-soon-now.