Guest Posted August 7, 2005 Posted August 7, 2005 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?
kirchenbauer Posted September 30, 2005 Posted September 30, 2005 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.