Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Pending Orders


Guest

Recommended Posts

For some reason when I log in to my admin, my pending orders section says "4" even though there is 0 orders pending...how do i get it to restore back to the default of 0...anyone?

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

quantity.

 

Hope this helps,

Sherry

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...