Orders not showing up in admin/customers/orders

I've browsed down through the threads back to 2006, looking for problems that cause order info not to show up in the admin/customers/orders

I'm using version 1.3.8a My admin/modules/order totals shows that all of the modules are installed and enabled and have differing sort orders, EXCEPT that the first 3 aren't installed. Those are the COD fee, discount coupon and group discount modules which I didn't intend to use.

The orders do show up in PayPal and I receive notification emails telling me of the order.

I can view the order data by going to admin/customers/orders and searching on the order number, then it all appears. Whew, at least it's in there somewhere!

Shouldn't I see something under admin/customers/orders other than a blank screen below the orders tab? I do have the blue bar that lists: ID, Payment/Shipping, Customer, etc... but nothing below that bar.

Same here. I've also searched threads, google, etc and haven't found an answer that works.

I have the same issue on a cart running 1.3.8a. It happens with both credit card and paypal orders. They don't show up under admin/customers/orders. They do show up if I use this type of link to reach them: mysite/admin/orders.php?oID=1&action=edit If I have the order # and also &action=edit I can find any order that way. But not on the main orders page. I've checked the database and they're all properly being added in there, so it's just something with the orders.php page's initial display. I've also reloaded that page from a fresh copy of the 1.3.8a files and it didn't help.

If I find a solution, I'll come back and post. Otherwise, maybe someone around here can help us both out, vfrazier. :)

Update. After reloading the orders.php file, I then went into the database and set the most recent order (one of my test orders) to 400 for the order number. Now new orders are showing up. The older ones still aren't, but the new ones are.

snowflake, your issue sounds like a problem with corrupted files and/or the database, perhaps related to some addons?
Your issue is not the same as vfrazier

vfrazier, if your PayPal orders are not showing up in your store, you need to find out what's blocking the communications from the PayPal server to yours.

Related articles:
http://www.zen-cart.com/forum/announcement.php?f=18&a=10
http://www.zen-cart.com/wiki/index.php/PayPal

I checked the 2 links that DrByte suggested. I'm using HostMonster hosting, so the GoDaddy problems suggested in the first URL probably don't apply.

I went through the suggestions in the Wiki and found only one item was incorrect. I had to dig around to find the "Auto Return for Website Payments Return URL...." but found it quick enough. I'm still wandering around in ZC, but at least it's starting to make some sense thanks to kind assistance from many others.

After fixing the PayPal stuff, I placed a couple test orders..... and still had nothing showing in my customers/orders page.

The orders are there. I can still retrieve them by order number, they're just not showing up on the customers/orders page.

So, I went back and double-checked the Wiki, and even tried the Camelot tutorial link. No luck.

What else could it be?

Thanks
Vince

vfrazier:

The orders are there. I can still retrieve them by order number, they're just not showing up on the customers/orders page.

• Please list all the addons and customizations that you've made to your site.
• Also, you said this was a 1.3.8a site. Was it upgrade from a prior version? If yes, which version(s)?
• And, have you made any changes to Admin->Localization->Order Status?

I haven't made any customizations or add-ons, just the usual (I think) edits to add backgrounds, borders, new products, etc. IOW, I haven't downloaded any add-ons, although I did browse through them just to see what is offered.

This is a new site, not an upgrade or transfer. I'm the only person to work on it, so I'm to blame for whatever has happened.

I haven't made any changes to the admin/localization/order status that I know of. The order status lists 4 items: pending, processing, delivered, and update. If I click on any of those to edit them I get a US flag (language icon?) and the text box with the same words: pending, processing, delivered, and update depending on which one I click to edit.

FWIW, this is the only problem that I know of that is keeping me from launching my store publicly. I really don't want to get orders when I am having trouble viewing them! Any suggestions are greatly appreciated!

vfrazier:

The orders are there. I can still retrieve them by order number, they're just not showing up on the customers/orders page.
How exactly are you doing that?
And are the orders showing on your admin home page?

The orders do show up on the admin home page. Not much info there, just customer name, date, and price. If I click the highlighted customer name, it takes me to the order page, but there is no info there.

To see the order details, I search on the orders page by inputting the order number in the order ID box. Then hit enter and I get a whole screen full of information.

In the "comments" area, what's the order-status column showing for each of the comments?
Are all these orders paid by paypal?

Comments? Is that under customer comments on the order page? It is empty.

Yes, all the orders are via PayPal.

Here is the text from the orders page:

Orders
Order ID:
Status:
LEGEND: Billing and Shipping does not match Billing and Shipping does not match
1054 Unknown column 'o.orders_status' in 'where clause'
in:
[select count(*) as total from (orders s, orders_status o ) left join orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total') ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
ID Payment
Shipping Customers Order Total Date Purchased Status Customer
Comments Action

vfrazier:

1054 Unknown column 'o.orders_status' in 'where clause'
in:
[select count(*) as total from (orders s, orders_status o ) left join orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total') ]
It always amazes me when people post symptoms without even mentioning specific error messages. :eek:

What's the version ID / date from the copyright/version block at the top of these two files: /admin/index.php and /admin/orders.php ?

$Id: index.php 5454 2006-12-29 20:10:17Z drbyte $

@version $Id: orders.php 6864 2007-08-27 16:15:20Z drbyte $

My apologies on the error message thing. It's always been there and it's easy to overlook if you don't know what it is. I'm an aircraft expert by day, and a ZC idiot in my spare time. Sorry.

vfrazier:

[select count(*) as total from (orders s, orders_status o )...
Um, how did that get set to say "orders s, orders_status o" ? It should be "orders o, orders_status s".

Seems like you've made some customizations to /admin/orders.php

I don't know. I wouldn't know what to change even if I'd wanted to change something in orders.php

What should I do now?

I suggest renaming that file to orders.bad, and then upload the original version of that file from a freshly-downloaded-and-unzipped copy of Zen Cart v1.3.8a (since you said you're using v1.3.8a).

http://www.zen-cart.com/forum/images/smilies/clap.gif

Thanks for your patience and your help Dr. Byte!

Reloading a fresh file fixed the problem. It sure is nice to see the orders page for the first time. I was wondering if I was just expecting something that wasn't real. I had never seen any order data on there before so I really didn't know what to expect!

I'm not sure how the file got corrupted but I'm not gonna lose sleep over it either! All that matters is that a problem that vexed me for weeks is gone!

Now I can launch the store!!!! Also, what better time to make a donation to ZC than on day one! I'm on it.

Glad that fixed it :)