Order Missing from Admin Area

[vidmarc]

Somebody has just emailed to chase an order they placed back in June, but it is not displaying in the admin Orders area, although I do have an email confirming it came in. My only thought is that I may have deleted it by accident as I can't think of why it isn't listed.

 

If I click on the link in the confirmation email it says it is "Pending", yet it isn't listed in the orders list. Strange.

 

Is there any way or adding it back to the system, or retrieving it?

[bsmither]

"CubeCart says Order-X is "Pending", yet that order isn't listed in the Orders list. Strange."

 

Your sig says you are at CC5.2.1, which probably has issues with pagination. Can you confirm that the order, based on the order number, should be listed in with the group of 20 or so orders?

[vidmarc]

I'm running Cubecart 5.1.12. I'm running other versions on other sites I maintain.

 

The missing order number is 140626-062813-7241. I'm not sure how the system allocates these numbers , they seem rather random.

[bsmither]

The order number, 140626-062813-7241, is constructed as follows:

140626: 2014 June 26

062813: 06 Hours, 28 Minutes, 13 Seconds is a few seconds after 6:28 AM

7241: a random four digit sequence

 

In the 20 or so orders shown in the list, is there an order number that is before 140626 and an order number that is after 140626 listed within the group?

[vidmarc]

Here's a few around that time:

 

 

140629-123644-4214    

140628-152406-6357    

140628-074920-6044    

140628-011655-5250   

140628-004511-1351    

140627-192113-6063    

140627-105418-8239    

140626-184016-8750    

140626-150814-7519    

140626-113814-9699

140625-200901-8399    

140626-101417-5206   

140625-202558-2984

140625-092519-7339    

140625-073926-7985

[bsmither]

One final confirmation:

The address in your browser's address bar: does it look like this:

?_g=orders&node=index

 

or does it have anything else to it, like this:

?_g=orders&multi-status=&multi-action=&search[order_number]=&search[search_customer_id]=&search[status]=2&search[date][from]=&search[date][to]=

 

 

This sequence of orders:

140626-113814-9699

140625-200901-8399

140626-101417-5206

140625-202558-2984

are out of order, but that's understandable because the default sort order is by 'order_date' (the Date column of the Orders list) and not by 'cart_order_id'.

 

Please see if the order shows where you think it should be in the list when you click the down triangle next to the Order Number column heading.

[vidmarc]

The url is:

 

.../admin.php?_g=orders

[Toucan Web Design]

Something else to check up on, if you have access to the database, try going onto that and checking the table called CubeCart_order_sum, see if the order exists in there.

 

If it is, then what has likely happened is the one of the joined table references has gone missing, which is stopping it from showing up in the query

 

If it isn't, then it would sound like it was deleted in some fashion

 

Should help narrow down which of them it actually is.