Hi Ray, I have a problem that pops up every so often with saving orders to the db, it's happened twice this week.(over a few hundred sales)
There are two types of failure.
1.The user will be directed to PayPal then back to our site to confirm the sale, the sale is completed and funds credited to our PayPal account, however no record is saved in our db.
2.The user uses their credit card on our site, the transaction is completed and funds credited to our PayPal account, however only partial details are captured, the sales lines are saved but no customer data.
I use jsvalidate to confirm the info on the checkout page, to keep our stock levels accurate as soon as an item is placed in the cart, an order is generated with the session id, so in our case our database will accept null values in all the summary fields except for the session id field.
Both methods use the same save order code by using an include to another file with the eCart store summary and details.
Wondering if you've come across this or have any ideas