SECpay Order ID & OSCommerce Cart Order ID

[ritun]

How to relate SECpay Order ID & OSCommerce Cart Order ID? Can anybody help me out? Please... :(

[Mark Evans]

How to relate SECpay Order ID & OSCommerce Cart Order ID? Can anybody help me out? Please... :(

 

The problem with this is that the order id in oscommerce is not created until after the system has returned from secpay.

 

This is something that will be addressed sometime in the future.

[ritun]

Hi Mark,

Thanks for your reply. Well, I've found out a solution for this problem and has already implemented in our cart. I'm generating a random number based on Date and Time in the checkout_payment.php and assigning it to the variable of 'info' type in the 'order.php' class. I've added one more field in the 'Orders' Table in the database to store the value of this variable after the Order generation. This value is then sent to SECpay thru their 'trans_id' field and can be retrieved from the database in the 'order.php' in ADMIN against a particular 'Order' as any other 'info' variables (like comments etc.) are called. This may seems to be a crude solution, but it's working and we have achieved a minimal relationship. I hope this information will be useful for those who cannot wait for an updated OSCommerce cart. If anybody has any other useful suggestions, please let me know.

Regards,

 

Ritun

[Guest]

Hi Ritun / anybody,

 

I'm having a similar problem 2 1/2 years after you posted your fix! Surprised it's not been sorted yet and nobody else has asked about it since. I can't believe most people don't want the order numbers to match between osC and SECPay.

 

Anyway, what's unclear to me is that I'm using a random order number contrib that creates a 'standard' integer but SECPay is receiving an order number from my cart that is based on the date and time.

 

Will your fix solve this issue, do you know?

 

Would you mind posting the code I need to change in the order.php class?

 

Many thanks

 

Clive

 

 

 

Hi Mark,

Thanks for your reply. Well, I've found out a solution for this problem and has already implemented in our cart. I'm generating a random number based on Date and Time in the checkout_payment.php and assigning it to the variable of 'info' type in the 'order.php' class. I've added one more field in the 'Orders' Table in the database to store the value of this variable after the Order generation. This value is then sent to SECpay thru their 'trans_id' field and can be retrieved from the database in the 'order.php' in ADMIN against a particular 'Order' as any other 'info' variables (like comments etc.) are called. This may seems to be a crude solution, but it's working and we have achieved a minimal relationship. I hope this information will be useful for those who cannot wait for an updated OSCommerce cart. If anybody has any other useful suggestions, please let me know.

Regards,

Ritun

<{POST_SNAPBACK}>