My order disappeared

[Guest]

Here is what happened:

 

I had an order placed (08/16 $59.37). I accessed the order and changed the status from pending to "processing" (an order total status i created) from the drop down menu. I left the "Notify Customer" & "Append Comments" radio buttons checked, and clicked update.

 

This is where it got weird.

 

When the page refreshed, a new line had been added to the history table above, as expected, but the only field populated was the "Date Added" field. The other three fields, were blank. I immediately knew something was wrong. I refreshed the page but no change. I logged out and logged back in (not sure what that would possibly accomplish, but didn't know what else to do).

 

This is when it got weirder...lol

 

I went to CUSTOMERS > ORDERS to go back to the order and see if logging out and back in had changed anything but now the order does not appear in the list of orders. I went to the front "Administration" page, where it shows my Customers/Orders graphs, and it indeed shows a sale for 08/16 $59.37 on the graph. I went to CUSTOMERS > CUSTOMERS, clicked on the customer in question, then clicked ORDERS. It only shows the customers previous order from 08/03, not the new one. Sigh. I went to my payment processors site and checked balance and the order HAS been paid for.

 

So clearly the order was placed and paid for, but other than the graphs from the front page of the admin section, all evidence of the sale has vanished. Oh, and inventory count reflects the sale also, in the sense there is the appropriate amount less of inventory. But that and the graphs are it.

 

That's where I am now. I have no idea what to do from here to recover the data and can't afford hundreds for tech support.

 

Thanks to anyone willing/able to help. :)

 

P.S.

My username is a f'n typo. Only supposed to be one, "O"

[Guest]

Sorry, I am using version 2.3.

[BryceJr]

>>This maybe a long shot but worth a try.

[Guest]

Done. Not sure what effect it will have on new orders yet but it didn't recover the missing order info.

 

The info is in there...somewhere. I know because the graph acknowledges the sale and so does the inventory count.

 

Thanks for the attempt though. :)

[satish]

Check order status and order history tables.

 

Satish

[Guest]

Unfortunately, I have zero experience with editing or viewing tables.

[♥kymation]

Then now is the time to learn. If you know the order number, look for that number in the orders_id field of the orders table. More information can be found in the orders_products table. If your order is not in any of those tables, it was deleted or never recorded. If it is there, you need to find out why your Admin is not displaying it.

 

If you don't know the order number, look in the orders_total table for the total price, then use the associated orders_id to find more information.

 

Regards

Jim

[scandic_outlet]

do like kymation says - check the order table, and i suggest escpecially checking the order_status - my guess is the field might be empty or have 0 in it.. if that is the case, you wont be able to bring the order up in you admin interface.

Change the number to any of your order statuses, e.g. 1 - for standard order status, and you should be set to go.

 

best of luck.

 

regards

[Guest]

I can get into phpmyadmin but i don't know what to do once I am there. There is a LOT of information, and i don't need to make things worse.

[♥kymation]

Click on the table name in the left column. That should give you a view of the data. If necessary, click the Browse tab at the top. New orders will be near the end of the list. Click the > button to see the next page, or the >> button to see the last page.

 

Regards

Jim

[Guest]

Ok. I poked around and figured it out. The field was set at zero. I changed it to one and my order re-appeared.

 

I was able to set the status to delivered and move on.

 

Thank you all and to all a good night!

 

Very much appreciated. :)