1 Attachment(s)
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.
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}
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.
Code:
Pricing was automatically calculated, without specials pricing.
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.
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!).
Re: Edit Orders v4.0 Support Thread
Quote:
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
Edit Orders - not copying products_weight value
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
Re: Edit Orders - not copying products_weight value
Quote:
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.
Re: Edit Orders - not copying products_weight value
Quote:
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;
Re: Edit Orders - not copying products_weight value
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.:(
Re: Edit Orders - not copying products_weight value
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.
