pending orders

[Guest]

Just started using osCommerce in administration under pending orders it shows 23 but when I click on it nothing comes up, is something wrong or is this normal...

[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