Hi just tried installing this on 1.5.6a, but I get this message when I try to use it:
The store's zen_add_tax function must be updated to enable Edit Orders' use
Do I need to update to 1.5.6b?
Printable View
Hi just tried installing this on 1.5.6a, but I get this message when I try to use it:
The store's zen_add_tax function must be updated to enable Edit Orders' use
Do I need to update to 1.5.6b?
Nope, just provide that update to /admin/includes/functions/general.php, as identified in the readme's Installation->Changes to zen_add_tax tab.
Thanks for the quick response, for some reason I totally missed that tab!
Now works great.
One minor thing, we use the Invoice payment method module, which uses group pricing
I think that is why I am unable to change the unit price of a product.
No big deal, I don't see us needing to do that anyway.
Thanks for a great Add on!
Ya, Just wanted to be thorough and provide enough info regarding the logs (ie. don't see anything relating to EO) :blush:Quote:
Originally Posted by lat9
I'm not familiar with that payment module, but changing the EO configuration so that you can enter prices Manually should allow you to provide those price overrides.Quote:
Originally Posted by wyliecoyoteuk
Hi,
I've just updated this module from the previous version, and have encountered a major issue. The site is running on ZC 1.5.5e, and one of the additional modules installed is Dual Pricing which, as you may know, allows both a wholesale and retail price to be set for products. The customer gets to see the correct price based on a customer status setting.
In testing, the new version seems to work correctly in other areas, but when an order for a wholesale customer is edited to add an additional product to the order, the additional product is added using the retail price. This make the new version totally un-useable on the site. This is the second time I have installed the update, and after checking all the merges.
I might also add that Super Orders is also installed, that I found that trying to merge zc155/YOUR_ADMIN/orders.php the existing version a nightmare beyond my capabilities, so I used the current version on the site.
I would appreciate any help in resolving the retail/wholesale pricing issue. I might add that this feature works correctly with previous versions of Edit Orders.
I'd be interested to know what the "previous version(s)" were, since I've never seen an integration between EO and Dual Pricing.Quote:
Originally Posted by donw
I didn't suggest there is an "integration" between the modules. Just that both modules have been installed on the site without any problems, and certainly since EO 4.3.3.
What are the EO 4.3.3 configuration settings?Quote:
Originally Posted by donw
4.3.5 is installed and functions correctly, other than the tax calculation issue. Configuration settings are:
Reset Totals on Update - Default on
Strip tags... true
Debug action level 0
Product Price Calculation - Method Manual
Product Price Calculation - Default Manual
Status-history Display order Asc
Status-update..... Email
Super Orders Module Switch True
@donw, having re-read your initial posting (#1407), I'll note that when a product is added to an order via EO that the in-store price calculations are always used. If the price returned for your dual-pricing-enabled customers, I'll have to suggest that somewhere that ability to apply those pricing alternations in the admin have 'disappeared'.
Additionally, those configuration settings that you posted in #1411 are for EO v4.4.0 (that's when the Status-history/Display order and update-email settings were introduced).
Are you saying that the Dual-pricing worked for v4.3.5 and not for v4.4.0? Please advise.
Ok. To address the issue of EO configuration settings first. The EO configuration page shows version 4.3.5, and I'm assuming those option have remained as, after discovering the problem with pricing after installing 4.4.02, I simply reverted back to the 4.3.5 versions of the site files, which possibly was not the best way of doing things
Yes, I am saying that Dual Pricing worked correctly, and still does, with 4.3.5, and does not with 4.4.02.
@donw, I'm quite befuddled as I don't understand how the Dual Pricing works with 4.3.5. What version of Dual Pricing and where did you get it?Quote:
Originally Posted by donw
Version 2.1.7(a) from the Zencart site.
Thanks, I'll look into that later this week.Quote:
Originally Posted by donw
I've taken that look and still don't understand how the dual-pricing ever worked with EO (v4.3.5 or whatever). Looking at the 2.1.7a version, its changes to the /admin/includes/functions/functions_prices.php look "off" to me, specifically zen_get_products_special_price which is used by EO:Quote:
Originally Posted by lat9
If the specified product exists, that section of code will never execute, since its condition is satisfied by the if/else clause the precedes it.Code://get specials price or sale price
function zen_get_products_special_price($product_id, $specials_price_only=false) {
global $db;
$product = $db->Execute("select products_price, products_model, products_priced_by_attribute from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");
if ($product->RecordCount() > 0) {
// $product_price = $product->fields['products_price'];
$product_price = zen_get_products_base_price($product_id);
} else {
return false;
}
// Dual Pricing start
if ($product->RecordCount() > 0) {
// $product_price = $product->fields['products_price'];
$product_price = zen_get_products_base_price_w($product_id);
} else {
return false;
}
// Dual Pricing end
$specials = $db->Execute("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$product_id . "' and status='1'");
if ($specials->RecordCount() > 0) {
// if ($product->fields['products_priced_by_attribute'] == 1) {
$special_price = $specials->fields['specials_new_products_price'];
} else {
$special_price = false;
}
FWIW, I don't recall any integration between Dual Pricing and Edit Orders. I have used DP many times, but EO only rarely but in my usage and maintaining of DP was never aware of any. Just my $0.02
Thanks for the confirmation, @jeking!Quote:
Originally Posted by jeking
Must be getting tired eyes or something.Quote:
Originally Posted by lat9
If the product exists, then the base code will set $products_price to the base price for the product and then procede to the next grouping of code which is now the dual pricing if statement. Again, if the product exists (which it does at this point because this section of code has been reached), then the price is "reset" to what dual pricing wants it to be. Yes, if the product didn't exist, then the else of that statement won't exist and $products_price has been potentially set to two different values, but the price setting would be reachable.
Not sure why the choice to leave the base code in operation was made, but at least removing the dual pricing code would be easy to identify, right? :).
You're correct, @mc12345678; I'm having a bad day!
Sorry to hear, if it helps any, take an inventory: let's see pulse, check. No loss of appendages today, check. Haven't poked my eyes out, check. Whew, could be worse. :)Quote:
Originally Posted by lat9
Now I can't speak to the interoperability, but like so many of the other things posted, I've been reading along and that one caught my eye. Not to mention that when I've merged that file on other's servers I always ask myself, why was it done that way?
Anyways, bound to get better. :)
Just wondering...has anyone figured this out yet? It seems as though the processing just gets cut off each time. Would it be a memory problem?
Quote:
Originally Posted by jvdd
@jvdd, a memory issue would be my guess. Check your store's /logs directory for some myDEBUG-adm-*.log file(s) on/around the time you attempted to update that order.
My greetings to the edit orders team.
I just changed of server my website with zen cart. These are the data of my instalation and server:
Zen Cart 1.5.1
Data Base: MySQL 5.5.30
Versión PHP: 5.3.3 (Zend: 2.3.0)
The problem is when I am adding products to an order already placed since the admin page, I get the next error shown in the log:
[19-Jun-2019 19:00:46] PHP Fatal error: 1364:Field 'products_prid' doesn't have a default value :: insert into
zen_orders_products_attributes set
The table zen_orders_products_attributes has the same parameters in my previous server, and never appeared that error. I checked it. "products_prid" had no default value and it still worked. So what is the cause of this error now? Any advice?
Thanks in advance.
You don't say which version of Edit Orders that you're using, but given that you're running on zc1.5.1 it's most likely a no-longer-supported version.Quote:
Originally Posted by armytags.com
My best guess is that your new server has a more strict version of MySQL installed as that's where the fatal error you identified will come from.
My apologies:
Edit Orders 4.0.4.
"My best guess is that your new server has a more strict version of MySQL installed as that's where the fatal error you identified will come from."
Ok, and how can I solve it? upgrading edit orders?
Thanks for your answer.
Check your store's /logs directory for myDEBUG-adm-*.log files created on/about the time that the EO order-update failed. Post the contents of the file located using 'CODE' tags (the big # in the menu-bar when you're writing a post) and be sure to xxx-out the name of your admin sub-directory as I'm sure that it's part of the debug-log.
Ok. I think I got it. My apologies if I don't follow well your requests.
This was the first one (I' ll explain later) when I tried to add an item to an order:
After doing some research, and reading some posts about that error 1364, I went to the DB with PHP admin, located the table "zen_orders_products_attributes", changed the default value of "products_prid" to NULL and tried again. Then it gave me an error message again, but this time I checked the order and the product was added to the order. I checked the myDEBUG log and found this message:Code:[20-Jun-2019 03:37:33] PHP Fatal error: 1364:Field 'products_prid' doesn't have a default value :: insert into zen_orders_products set
orders_id = 12094,
products_id = 3,
products_model = '',
products_name = 'Order Pair of Silencers Black',
products_price = '1.5000',
final_price = '1.5',
products_tax = '0',
products_quantity = 1,
onetime_charges = 0; in /storage/xxxx/xxxx/xxxxxxx/public_html/xxxxx/includes/classes/db/mysql/query_factory.php on line 120
After receiving that message I changed the default value to NONE again, because I wasn't sure if that change could affect the normal placing of orders by the website. Should I change it back to some value to avoid this problem?Code:[20-Jun-2019 03:40:32] PHP Fatal error: 1364:Field 'products_prid' doesn't have a default value :: insert into zen_orders_products_attributes set
orders_id = 12094,
orders_products_id = 2731,
products_options = 'Silenciadores',
products_options_values = 'Negro',
options_values_price = '0.0000',
products_options_id = '2',
products_options_values_id = '4',
price_prefix = '',
product_attribute_is_free = '0',
products_attributes_weight = '0',
products_attributes_weight_prefix = '',
attributes_discounted = '0',
attributes_price_base_included = '0',
attributes_price_onetime = '0.0000',
attributes_price_factor = '0.0000',
attributes_price_factor_offset = '0.0000',
attributes_price_factor_onetime = '0.0000',
attributes_price_factor_onetime_offset = '0.0000',
attributes_qty_prices = '',
attributes_qty_prices_onetime = '',
attributes_price_words = '0.0000',
attributes_price_words_free = '0',
attributes_price_letters = '0.0000',
attributes_price_letters_free = '0'; in /xxxxxx/xxxx/xxx/xxxxxxx/public_html/xxxxx/includes/classes/db/mysql/query_factory.php on line 120
The options are: NONE, PERSONALIZED, NULL and CURRENT TIMESTAMP.
Thanks again for your answers.
@armytags.com, I'd thought that your posting of EO 4.0.4 was a typo as EO's current version is 4.4.0!
If you are you really running on Zen Cart 1.5.1 with EO 4.0.4, you'll need to update your Zen Cart so that you can have the benefit of all the changes and corrections over the past 7 years and then also update your Edit Orders installation to use the current version.
Although changing the database schema might get you past the symptom of the error you're experiencing, it's not addressing the root-cause of the issue (code should, and now does, set that required field) and has the possibility of causing follow-on issues when you do upgrade.
I also believe that may be the cause of the page/log not populating after clicking update. Thanks, I'll try to dig deeper.Quote:
Originally Posted by lat9
If it was a memory issue, how do I increase it?
Talk with your hosting company about this.Quote:
Originally Posted by jvdd
Hi,
I've been ill for the past couple of weeks with a cold/flu. Tonight I did some more investigating, and found that I had missed one small change in admin/includes/functions/extra_functions/edit_orders_functions.php.
Dual pricing requires the following change, which I had missed.
if (!$query->EOF) {
// Handle common fields
$retval = array_merge($retval, array(
'name' => $query->fields['products_name'],
'model' => $query->fields['products_model'],
'price' => $query->fields['products_price_w'],
I appreciate your time and help.
Yes, you are right. The thing is that the cart was working well with the old server for our modest needs, and I let me guide for the old saying: "if it is not broken, don't fix it". It is time for an update. Thanks for your time.Quote:
Originally Posted by lat9
I'm currently having an issue with this plugin. The unit price is not updating when changes are made, yet the success message after hitting "update" still appears.
We updated from Zen Cart 1.5.1 to 1.5.6f a few days ago. We use PHP 7.3 and MySQL 5.7.26. I've looked at the edit_orders error log but was unable to notice anything too out of the ordinary. All other edits made through this plugin are working fine such as quanitity, status, and attributes/pricing. It just isn't letting me update a unit price of a product. Let me know if there is any other information you need. The error log is quite long but if anyone knows an easy way to make that viewable I can follow steps to upload it somewhere.
Paste error log contents into the tags. I can confirm this same behavior in 1.5.6b and EO 4.4.0. I can update shipping and it does stay at the new value. But items with or without attributes cannot have the price updated. Items that are on special have the price reverted to the non-special price once the order is saved after changing the price to something else. PHP 7.1.30. No error logs.
Which "Price Calculation Method" are each of you using?
FWIW, I'm not seeing this behavior on EO 4.4.0 and zc156b. I've got Configuration->Edit Orders->Product Price Calculation Method set to Choose with a default of Auto.
I place a test order for a product that's on sale for $25.00 (normal price of $35.00). On entry to EO, the product price shows $25.00.
Using my defaults (i.e. auto without special pricing), I click "Update" and the price changes to $35.00.
Change the product-pricing method to auto, with specials pricing, click "Update" and the price changes back to $25.00.
Change the product-pricing method to as entered, change the price to 15.00, click "Update" and the price changes to $15.00.
Yep, that's me being unaware of the config settings. Pass me that sign you borrowed from dbltoe!
Baton passed!Quote:
Originally Posted by lankeeyankee
Hi, been using EO 4.4.0 for 1.5.6b and most work except for product quantity update. I can edit quantity in the order, but it does not deduct or add anything to the product stock quantity.
Thanks for the report. I've created this (https://github.com/lat9/edit_orders/issues/121) GitHub issue to track the change in the forthcoming v4.4.1 release.Quote:
Originally Posted by pugo0814
Just submitted for review by the Zen Cart moderators; once approved, the update can be downloaded here: https://www.zen-cart.com/downloads.php?do=file&id=1513
Thanks lat9 for the quick response.. will wait for the update then.
Ah, thanks guys! I had the price calculation set to 'Auto' instead of 'Manual'. Everything is working as intended!
You can also download the various EO distributions from its GitHub repository: https://github.com/lat9/edit_orders/releasesQuote:
Originally Posted by pugo0814
Please delete. Fixed issue by myself. Thanks!
That function (zen_get_products_manufacturers_id) is not a "standard" Zen Cart function. I suggest that you use your admin's Tools->Developers Tool Kit to find where it is defined on the storefront. Once found, you can create a copy of that function for use in the admin, creating a .php file in /admin/includes/functions/extra_functions to 'hold' that function's definition.Quote:
Originally Posted by monarchacct
Thank you for your reply! Much appreciated. I was able to easily fix this issue by changing mock shopping cart to false, per the documentation.Quote:
Originally Posted by lat9
However, I now have another issue. If I try to add a discount coupon to the order total, it works perfectly, but if I try to add an additional discount or charge, the module won't do it. Like I mentioned in my previous post, I use Table Discounts, and I forgot to mention I also use Priority Handling 1.3.0 for an optional rush charge to every order. If I try to apply either a rush charge or a discount, I get a "Success: Order has been successfully updated." but the charge won't appear. The funny thing is that there is no error message in the logs, and the edit order log does not even show that I was attempting to add an extra charge.
I did notice in the newer version that there is now a dropdown menu with items from our order totals modules, as opposed to the older version that we were using which only had blank fields. An additional question would be if there was an easy way to either add items to that dropdown or get rid of it altogether and have blank fields so our CSRs can type whatever they want and not depend on what modules are present in our order totals list?Code:2019-07-10 15:18:15, Edit Orders entered (4.3.5) action (edit)
Enabled Order Totals: ot_subtotal.php;ot_table_discounts.php;ot_coupon.php;ot_tax.php;ot_shipping.php;ot_priority_handling.php;ot_total.php
getOrderInfo, on entry: Called by /home2/xxxxxx/public_html/xxxxxxxx/admin/edit_orders.php on line #705
Subtotal: (not set), Shipping: (not set), Shipping Tax: (not set), Tax: 0.00, Total: 26.18, Tax Groups: {"0.0000":"1"}
$_SESSION['shipping']: {"title":"Shipping (UPS - UPS: Ground ($10.22) (1.75Lbs))","id":"advshipper_","cost":10.22}
Order Totals
ot_subtotal. Text: $19.95, Value: 19.9500
ot_coupon. Text: -$3.99, Value: 3.9900
ot_shipping. Text: $10.22, Value: 10.2200
ot_total. Text: $26.18, Value: 26.1800
Checking order for virtual status. Order contains 1 unique products, 0 of those are virtual
getProductTaxes(Tax)
{"products_tax_class_id":"1"}{"qty":1,"id":"537","name":"Columnar Sheet Double Page Ruling 24 Columns White<br><br>1021-2","model":"1021-24","tax":"0.0000","price":"19.9500","final_price":"19.9500","onetime_charges":"0.0000","products_priced_by_attribute":"0","product_is_free":"0","products_discount_type":"2","products_discount_type_from":"0"}
getProductTaxes, returning 0.
calculateOrderShippingTax, advshipper does not provide tax-information.
calculateOrderShippingTax returning 0.
getOrderInfo, on exit:
null
Subtotal: 19.95, Shipping: 10.22, Shipping Tax: 0, Tax: 0.00, Total: 26.18, Tax Groups: {"Tax":0}
$_SESSION['shipping']: {"title":"Shipping (UPS - UPS: Ground ($10.22) (1.75Lbs))::","id":"advshipper_","cost":10.22}
Order Totals
ot_subtotal. Text: $19.95, Value: 19.9500
ot_coupon. Text: -$3.99, Value: 3.9900
ot_shipping. Text: $10.22, Value: 10.2200
ot_total. Text: $26.18, Value: 26.1800
Checking order for virtual status. Order contains 1 unique products, 0 of those are virtual
============================================================
= Creating display of Order Product #46936
============================================================
Product Details:
{"qty":1,"id":"537","name":"Columnar Sheet Double Page Ruling 24 Columns White<br><br>1021-2","model":"1021-24","tax":"0.0000","price":"19.9500","final_price":"19.9500","onetime_charges":"0.0000","products_priced_by_attribute":"0","product_is_free":"0","products_discount_type":"2","products_discount_type_from":"0"}
Attachment 18549
Once again, thank you!
Please note that the "Use a Mock Cart" setting has been removed from EO, starting with v4.4.0. Starting with that version, EO always uses the mock cart.
It sounds like those order-total modules have made core-file changes to the storefront shopping-cart class to provide information that they need. Edit Orders expects that order-total modules use the information present in the order, not the shopping-cart, to gather any required settings.
You could use EO's ot_misc_cost and/or ot_onetime_discount order totals to enable your CSRs to 'type anything they want', but it's not possible (without a site-specific edit to edit_orders.php) to remove that dropdown entirely.
This worked perfectly. Thank you!Quote:
Originally Posted by lat9
Now, can I duplicate ot_misc_cost and/or ot_onetime_discount so I can have multiple entries?
That might work, although EO has special handling for the ot_misc_cost total's tax. If you're not planning on assigning a 'Tax Class' to that order-total, then creating clones of those totals should work (but I've never tried).Quote:
Originally Posted by monarchacct
I was able to clone those totals and it worked for what we need. Thank you for your help!Quote:
Originally Posted by lat9
Now available for download.Quote:
Originally Posted by lat9
Attachment 18558
1. Can't found where to enable this.
2. Is that possible to disable this zen_add_tax feature? I'm upgraded from 4.3.x and it working fine previously. This error appears after upgrade to 4.4.1.
It's documented in the readme's Installation::Changes to zen_add_tax tab. You need to make edits to your admin's /includes/functions/general.php to remove the unwanted pre-rounding of the calculated tax value for Edit Order's use.Quote:
Originally Posted by hamagawa
Many moons ago in 1.3.9 it was possible to change a product name or product price in EO. Is this simply not supported anymore?
You can change a product's name and price, so long as the Product pricing method is set to As entered.Quote:
Originally Posted by swguy
Thank you!
Just updated my EO on Zen 155f. Very easy and straightforward update and the new version has some very nice new features. ThanksQuote:
Originally Posted by lat9
One strange thing!
My tax is 7.7%. If I use "as entered" and enter a price of 107.7 in Unit Price (Gross) it then calculates Unit Price (Net) as 100.6542 instead of 100. When I press "update" it recalculates Unit Price (Gross) as 108.404573 instead of the correct 107.7.
Which implies it is using a tax rate of 7% not 7.7% for the net of tax calculation but using the correct 7.7% for the gross price calculation!
If I enter 100 in Unit Price (Net) then the gross price is OK.
I'm looking into this right now.Quote:
Originally Posted by marton_1
... and have created a GitHub issue to track the change required. I should have the change uploaded real-soon-now.Quote:
Originally Posted by lat9
great! :smile:Quote:
Originally Posted by lat9
... and am now preparing to release v4.4.2. The changes required can be found here (change to /YOUR_ADMIN/edit_orders.php).
Thanks, change works fine :)Quote:
Originally Posted by lat9
Thanks for the confirmation! The update's on its way.:smile:Quote:
Originally Posted by marton_1
Update: Just submitted to the plugin moderators for review; I'll post back when it's available for download.
This release contains changes associated with the following GitHub issues:
#122: Correct handling for non-integer tax rates
#123: Simplify and center the top order-navigation.
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1513Quote:
Originally Posted by lat9
Hi,
My store is using Zen Cart v1.5.5f and Edit Orders Version 4.1.4 and only recently we have had the problem that when the shipping is increased the international order fee remains the same? We did have someone inexperienced working on the site briefly. Could he have changed a setting that would cause this problem?
You're using a woefully old version of EO (v4.4.2 was just released). There have been many, many, corrections and interface changes to EO over the past 5 1/2 years.Quote:
Originally Posted by Jeff Holden
I suggest that you update.
I am getting this error when i try to update order,
PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `products` WHERE `p`.`products_id` = '1160' in /var/www/xxxx/xxxxx/xxxx/xxxx/xxxxx/xxxxx/db/mysql/query_factory.php on line 120
yes i know i am using a older version, with super orders and ty package tracker
nevermind fixed it with the bug fix
order total modules not totaling on edit screen
Attachment 18635
Are you still using that moldy-oldy (and no longer supported) version of EO?Quote:
Originally Posted by jimmie
If so, please upgrade. If not, please identify the order-total modules currently being used on the site.
i am using version 4.1.4 cause i am using zencart 1.51 with super orders, readme in super orders said to not replace the orders file from edit orders or ty package tracker
order_total modules
optional insurance module
paymentmodule fee
store credit
Understood. Unfortunately, as I mentioned before, that version of EO is no longer supported.Quote:
Originally Posted by jimmie
Hi,
I have a sore running ZC 1.5.5e, with EO 4.4.2 and Super Orders installed. If an order is split and the child order is opened in EO and anything to do with pricing is edited, then updated, the a blank page coating an error message is generated. The log file shows the following:
[02-Sep-2019 15:27:59 Australia/Sydney] Request URI: /zc_admin/edit_orders.php?page=1&oID=6554&action=update_order, IP address: xxx.xxx.xxx.xxx
#1 trigger_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php:273]
#5 editOrders->initializeOrderShippingTax() called at [/home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php:155]
#6 editOrders->eoInitializeShipping() called at [/home/xxxxxx/public_html/zc_admin/edit_orders.php:359]
[02-Sep-2019 15:27:59 Australia/Sydney] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE orders_id = 6554
LIMIT 1' at line 3 :: UPDATE zen_orders
SET shipping_tax_rate =
WHERE orders_id = 6554
LIMIT 1 ==> (as called by) /home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php on line 273 <== in /home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 167
If an additional product is added to the child order, or removed, then editing pricing works correctly.
Would appreciate any help on this.
@donw, a couple of things you could do:
1. Install Report All Errors (https://www.zen-cart.com/downloads.php?do=file&id=1792) and then set Configuration->Logging->Report All Errors Admin to IgnoreDups and Backtrace on Notices to true). That will help me to determine some of what's going on.
2. Enable Edit Orders' debug (Configuration->Edit Orders->Debug Action Level) to 1.
Create a test order, split it and then attempt to edit it. I'll be 'looking for' two types of logs:
1. /logs/myDEBUG-adm-*.log ... files that were created during (a) the initial EO 'view' of the order and (b) the one that includes the fatal error.
2. /logs/edit_orders/debug_edit_orders_xxx.log, where xxx is the split order being edited.
I'll PM you my direct email address, as those logs (especially the edit_orders one) can get pretty big.
Thanks, much appreciated. Will do this evening, as I'm tied up for the rest of the day.
Quote:
Originally Posted by lat9
The issue that @donw reported is due to that "Super Orders" split operation produced a split order that has no 'ot_shipping' component ... on a site that has ot_shipping enabled.Quote:
Originally Posted by donw
I've opened an issue on Edit Orders' GitHub repository, but it's low priority as that's non-standard behavior.
I've just submitted v4.4.3 of Edit Orders to the Zen Cart moderators for review; I'll post back here when it's available for download.
This release contains changes associated with the following GitHub issues:
#124: zc157 "future-proofing".
#126: Correct pricing issues when a product includes priced attributes.
#127: Correct various PHP notices.
#128: Empty order rendered if an observer disallows an order's update.
#129: PHP notice on Customers::Orders if no sidebox generated, e.g. when an order is being deleted.
#130: Additional notifications for site-specific customizations.
#131: (partial) If there's an orders_status::sort_order field, sort the orders-status values by that value.
#132: Use zen_get_countries_name to retrieve a country's name (zc157 future-proofing).
#133: PHP notice generated when an observer adds additional, display-only totals.
#134: Delivery address (zc156b+) might be empty when an order 'ships' via storepickup.
#135: Can't add new order-totals during order-edit.
#136: Enable a store to override EO's use of numeric input fields.
#137: MySQL error when a store does not include ot_shipping.
#139: Currency-cron fails if Edit Orders is installed (documentation only).
#140: Update the 'mock cart' to include variables for the order's total/weight (note, not actually valid values!)
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1513Quote:
Originally Posted by lat9
Now available for download.Quote:
Originally Posted by lat9
I've just submitted v4.5.0 of Edit Orders to the Zen Cart moderators for review; I'll post back when it's available for download.
This release contains changes associated with the following GitHub issues:
#142: Correct PHP notice issued if an order has no tax groups.
#143: Correct spelling of Ty Package Tracker constant name.
#144: Products with attributes, selected option not selected.
#146: Adding a product, correct PHP notices for missing field-override variables.
#147: Order-addresses' display order, additional configuration setting.
#148: Correct detection of additional status-history database fields.
zen v1.56c
php7.1
edit orders v 4.43
ty package
super orders
1. i have wholesale account installed, how can i edit order with wholesale pricing. ex. if i checkout a wholesale customer and edit the order, price is showing the wholesale price. if i change price and click update, price shows retail price. and not the price i just changed to nor does it go back to the wholesale price that was there.
2. one time discount works to add to order
Shipping insurance does not work to add to order
payment module fee does not work to add to order
To edit an order with wholesale pricing (note that I'm assuming that you're using the Dual Pricing plugin), you'll need to make sure that you've chosen the As Entered option from the Choose product-pricing method dropdown.
I've tested EO with neither an optional shipping-insurance nor payment-module fee order total. It's quite possible that those plugins aren't EO-compatible.
Would you provide the download links for each?
these are on zencart but not up to 1.56c so gotten from maker
https://www.numinix.com/plugins-taxe...surance-dl-766
https://www.numinix.com/plugins-taxe...ent-module-fee
where is this option at
Choose product-pricing method dropdown
and also attributes dont stick, meaning when add products choose 1 with an attribute. only the default display please choose shows, same when changing attribute color
figured this 1 out thank you
where is this option at
Choose product-pricing method dropdown
figured this 1 out thank you
where is this option at
Choose product-pricing method dropdown
actually manually works
but automatically show retail price
but when adding products customer needs to be logged in to see wholesale pricing, maybe admin needs to see their account to check for the flag than post the price
but they do show in comments when product addedQuote:
Originally Posted by jimmie
The 'attributes sticking' has been corrected in v4.5.0, recently submitted to the Zen Cart moderators for review.
If you want to get the update prior to the moderators' review, you can download from Edit Orders' GitHub repository: https://github.com/lat9/edit_orders/releases
Now available for download.Quote:
Originally Posted by lat9
Getting this error in edit_order page . version 1.5.6c and php 7
Warning: You have configured Zen Cart to display prices with tax. This page is currently displaying prices without tax.
where do i need to do the necessary changes ?
You need to make sure that both configuration settings (My Store->Display Prices with Tax, My Store->Display Prices with Tax in Admin) are set to 'true' (assuming that the store displays prices with tax to your customers).Quote:
Originally Posted by diptimoy
Thanks a lot . it was set inc/ex earlier.Quote:
Originally Posted by lat9
No problem. Those settings need to be in synchronization so that the tax-calculations performed during order-editing are done in the same way as those during the order-creation on your storefront.
I've posted about this issue last year and it's still present because this is only the second time I had to do this with a huge order and it doesn't work:
Editing a large order (100+ items) results in a blank page after updating, meaning the edit order module is missing. Just the admin screen menu, etc. with a blank page.
All editing functions work with a smaller order. Has anyone else encountered this problem? Is it a memory issue and if so, is it a zc or server problem? How can I resolve this?
EO 4.3.4
ZC 1.5.5f
Thanks.
There should be a myDEBUG-adm-*.log file present in your store's /logs directory that identifies what happened. I'm guessing an out-of-memory condition, but the log will tell the story.Quote:
Originally Posted by jvdd
Remember that the admin-level logs contain your site's admin-directory name, so be sure to xxx that name out prior to posting the contents of the log.
Hi lat9,
I'm busy writing up my automatic install-upgrade check scripts, and notice that in the v4.5.0 documentation there are the following issues.
Typo in documentation (missing / delimiter in path):
/YOUR_ADMIN/includes/init_includes/init_eo_config.php
Incorrectly listed in documentation:
Current: /YOUR_ADMIN/includes/classes/EditOrdersAdminObserver.php
Should be: /YOUR_ADMIN/includes/classes/observers/EditOrdersAdminObserver.php
Not in documentation:
/YOUR_ADMIN/includes/modules/edit_orders/eo_addresses_cbs.php
/YOUR_ADMIN/includes/modules/edit_orders/eo_addresses_csb.php
Not in documentation, but noted in source as being for Edit Orders additional module (not sure what that implies though):
/YOUR_ADMIN/includes/auto_loaders/config.eo_cautions.php
/YOUR_ADMIN/includes/init_includes/edit_orders_cautions.php