Edit Orders v4.0 Support Thread

Do you have Edit Orders installed? Because your question doesn't sound like it has anything to do with edit orders..

mjhendricks:

Thank you!

We're a company with a massive laser cutting and engraving machine (150 Watts, 1500 x 1200mm bed)...We have our own designs for sale, but also accept commissioned work, which requires a quoting process. This is an easy way to give our customers a quote request and response mechanism...One problem:

When I open the order page, it alerts

Warning 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.

> 
> I have verified, both through the Admin module and directly in the database, that "United States" does in fact exist in the proper areas as suggested, and that there are no leading/trailing spaces in the "orders" or "countries" tables.
> 
> While the ordered items/address portion of the update is successful, the customer is not notified of the update, and update comments are not added to the order.

Yes, I do. This is a three-day old install of Zen Cart, and Edit Orders is the only mod installed. I poked around the customers => orders function before I installed Edit Orders to see if I could do what I wanted before I started looking for a mod. I already had three "test" orders in the system, created to learn the order creation and fulfillment process. I viewed the same orders before and after adding Edit Orders, and the issue arose immediately after installing Edit Orders

And are you using a module allows you to manually add orders? How exactly did you add your test orders..

mjhendricks:

Yes, I do. This is a three-day old install of Zen Cart, and Edit Orders is the only mod installed. I poked around the customers => orders function before I installed Edit Orders to see if I could do what I wanted before I started looking for a mod. I already had three "test" orders in the system, created to learn the order creation and fulfillment process. I viewed the same orders before and after adding Edit Orders, and the issue arose immediately after installing Edit Orders

The details button appears to be the original functionality of customer =>orders, and it still works as it did before Edit Orders was installed, including status updates and email updates. The alert appears when I click the Edit button and the order displays with the editable fields, even before I make any changes.

mjhendricks:

Yes, I do. This is a three-day old install of Zen Cart, and Edit Orders is the only mod installed. I poked around the customers => orders function before I installed Edit Orders to see if I could do what I wanted before I started looking for a mod. I already had three "test" orders in the system, created to learn the order creation and fulfillment process. I viewed the same orders before and after adding Edit Orders, and the issue arose immediately after installing Edit Orders

I am using the standard install, selecting a product and checking out

DivaVocals:

And are you using a module allows you to manually add orders? How exactly did you add your test orders..

mjhendricks:

...
When I open the order page, it alerts

Warning: One or more of the customer address fields contains a country name unknown to Zen Cart ("Locations / Taxes"->"Countries"). ...

I have verified, both through the Admin module and directly in the database, that "United States" does in fact exist in the proper areas as suggested, and that there are no leading/trailing spaces in the "orders" or "countries" tables.
This warning is only displayed when one of the addresses in the order has a country which is not found in the Zen Cart database. This is an extra check which was added to warn administrative users. When the country cannot be detected / determined by Zen Cart, tax and shipping calculations may not work correctly.

What is the country listed in the order (in the order db table) for "customer", "billing", and "delivery"? Does it match exactly (including case) the name of the country (in the country db table)? Are both tables using the same db collation?

Some 3rd party modules (such as minimum customer info) do not populate the country fields when creating an order (which also results in the country not being found). If you are using one of these you can ignore the warning... Or fix the 3rd party modules code to add the country to the addresses in the order...

mjhendricks:

...
While the ordered items/address portion of the update is successful, the customer is not notified of the update, and update comments are not added to the order.
Edit Orders does not automatically send emails to customers when you update order details such as the address, products, or order total lines.

In Edit Orders 4.1.2 when an administrative user enters a comment AND changes the status of an order the comment is saved to the database. If when the comment was saved AND the administrative user selected notify customer via email, then an email will be sent to the customer's registered email address. So if one adds a comment and changes the status of the order from "pending" to "quoted" and selects notify customer via email, then the customer is sent an email letting them know the status was changed to "quoted" and includes the comments.

There is a patch posted earlier in this thread outlining what change needs to be made if you want comments to be saved when the status of the order has not been changed. The change is already incorporated into the next release of Edit Orders, but if one wants the change before 4.1.3 is released they need to manually apply the patch.

It turns out that shipping address is required, even if the item is store pickup (oversight from my perspective). Have to manually cut and paste.

Not saving comments when status not changed also seems to be an oversight.

lhungil:

This warning is only displayed when one of the addresses in the order has a country which is not found in the Zen Cart database. This is an extra check which was added to warn administrative users. When the country cannot be detected / determined by Zen Cart, tax and shipping calculations may not work correctly.

What is the country listed in the order (in the order db table) for "customer", "billing", and "delivery"? Does it match exactly (including case) the name of the country (in the country db table)? Are both tables using the same db collation?

Some 3rd party modules (such as minimum customer info) do not populate the country fields when creating an order (which also results in the country not being found). If you are using one of these you can ignore the warning... Or fix the 3rd party modules code to add the country to the addresses in the order...

Edit Orders does not automatically send emails to customers when you update order details such as the address, products, or order total lines.

In Edit Orders 4.1.2 when an administrative user enters a comment AND changes the status of an order the comment is saved to the database. If when the comment was saved AND the administrative user selected notify customer via email, then an email will be sent to the customer's registered email address. So if one adds a comment and changes the status of the order from "pending" to "quoted" and selects notify customer via email, then the customer is sent an email letting them know the status was changed to "quoted" and includes the comments.

There is a patch posted earlier in this thread outlining what change needs to be made if you want comments to be saved when the status of the order has not been changed. The change is already incorporated into the next release of Edit Orders, but if one wants the change before 4.1.3 is released they need to manually apply the patch.

Aye. It is not uncommon in many US states for the collection of taxes based upon the shipping address (or store address when picked up in a store)... If this is the case, with in store pickup the shipping address should most likely be the store's address...

May be different in your location... But in order to work with all possible configurations... Populating all addresses associated with an order seems to work best...

This is also why a warning is issued as opposed to stopping one from editing the order (some stores may be exempt from tax, may not need one of the addresses based upon the applicable tax laws in the locations they do business, may not offer shipping, etc).

DivaVocals:

That's because it's in the LOGS folder..

I must have misunderstood what I read about errors, I thought it was in the cache until zen 1.51 and cache before that. I must have searched and found something else. Anyway if it is in the logs folder I dont actually have a logs folder at all.

Is it the case that the logs folder is generated automatically in zen and not part of the instal? As that would explain why it is not there in my particular case?

memorydave:

I must have misunderstood what I read about errors, I thought it was in the cache until zen 1.51 and cache before that. I must have searched and found something else. Anyway if it is in the logs folder I dont actually have a logs folder at all.

Is it the case that the logs folder is generated automatically in zen and not part of the instal? As that would explain why it is not there in my particular case?

I just did a "quick" search about the logs and found this thread http://www.zen-cart.com/downloads.php?do=file&id=1583

There have been many times that I've taken a look in one of my Zen Cart's /logs (or /cache for Zen Cart v1.5.0) directories and found some debug log files that I wasn't previously aware of. This plugin allows an admin user to view (and selectively delete) any files with names that match:

memorydave:

I must have misunderstood what I read about errors, I thought it was in the cache until zen 1.51 and cache before that. I must have searched and found something else. Anyway if it is in the logs folder I dont actually have a logs folder at all.

Is it the case that the logs folder is generated automatically in zen and not part of the instal? As that would explain why it is not there in my particular case?

NO.. as of Zen Cart v1.5.1 the errors logs go to the LOGS folder, and it's not created on the fly, it's part of the install files..

Amazing what the Zen Cart FAQs section has floating around.. (this found searching for the term "error log")

http://www.zen-cart.com/content.php?124-i-am-getting-a-blank-page-%28or-blank-part-of-a-page%29

a) Check for the actual error messages in the store's myDebug-xxxxxxx.log files:

The built-in debug logging will create files in your website's /logs/ folder, named "myDebug-xxxxxx.log" (or "myDebug-adm-xxxxxxx.log" if they are from the admin side).

***(If you're on an older version of Zen Cart such as v1.3.9 or v1.5.0 then these will be in the /cache/ folder instead of the /logs/ folder.)
***(To access these files, use your FTP program to connect to your webserver. Your hosting company can help you with how to do that.)
You'll want to read the contents of these files to see what the actual PHP errors are.
Then search this FAQ area for your error message and/or see the "Dealing with Error Messages" section, later in this article.

NOTE: When errors start occurring, the number of log files in this folder can grow very quickly. You can purge them by using the Debug Log File Purge option from your Admin->Tools->Store Manager screen.
You will of course want to review the contents of those files first so you can address the problems they're recording.
If you don't purge them, it will eventually slow down your website's performance, and use up a large amount of disk space.

memorydave:

I just did a "quick" search about the logs and found this thread http://www.zen-cart.com/downloads.php?do=file&id=1583

Right.. if you want to discuss this mod, you should post a question in the support thread for it..

DivaVocals:

NO.. as of Zen Cart v1.5.1 the errors logs go to the LOGS folder, and it's not created on the fly, it's part of the install files..

Amazing what the Zen Cart FAQs section has floating around.. (this found searching for the term "error log")

http://www.zen-cart.com/content.php?124-i-am-getting-a-blank-page-%28or-blank-part-of-a-page%29

great, that's what I thought, it isn't in the logs folder for me as I am using 1.5.0. So getting back to what we was saying earlier.

memorydave:

OK I have had a read of this thread and can't find the issue I am having.

Everything installed fine it seamed. When I go and press "update" it goes to a blank page.

But it does actually update the order, you can see that by going back to the order. It has been changed

DivaVocals:

blank page = error.. post what the resulting error log says..

memorydave:

There is no error logs, I am looking in the cache folder and Im using zen 1.5 and there is no error logs

So there are no error logs for this. I get a blank page and no error log :-(

We are unable to duplicate the issue you are encountering in our test and production sites.

In order to further help you determine why your installation is encountering a "blank" page, we need to know what PHP error is occurring to cause the "blank" page. If nothing is logged in the Zen Cart debug logs (you do have these enabled and the directory is writable by the webserver, correct?)... Then the next step is to look in the server error logs (your hosting provider should be able to assist you - and may need to enable logging of PHP warnings / errors).

ZenCart V1.5.1
Edit Orders 4.1.2
Super Orders 4.0.7
Stock by Attribute 1.5.1.2

Problem.
When editing an order the attributes setting is getting reset to a default value.

Is this a known problem? Is a fix available?

Cheers
Rod

RodG:

ZenCart V1.5.1
Edit Orders 4.1.2
Super Orders 4.0.7
Stock by Attribute 1.5.1.2

Problem.
When editing an order the attributes setting is getting reset to a default value.

Is this a known problem? Is a fix available?
Not a known issue (except for file uploads, which are not currently supported)...

I do not currently use any of the "stock by attribute" modules... Does this module make any changes to the handling of attributes on the catalog side? Does it add additional option types (which may not be understood by the stock ZC code)? If either is true... One may need to replicate those changes in the eo_* functions (or edit_orders.php when attributes are displayed)...

lhungil:

Not a known issue (except for file uploads, which are not currently supported)...

I do not currently use any of the "stock by attribute" modules... Does this module make any changes to the handling of attributes on the catalog side? Does it add additional option types (which may not be understood by the stock ZC code)? .

I don't know. I figured it would be worth asking here first before diving into how it all worked.

lhungil:

If either is true... One may need to replicate those changes in the eo_* functions (or edit_orders.php when attributes are displayed)...

Yeah, that's pretty much what I thought.

It looks like I'm going to have to dive into the code anyway, because the client also has the " Your Store Gift Cards (plastic, etc)" module installed (http://www.zen-cart.com/downloads.php?do=file&id=718), and although this does show up in the edit dropdown menu along with the Discount Voucher and Gift certificates as being editable items, the amounts entered with this are not being acted upon for the order totals.

Oh, while I'm on the topic, it took me a bit of head scratching to get the Discount Vouchers to work within the editor. It kept giving "Warning: The coupon code was not found in the title. The title / text of a coupon must be formated like "Discount Coupon : coupon_code :".
Sure enough, when I entered the data exactly like the warning suggests it worked as expected. I would have thought the 'Discount Coupon:" would be automatically derived and inserted via the dropdown selector (which I assume is happening for the Gift Certificates).
I'm not sure if this is a bug or not. I thought it worth mentioning though.

Cheers
Rod

lhungil:

Not a known issue (except for file uploads, which are not currently supported)...

It's a bug.

edit_orders.php , Line#894 , reads:

switch($optionInfo['type']) {

The problem is $optionInfo['type'] doesn't appear to be getting set anywhere, therefore none of the CASE's will ever match.

I've not had a chance to look into why this array variable isn't being set, but I've proved the point, by changing the line to read
switch("TEST") ;

then adding a case "TEST" just below the "case PRODUCTS_OPTIONS_TYPE_RADIO" and "case PRODUCTS_OPTIONS_TYPE_SELECT" lines.

Not really a viable solution, but as I said, it proves a point. The RADIO and SELECT type attributes then work flawlessly.

Cheers
Rod

RodG:

It's a bug.

But NOT in the edit orders code.

I've traced this back to the source and the bug is in the stock by attributes code.

I'll follow this up with the details in the appropriate forum tomorrow.

Must get sleep.... its been a loooong day.

Cheers
Rod

RodG:

Oh, while I'm on the topic, it took me a bit of head scratching to get the Discount Vouchers to work within the editor. It kept giving "Warning: The coupon code was not found in the title. The title / text of a coupon must be formated like "Discount Coupon : coupon_code :".
Sure enough, when I entered the data exactly like the warning suggests it worked as expected. I would have thought the 'Discount Coupon:" would be automatically derived and inserted via the dropdown selector (which I assume is happening for the Gift Certificates).
I'm not sure if this is a bug or not. I thought it worth mentioning though.
Not a bug.. this is how it works, and I believe the readme covers this..