Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Pending order counters


Recommended Posts

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!

Jason Miller


Link to comment
Share on other sites

  • 1 month later...

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



Hope this helps,


Link to comment
Share on other sites


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

  • Create New...