Pending Orders Qty is Wrong

[kirchenbauer]

I have a situation that I have seen posted, but cannot find the exact resolution.

 

When I was configuring my Authorize.net, my "Pending Orders" total that is

on the main administration page got messed up. Currently the actual Pending

Orders is Zero, but the Pending Orders says 46.

 

I asked my web host if I can just go in under the Orders in phpMyAdmin and

delete the records from that table. They said to do what I need to do to fix

it if it's wrong (They didn't really answer my question).

 

My question is whether or not I will mess something up if I go into the Orders

table in phpMyAdmin and delete the records from in there. Is there a different

way to do this? I don't want to throw other records out of wack.

 

I appreciate the help.

Sherry

[♥Monika in Germany]

I have a situation that I have seen posted, but cannot find the exact resolution.

 

When I was configuring my Authorize.net, my "Pending Orders" total that is

on the main administration page got messed up. Currently the actual Pending

Orders is Zero, but the Pending Orders says 46.

 

I asked my web host if I can just go in under the Orders in phpMyAdmin and

delete the records from that table. They said to do what I need to do to fix

it if it's wrong (They didn't really answer my question).

 

My question is whether or not I will mess something up if I go into the Orders

table in phpMyAdmin and delete the records from in there. Is there a different

way to do this? I don't want to throw other records out of wack.

 

I appreciate the help.

Sherry

 

orders actually consist of a bunch of tables. Do you want to get rid of all order info up to today? if yes, empty all orders tables apart from order status. Check the content of each table beofre you empty it, it must not be one of the reference table for list boxes (like orders_status).

[kirchenbauer]

orders actually consist of a bunch of tables. Do you want to get rid of all order info up to today? if yes, empty all orders tables apart from order status. Check the content of each table beofre you empty it, it must not be one of the reference table for list boxes (like orders_status).

 

Thank you for the reply Monika.

 

I have not used SQL or PHP before. From what I understand that you are telling me,

the main table is "orders" and "orders_status" is a sub-table. If I ever want to change

the information in any of my tables, then it needs to be from the top level, not the

sub-table.

 

I can delete data from the "orders" table, but not from any of the sub-tables (such as

"orders_status" or "orders_products").

 

Can you please let me know if I am understanding this correctly?

 

Thanks again,

Sherry

[♥Vger]

You need to look at the orders_status_history table. Look for the order id and see if you have multiples with the same order id all set to status 'pending' (which is usually 0). Then you can tick the box to the left of the extra ones and elect to 'drop' them from the database.

 

Vger

[kirchenbauer]

Thanks for the reply Rhea.

 

I checked the "orders_status_history" and it only has

12 records in it, so that doesn't seem to solve it.

 

In the "orders" file, I have 46 orders with me as

the customer. Of course, non of them are real

orders. They were from when I was trying to

configure and test my Authorize.net contribution.

 

I need to know if I can delete them from the

"orders" file, and Monika answered me but I just

want to make sure that I understand her correctly.

 

Thanks again for taking the time to advise me.

The osCommerce support forum is a great help

and very appreciated.

[♥Monika in Germany]

Thank you for the reply Monika.

 

I have not used SQL or PHP before. From what I understand that you are telling me,

the main table is "orders" and "orders_status" is a sub-table. If I ever want to change

the information in any of my tables, then it needs to be from the top level, not the

sub-table.

 

I can delete data from the "orders" table, but not from any of the sub-tables (such as

"orders_status" or "orders_products").

 

Can you please let me know if I am understanding this correctly?

 

Thanks again,

Sherry

 

nope! If you want to delete an order, you have to remove all references it has ... like in orders_products, orders_total ect. The order_status table has nothing to do with orders itself, it's a lookup table for the dropdown for order status, you must leave that one alone (but it doesn't have a column orders_id anyway so it's pretty clear it's standalone)

[kirchenbauer]

If I delete all reference to the orders in those order tables,

it won't mess up any of the other tables? Meaning, is there

a relationship to another table that I could mess up?

 

I have been reading about SQL and learning how it works,

but I am not sure if an order updates more tables than

just the order tables.

 

Will I be safe to just delete all references to the orders

from the order tables? I guess I already asked that

question, huh? I'd better get some sleep. It's 4am here.

 

Thanks for the help!

Sherry

[♥Monika in Germany]

If I delete all reference to the orders in those order tables,

it won't mess up any of the other tables? Meaning, is there

a relationship to another table that I could mess up?

 

I have been reading about SQL and learning how it works,

but I am not sure if an order updates more tables than

just the order tables.

 

Will I be safe to just delete all references to the orders

from the order tables? I guess I already asked that

question, huh? I'd better get some sleep. It's 4am here.

 

Thanks for the help!

Sherry

 

Hi Sherry,

 

the set of orders tables will not mess up anything, don't worry. Just closely watch out for that 8or those) special orders numbers you want to get rid of, and walk through the tables.

[kirchenbauer]

Thank you! I deleted the pending orders from the order tables and it looks great!

[DavidR]

Thank you! I deleted the pending orders from the order tables and it looks great!

 

I vaguely remember dealing with this issue when I mistakenly thought that deleting my test account would automatically delete the orders associated with it. IIRC, I got the order numbers from the db and manually inserted each into the query string that allowed the script to delete all the bits normally (sorry so foggy on this, my memory is getting bad!). If you just deleted them from the orders table, doesn't this leave entries in the other orders* tables?

 

David

[kirchenbauer]

Hi David,

 

I actually went into all of the "orders" tables and deleted the pending

orders that shouldn't have been in there.

 

It didn't take too long. There were 46 orders that I deleted.

 

I am starting to learn SQL as of last night, so I understand what

you mean about the query.

 

I am glad to have them gone now.

 

Thanks,

Sherry

[DavidR]

Sometimes doing something manually like that can help you learn - I've done my share :). Good luck.

 

David