Pending order counters

[jam583]

My main page, where it says how many pending orders I have, isn't accurate. How can I update this so it is accurate? Thanks!

[kbakba]

My guess is in the ADMIN area under Customers......Orders.....you have to go into each order and "edit" the "status" of the order manually.

[kirchenbauer]

I had the same problem and found that it was due to

the testing I did when setting up Authorize.net. Any

orders that Authorize.net didn't process, because I

hadn't set it up correctly, ended up as pending orders,

but the orders didn't show up when I clicked the

Pending Orders link.

 

I resolved this (after some assistance here at the

osCommerce forum) by going into the MySQL

database order tables and deleting the bogus pending

orders. If you aren't sure which orders are bogus,

go to "orders_status" and see what code your database

uses for pending orders (usually 1 is pending, 2 is

processing, and 3 is shipped).

 

Then, delete the orders that are pending that should

not exist. In my case, it was easy because I shouldn't

have had any pending orders. I deleted all of the

pending orders.

 

You will want to delete them from all of the "orders"

tables if they are present. They won't be in all of

the tables. Most likely, they will only be in the base

"orders" table.

 

Your Pending Orders should now reflect the correct

quantity.

 

Hope this helps,

Sherry