Jump to content

Order Missing from Admin Area


vidmarc

Recommended Posts

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?

Link to comment
Share on other sites

"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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...