I have a site that is running well but I do need to shortly run and update to add new features to the shopping cart and a few other things. My plan for doing the updates is to use a singe site update page that users are redirected to while the update is happening. I will redirect all traffic using the .htaccess with a rule allowing only my personal IP to access the pages being updated.
This seems fine to me but I keep getting a concern in my mind about what happens to Customers who are in the middle of purchasing a product, Users who are entered there credit card details and get redirected to site update page. Now this may just be annoying for them which is bearable for me and I will do my best to warn uses before hand that the site will be updated at a specific time, but is it possible that the payment is processed by the payment gateway but that then my mysql DB is not updated with the new purchase details so that I have no idea a product has been purchased and the customer has no record of this transaction other than the money has been taken out of there credit card, which will reflect badly on our business and our site.
I would be grateful for some insight into how the experts do site updates that deal with shopping carts and what the best way to deal with this type of situation is?
Either I am simple being paranoid and this type of scenario just does not happen or I can have some light shone on the steps to dealing with this issue.
Many thanks as always for your help