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

Edit Orders v4.0 Support Thread

Views: 345,913

Results 261 to 280 of 1,927
23 Sep 2013, 16:13
#261
lat9 avatar

lat9

Administrator

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

Edit Orders v4.0 Support Thread

Running EO 4.1.2 on Zen Cart v1.5.1. Storefront highly customized; admin not so much! The only thing that might be interfering is the "Minimum Customer Account" plugin, since I'm getting the edit_orders message:

Warning: One or more of the customer address fields contains a country name unknown to Zen Cart ("Locations / Taxes"->"Countries").
Taxes and some shipping modules may not function correctly until the issue has been resolved.

This typically occurs if someone deletes or renames a country's name from Zen Cart ("Locations / Taxes"->"Countries"). You can fix the issue by doing one of the following:

    Add the country (and name) back to the Zen Cart database.
    Adjust the country name to match one of the country names in the Zen Cart database.

There is a virtual product that is $1.00 and the product-quantity is used to determine the final price. When an order is initially placed, the quantity is 1. I go to the admin to use edit_orders and change the quantity to 100 and click "Update", the line-item total for the product is updated to $100.00 but the order_totals total remains at $1.00. The order includes neither tax nor shipping.

I don't know if this is a procedural issue on my part, an incompatibility or something else. I'm off to investigate further.

--> One other thing I noticed is that the only order_total that is enabled is the ot_total (no ot_subtotal).

23 Sep 2013, 16:31
#262
lat9 avatar

lat9

Administrator

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

Re: Edit Orders v4.0 Support Thread

lat9:

--> One other thing I noticed is that the only order_total that is enabled is the ot_total (no ot_subtotal).
That was it! Turning on the ot_subtotal (which I really don't want to do) caused the totals to be properly updated.

23 Sep 2013, 22:15
#263
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Edit Orders v4.0 Support Thread

lat9:

That was it! Turning on the ot_subtotal (which I really don't want to do) caused the totals to be properly updated.
Yeah, I don't think the current code takes into consideration ot_subtotal can be disabled... For now your workaround should work. You may also want to alter the template (if you have not already) to not output the subtotal line on the customer facing side (If one does not want the customer to see this line).

When (and if) I find some time I'll look into it further, but it probably has something to do with order->['subtotal'] not existing when ot_subtotal is disabled (Zen Cart does not store the subtotal in the database when ot_subtotal is disabled). Will probably require regenerating this field manually every time the order is read / calculated (when ot_subtotal is disabled).

lat9:

Warning: One or more of the customer address fields contains a country name unknown to Zen Cart ("Locations / Taxes"->"Countries").
Taxes and some shipping modules may not function correctly until the issue has been resolved.

This typically occurs if someone deletes or renames a country's name from Zen Cart ("Locations / Taxes"->"Countries"). You can fix the issue by doing one of the following:

Add the country (and name) back to the Zen Cart database.
Adjust the country name to match one of the country names in the Zen Cart database.
This error is probably because of the minimal info mod (if it does not add a billing or delivery address to the order in the database).
24 Sep 2013, 14:07
#264
buildingblocks avatar

buildingblocks

Totally Zenned

Join Date:
Jun 2008
Posts:
629
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

Can anyone confirm whether the edit orders mod will work with reward points full suite?

24 Sep 2013, 17:10
#265
nuno_alho avatar

nuno_alho

New Zenner

Join Date:
Sep 2013
Location:
Odivelas, Portugal
Posts:
1
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

hello
I did the update zencart and editor of orders for the new version 1.5, what happens is that every time I edit an order he is not adding up right. I add a new product to the order and values ​​are all changed .... I do not know what to do ... has anyone had this problem?

thank you

30 Sep 2013, 18:24
#266
mydanilo avatar

mydanilo

Totally Zenned

Join Date:
Dec 2004
Posts:
1,024
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

Just updated to latest edit order 4.1.2 and hoped my problem would go away. No go. Here is what I have.

When adding a product with attribute that should add x$ to the item cost, it does not work. I select the product in step 2 but step 3 where I need to select the attribute I have nothing to select (see picture). The result is the product gets added with the default attribute value. I need to be able to select the correct attribute.
Any suggestions?
Attachment 13122

30 Sep 2013, 18:34
#267
mydanilo avatar

mydanilo

Totally Zenned

Join Date:
Dec 2004
Posts:
1,024
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

I want to add to previous post... the ability to edit attribute on the order page is gone too. I used to be able to change options for a sold product right on the order page when a customer changed it's mind. Very convenient. Is this a bug or just not implemented anymore? Maybe related to above issue?

01 Oct 2013, 03:17
#268
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Edit Orders v4.0 Support Thread

mydanilo:

... the ability to edit attribute on the order page is gone ...
The dropdowns to select attributes show up in a stock Zen Cart 1.5.x installation.

Have any modifications been made to your store which alter the handling of attributes?

01 Oct 2013, 03:28
#269
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Edit Orders v4.0 Support Thread

... continued ...

May want to try re-installing one step at a time. If problems persist please tell us how your store differs from a stock Zen Cart installation including full version numbers of all plugins.

How were attributes populated? How were the attributes assigned to the products? Have any modifications been made to your store which alter the handling of attributes?

01 Oct 2013, 14:14
#271
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v4.0 Support Thread

lat9:

Another thing to check is whether a previously-installed plugin has "killed" some of the built-in attributes configuration; see this post: http://www.zen-cart.com/showthread.php?170483-Attribute-Required-for-Text-flag-not-working

Yep.. and there are still a few add-ons which still use SQL which accidentally kills default configuration items..

01 Oct 2013, 14:19
#272
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v4.0 Support Thread

Nuno Alho:

hello
I did the update zencart and editor of orders for the new version 1.5, what happens is that every time I edit an order he is not adding up right. I add a new product to the order and values ​​are all changed .... I do not know what to do ... has anyone had this problem?

thank you
Your question is WAAAAY too broad.. Out the box Edit Orders WORKS.. So if it doesn't, then it would help the community to help you if you provided some details on what's going on in your situation..

  • What are the order totals before editing??
  • What products do you add??
  • What do you expect the order totals to be after adding the product?

Details will help otherwise we will just be guessing which is usually not helpful..

01 Oct 2013, 16:34
#273
mydanilo avatar

mydanilo

Totally Zenned

Join Date:
Dec 2004
Posts:
1,024
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

Ok, good to know that this should be working. Now the search will begin. I'll post back once I get closer.

01 Oct 2013, 17:35
#274
mydanilo avatar

mydanilo

Totally Zenned

Join Date:
Dec 2004
Posts:
1,024
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

USPS Click-N-Ship Auto-Fill v1.6 could be the guilty one? But here is my list of mods.

additional_images_v.1.1
column_layout_grid_2_3_1 SQL
Image_Handler4_v4_3_1 (auto installer)
Short Description for Categories 1.3 SQL
ckeditor-for-zencart
captchaUsing_ttf__gd__TelephoneNotRequired_v3.0 SQL
Multi Cross Sell (merged - creates new Xsell table, might need to back up table first) upload Admin_Page_Install to apply install
edit_orders_1 (Edit Orders 4.1.1) SQL
Admin_Login_As_Customer_v3.1_For_ZCv151 SQL (might not need as MP is installed?)
USPS v15 Ratev4 2013_0127 R2013_0729_J5
UPS United Parcel Service
Google Merchant Center Feeder 1_14_0
ceon_uri_mapping_4.4.1_for_zc merged
EasyPopulate-4.0-master
IntegratedCOWOA_2.4 SQL
USPS Auto Fill mod, partial, just to pull order total weight, SQL

01 Oct 2013, 18:26
#275
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Edit Orders v4.0 Support Thread

mydanilo:

Just updated to latest edit order 4.1.2 ...

mydanilo:

... But here is my list of mods.

...
edit_orders_1 (Edit Orders 4.1.1)
...
So which version of Edit Orders do you have installed? 4.1.1? 4.1.2?
What version of Zen Cart do you have installed?

mydanilo:

... But here is my list of mods.

...
EasyPopulate-4.0-master
...
Attribute handling in Zen Cart is complex involving a large number of tables... Edit Orders uses the same code as Zen Cart to determine which attributes attached to a product are "user-selectable". There are a couple of Zen Cart settings which impact this function including: PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED and PRODUCTS_OPTIONS_TYPE_READONLY.

It is also possible if you used EasyPopulate to add the attributes something was missed (In the past it was an issue, but I have not used EasyPopulate recently so it may have been fixed at some point). Have you tried going to the attribute controller, option names manager, and option values managers (I believe in Zen Cart 1.5.1 they added a couple attribute autofix / repair features when these are loaded)?

Is there anything in the Zen Cart debug logs or server / php error logs?

01 Oct 2013, 18:34
#276
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v4.0 Support Thread

mydanilo:

USPS Click-N-Ship Auto-Fill v1.6 could be the guilty one? But here is my list of mods.

additional_images_v.1.1
column_layout_grid_2_3_1 SQL
Image_Handler4_v4_3_1 (auto installer)
Short Description for Categories 1.3 SQL
ckeditor-for-zencart
captchaUsing_ttf__gd__TelephoneNotRequired_v3.0 SQL
Multi Cross Sell (merged - creates new Xsell table, might need to back up table first) upload Admin_Page_Install to apply install
edit_orders_1 (Edit Orders 4.1.1) SQL
Admin_Login_As_Customer_v3.1_For_ZCv151 SQL (might not need as MP is installed?)
USPS v15 Ratev4 2013_0127 R2013_0729_J5
UPS United Parcel Service
Google Merchant Center Feeder 1_14_0
ceon_uri_mapping_4.4.1_for_zc merged
EasyPopulate-4.0-master
IntegratedCOWOA_2.4 SQL
USPS Auto Fill mod, partial, just to pull order total weight, SQL

If you suspect that the errant SQL is the issue, then you need to narrow this list down.. Follow the thread lat9 posted.. Do ANY of these add-ons use the kind of SQL code that MIGHT accidentally delete configuration table items which would cause issues with attributes. You can eliminate IH4, CK Editor, COWOA, Edit Orders, Ceon URI, UPS, and USPS as NONE of these contain the kind of errant SQL which would cause issues.. You will need to examine the rest to determine if this is indeed the cause..

01 Oct 2013, 18:44
#277
mydanilo avatar

mydanilo

Totally Zenned

Join Date:
Dec 2004
Posts:
1,024
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

4.1.2 is installed, was my old list when I did the 1.5.1 upgrade

No, I did not import anything attribute with EP. These products have been active since 1.3.9 and older. Just completed an 1.5.1 about a month ago. Thought all is well until I discovered the editing orders is acting up. Last addition I did was the USPS autfill as I wanted the total weight on my order detail that this mod provides (even on free shipping order). That is why I thought it might be related to this.

Just noticed my error_log file is getting very big, see last entry.
[23-Sep-2013 21:47:43] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/suhosin.so: cannot open shared object file: No such file or directory in Unknown on line 0
[23-Sep-2013 21:47:43] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/pdo.so: undefined symbol: executor_globals_id in Unknown on line 0
[23-Sep-2013 21:47:43] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/pdo_sqlite.so: undefined symbol: core_globals_id in Unknown on line 0
[23-Sep-2013 21:47:43] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/sqlite.so: undefined symbol: core_globals_id in Unknown on line 0
[23-Sep-2013 21:47:43] PHP Warning: PHP Startup: pdo_mysql: Unable to initialize module
Module compiled with module API=20060613, debug=0, thread-safety=1
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0

Not sure what this is all about.

01 Oct 2013, 20:20
#278
twinkiejr avatar

twinkiejr

New Zenner

Join Date:
Mar 2010
Posts:
5
Plugin Contributions:
0

Re: Edit Orders v4.0 Support Thread

Hello everyone. I am trying to install Edit orders on zen 1.51 and I am getting this error. /zen_admin/includes/functions/extra_functions/common_orders_functions.php'. Verify your web server has access to delete this file. I have searched and found two posts about this. The post says to change permissions to allow web server to delete the files. Well How does one do this? I have changed permissions on the individual files and changed user permissions etc and nothing seems to work. I am usually pretty sharp at this but today I am just drawing a blank. It is a fresh install of zen cart on a dedicated Linux Ubuntu 12.04 server.

01 Oct 2013, 20:45
#279
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Edit Orders v4.0 Support Thread

mydanilo:

...
Just noticed my error_log file is getting very big, see last entry.
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/suhosin.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/suhosin.so: cannot open shared object file: No such file or directory in Unknown on line 0
...
Not sure what this is all about.
Message like this indicate your php.ini is instructing the php interpreter to load those php "extensions" and the files are not present. Most common causes are after a server move or a PHP upgrade (and the php.ini was not updated to point to the correct locations - or some extensions are no longer available). Hosting provider should be able to help with these and they are probably not the source of the issue you are describing... But not a bad idea to get them fixed :)

01 Oct 2013, 20:59
#280
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Edit Orders v4.0 Support Thread

twinkiejr:

... I am getting this error. ... Verify your web server has access to delete this file. ... Well How does one do this? ... It is a fresh install of zen cart on a dedicated Linux Ubuntu 12.04 server.
You will need to determine which user your webserver is running under (by default the user is www-data in a stock Debian derived OS without suphp installed). Then you need to change permissions to grant write access to the file(s) mentioned. You may have to change permissions via a web based "File Manager" depending upon your hosting provider (the hosting provider should be able to tell you if this is the case and how to change the permissions). If you have enabled SELinux on your web server and do not have the site under "/var/www" you may also need to change some SELinux related permissions (rare in stock Ubuntu).

Both of these are beyond the scope of this support thread... If you need further help with permissions, please open a new thread on the forum asking how to adjust permissions on your web server. Thank You!