Order not visible in Admin Panel

[Hade]

I've just received an order which does not show up in the list of order in the admin panel.

 

On the admin start page, it correctly says "Pending: 1"

I received the order email, and when I type in the order number, it comes up fine.

I tried a test order, which works fine.

I have checked the database and the row seems fine.

 

Anyone know what this could be? Any idea at all why an order may not appear in the orders list?

 

I've just set its status to 'Dispatched' and it's still not visible in the list.

Thanks

[Hade]

Surely someone has experienced this, or has some idea why it's happened!

[gfrior]

Surely someone has experienced this, or has some idea why it's happened!

 

Hi Hade,

 

I am experiencing the same problem - orders are being added to the database - and you can see them using phpmyadmin - but the orders DO NOT appear in the admin section. This applies to any order whether processed by PayPal or not. Does anyone have an idea why this is happening? Everything was working fine a few days ago and I have made no changes to the code. Someone else must have this problem - anyone got a solution?

 

Desperately needing help!!!

 

--

George

[mycolumbus]

Same thing happening with me too.

[Hade]

I've looked into it and think I may have found the problem (for the order not showing in the list at least)

It seems that the order has not entries in the orders_total table in the database.

Why this was not created I don't know, but I'm putting my money on some kind of server error during the final stages of checkout, perhaps a temporary error with the database. This may have caused the entry to terminate unexpectedly. It seems new orders coming are ok again, it was a one off for me.

at table in the database, and the customers table too.

If the info is in them, I'd try adding debug code into admin/orders.php, to see why it's not pulling the records out.

[mycolumbus]

I've noticed all working fine when using the PayPal payments module. Only when I use the optpay payment module, it doesn't work. So seems to be a payments module problem.

[gfrior]

Hade,

 

Thanks for the information - it appears that the orders_total record is not being added to the table. If I add a record manually (with the 'correct' order_id) then the orders do appear in the admin section. However, I do not yet know why the orders_total is not being created.

 

Anyone got any ideas as to why this might be happening?

 

--

George

[Hade]

Hade,

 

Thanks for the information - it appears that the orders_total record is not being added to the table. If I add a record manually (with the 'correct' order_id) then the orders do appear in the admin section. However, I do not yet know why the orders_total is not being created.

 

Anyone got any ideas as to why this might be happening?

 

--

George

 

it depends how good you are with php. if using dreamweaver, search all files for the one which INSERTs into that table and put some debug code in to see why its not being correctly triggered. i usally echo out my insert staemet etc.

[Haazen]

We are having similar problems. I am adding this just for a bit more info.

 

We only use Paypal. The customer goes through the entire process and is sent an email from Paypal. I receive an email also from Paypal. But there is not a record of the order anywhere. The customer does not receive the email from our store showing their order.

 

Now this is not always. Every time I have tested it, I receive email from paypal and the store showing my order. The store receives email notice from Paypal. The order shows up in Admin.

 

When I test, am I pressing a button that the customer might not be pressing. My first thought was that the Return To Vendor button on Paypal. Does that have to be pressed for that order process to finish and update the database with order info?

 

Thanks for help I hope. ;)

[Hade]

We are having similar problems. I am adding this just for a bit more info.

 

We only use Paypal. The customer goes through the entire process and is sent an email from Paypal. I receive an email also from Paypal. But there is not a record of the order anywhere. The customer does not receive the email from our store showing their order.

 

Now this is not always. Every time I have tested it, I receive email from paypal and the store showing my order. The store receives email notice from Paypal. The order shows up in Admin.

 

When I test, am I pressing a button that the customer might not be pressing. My first thought was that the Return To Vendor button on Paypal. Does that have to be pressed for that order process to finish and update the database with order info?

 

Thanks for help I hope. ;)

 

The orders status is set to 'Paypal IPN Preparing' before being redirected to Paypal.

If the customer does not click the return to vendor button, they are automatically redirected back anyway. The status is then updated. If the customer closes the browser window, or browses elsewhere, the order status will stay at 'Paypal IPN Preparing'

 

Please note that the above is the case with the Paypal IPN constribution. If you do not have it, then it will likely be different. I recommend installing it.

How long has your site been like this? since you modified it? If so, consider rolling back using your backups. If your checkout files are not modded, you can copy the original OSC checkout files over them, but you must be SURE they were not modded. If they were, you'd have to re-install the mods into them.

[datoupee]

Maybe this is the problem...

 

http://www.oscommerce.com/forums/index.php?sho...p;#entry1022375

[pietervdw]

Well I had the same probleme... My order status table was empty.

 

Run this in SQL to add the records

 

INSERT INTO `orders_status` VALUES (3, 1, 'Delivered');

INSERT INTO `orders_status` VALUES (1, 1, 'Pending');

INSERT INTO `orders_status` VALUES (2, 1, 'Processing');