[osCmax V2.0.25] Finding a missing "In Transit" order. -- orders_status_history is messed up.

[Shortbus]

I always use the main admin screen to go directly to the "In Transit" orders. Right now the admin is saying that there is 1 order with the "In Transit" status, but when I click the link, it says zero orders are found. How can I find this missing order, or how can I clean up the table so that it reports the correct count of each order status?

osc_admin_in_transit.gif

[pgmarshall]

Have a look at Localization -> Order Status ... see if you have a "In Transit" order status listed.

If not, then you must have at some point in the past ... you will need to find the row in the database and remove/edit it ... use phpMyAdmin or similar ...

Regards,

[Shortbus]

"In Transit" is one of my order statuses. It has been since the day I installed osC many years ago.

The problem is that the totals are not matching up. The Admin splash screen numbers are inaccurate. In the screenshot I posted it said one order was In Transit, but it's not true. Zero of the orders were in transit. Currently (in real time) there are 7 orders in transit, but the admin splash screen is reporting there are 8.