Finding an order by osCsid

[timgaunt]

Hi,

 

One of our orders payment callback failed the other day (from WorldPay -returned a 500-100 error) and I'm trying to find out what the customer paid for.

 

The catch however is that I can't find the customer's matching records anywhere in our database -I think they paid using another name but I do have the request from WorldPay so I have the osCsid.

 

Can anyone tell me how I can find this customer -and more importantly their order?

 

Thanks.

 

Tim

[shooter-boy]

You can't match the amount and date with orders in your system?

 

Or did the order not process?

 

Rob

[timgaunt]

You can't match the amount and date with orders in your system?

 

Not that I can see, there are several orders for the same amount and none of the times/names appear to match.

 

Or did the order not process?

 

It's not appearing in the list so I'm guessing not though it should have as the user was sent to the payment gateway...

[shooter-boy]

This is correct, if the payment went through then it should be there in the db.

 

The only way to possibly match a session id to a user is having a look in your database at your sessions table, but it auto-cleans so i doubt it will still be in there.

 

Rob

[timgaunt]

This is correct, if the payment went through then it should be there in the db.

 

The only way to possibly match a session id to a user is having a look in your database at your sessions table, but it auto-cleans so i doubt it will still be in there.

 

Sadly it's not there. It odd that the user doesn't exist, is there any other indicator as to the user from the information sent to/from the payment gateway?

 

Tim

[shooter-boy]

That comes down to your payment gateway... which i can't really advise on.

 

Thanks,

 

Rob