Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Finding an order by osCsid


timgaunt

Recommended Posts

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

Link to comment
Share on other sites

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

 

Or did the order not process?

 

Rob

Rob Bell - Inspired Graphix

Customising osCommerce in Australia, and the world!

View my profile for web and email links.

 

I'm sorry, but i cannot offer Free support via PM etc, and osCommerce forums prohibit me from putting any reference to paid support in my signauture.

However viewing my profile may provide links to my website or something like that which you may find useful.

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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

Rob Bell - Inspired Graphix

Customising osCommerce in Australia, and the world!

View my profile for web and email links.

 

I'm sorry, but i cannot offer Free support via PM etc, and osCommerce forums prohibit me from putting any reference to paid support in my signauture.

However viewing my profile may provide links to my website or something like that which you may find useful.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

Thanks,

 

Rob

Rob Bell - Inspired Graphix

Customising osCommerce in Australia, and the world!

View my profile for web and email links.

 

I'm sorry, but i cannot offer Free support via PM etc, and osCommerce forums prohibit me from putting any reference to paid support in my signauture.

However viewing my profile may provide links to my website or something like that which you may find useful.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...