Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Orders missing in admin


ashlyn

Recommended Posts

I have done numerous test orders, and all came through just fine by email, and to the database, but nothing is showing in admin/orders.

 

Reports/Customer Orders-total shows the complete amount the customer has ordered, but when I try to see exactly what has been ordered, I have nothing listed.. just the same as in admin/orders.

 

In the admin screen, the blue orders box is totally empty (as if the box code had been removed)

 

Any ideas on why this might have happened? It was working just fine a few days ago. I've been editing language files, but nothing too dramatic. The only thing I have installed is the protx direct payment module. Disabling this module does nothing to fix the problem.

 

Where should I be looking? Which files might be causing this problem?

 

Thanks for any info..

 

PS.. this has nothing to do with paypal. I don't even have it installed.

-------------------------------------------------------

 

I used to be insane, but now I'm just nuts ;)

Link to comment
Share on other sites

Sorry to bump, but I'm getting desperate.

 

I have retraced my steps, and put things back the way they were, but I must have missed something along the way. Is there anything which will affect the orders process displaying on the admin/orders page?

 

Any advice much appreciated.

-------------------------------------------------------

 

I used to be insane, but now I'm just nuts ;)

Link to comment
Share on other sites

Sorry to bump, but I'm getting desperate.

 

I have retraced my steps, and put things back the way they were, but I must have missed something along the way. Is there anything which will affect the orders process displaying on the admin/orders page?

 

Any advice much appreciated.

 

You replied to my topic that you had the same problem I do. Have you checked your orders table to see that the order is there? And what about the orders_total table? Does it not have records that match up to the orders record? That's my situation. I can pull up orders if I enter the order number directly into the search box, but not from the list.

 

It appears that even though the SQL for showing the orders does a left join between orders and orders_total that it's not behaving like a left join should. If there are no records in orders_total than it does not show the order in the list.

 

David

Link to comment
Share on other sites

You replied to my topic that you had the same problem I do. Have you checked your orders table to see that the order is there? And what about the orders_total table? Does it not have records that match up to the orders record? That's my situation. I can pull up orders if I enter the order number directly into the search box, but not from the list.

 

It appears that even though the SQL for showing the orders does a left join between orders and orders_total that it's not behaving like a left join should. If there are no records in orders_total than it does not show the order in the list.

 

David

 

Mine shows the orders properly in the database, in all areas.

 

The only places I can't see the orders are in admin/orders (reports/products ordered shows all products, plus customer order totals shows the total of my orders, but won't let me see individual orders), and in my account history, order history it shows many page links to display past orders, but the pages are empty.

 

I know it has to be something simple, and it's driving me NUTS!!

Thanks for letting me know I wasn't the only one though :D

-------------------------------------------------------

 

I used to be insane, but now I'm just nuts ;)

Link to comment
Share on other sites

I have exactly the same problem since a domain migration a couple of weeks ago. Whoever finds a fix first, please do come back and post as this thread will be found by those yet to come!

 

Thanks - and indeed, good to know it's not just me

 

Barbara

Link to comment
Share on other sites

All right guys I see your desprate and I really don't know if I am off much help but I know on most payment system you need to have a link pointing back to your site on a succesffull purchase

 

 

for example

If you want a seemless shopping experience, you need to enter an address for both confirmation and failure URL fields. Here is an example of what you would enter for both fields:

https://www.domain.com/catalog/checkout_process.php

 

this would explain a domain migration if the domain name changed it would not be referring back to cehckout_process

 

I hope this helps let me know

Link to comment
Share on other sites

For anyone who is still having problems with this, I've managed to fix mine by going into admin, Localization, Orders Status and putting an actual status in there!

 

Because I had no status set (pending, sent, delivered etc), the orders were not displaying. The sucky thing is that I am sure I had them on the clean install, so what actually happened to them?

 

Anyway, check this to see if you had the same problem as I did.

Hope it helps..

-------------------------------------------------------

 

I used to be insane, but now I'm just nuts ;)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...