Hello,
we are running 5.0.7 with no option to upgrade due to numerous custom modifications and features.
We receive around 10 order every day, using Paypal as the only payment option. We started having a very serious issue with the orders for last couple of months/weeks, when the customer goes through the order process, completes the payment which appears in our Paypal account, but the order (summary) itself is not saved into the database, meaning we dont really know about it.
When I search the entire database for the lost order ID, I see records in following tables:
store_CubeCart_order_history
store_CubeCart_order_inventory
store_CubeCart_order_tax
store_CubeCart_request_log
store_CubeCart_transactions
But NOT the all important CubeCart_order_summary. I tried setting up a debug condition for the database classes to detect if there is a "DELETE" and "order_summary" being executed, but Ive got nothing - meaning the summary is not saved at all.
Example data of one such lost order:
Status Date/Time
Processing 13 Mar 2013, 20:39
Pending 13 Mar 2013, 20:37
The order inventory:
[snip, three valid products]
Transaction log:
PayPal Card Payment: Success, Exact match for AVS data. CVV2 correctly matched., TXNID: 4FC98336766[snip, correct TXN ID]
Do you have any idea why the order is not being saved? I tried going through the order process in the classes, but I see no vulnerable points - and we have done no adjustments to the order process.
Was this a bug fixed in some of the latter versions, or could it be a Paypal issue?
Thank you in advance for any input, as this is a very serious issue.
Roman