Kryptronic Software Support Forum

We have more than  in common, see the thread
Unfortunately, no resolution - I'm still waiting from some guidence from a guru how to debug further....

I've verified that the response comes back approved and CCP parses it correctly, but I'm at a loss where to go from there...

Same frequency of occurence with me (AuthNet).  I was forced to add code to send me an email for every AuthNet response and watch for ones with no matchng order emails.

hello Kaz, its good to see I am not the only one experiencing this.

I have Quickbooks download that selects only new orders that are at "Pending Shipment". To save on admin, I took the decision a while back to stop reconciling confrmation emails. So when the status is not correctly set, the first I hear about it is when a customer complains they have not received their order.

I have a sneaky feeling there is a locking problem lurking somewhere. I have no real evidence for this, but I have had problems in the past with order records not accepting updates from my Quickbooks download program. I narrowed this down and determined that the download was unable to update an order record if that order record had just been updated using the CCP Admin function. To prove it was nothing to do with the download, I executed the download SQL using the CCP SQL Submission page and the same problem occurred.

I'd be interested if you have the same problem. If you have a test system its easy to check, on any order record, just update the 'Exported to Accouting Software' flag to YES using CCP admin. Then try to submit the following SQL using the "SQL Statement Submission" page:

UPDATE tracking
SET tracking_accexp='N'
WHERE tracking_accexp='Y'

When I do this, the update is ignored and the flag is still NO