Manually enter an order.

[hermes369]

I'm not sure if this is the right place to ask this question:

A customer received an odd email including a php MySQL error. Their credit card was charged and we are able to reconstruct the order. However, because of the hiccup, the customer's order does not show up in Zen Cart.
I'm wondering if I can manually enter an order. I'm worried about doing this because I don't want to upset the order numbers and I don't want to charge them a second time. The only solution I can imagine is to insert the record into MySQL directly. I need to know what tables I need to update and how so I don't disrupt the proper functioning of the site.
Of course, since this is the first time I've seen this happen, I'm happy to let it go; unfortunately, my client is being insistent.
I appreciate the help.

[stevesh]

I used to have to do something like this when I had a problem and Payflow Pro didn't send the order after confirmation.

I had installed the Master Password mod, so I would temporarily turn off email sending and temporarily enable the COD payment module.

Then I'd log in as the customer in question and create and complete the order, using COD as payment.

Don't forget to re-enable emails and to unenable the COD option when you're done (voice of experience).

Not sure there's anything you can do about order numbers.

[hermes369]

Thanks for the tip! I'm guessing that your experience with Master Password is positive. I'm a little leery of installing mods as I'm still quite the noob and don't want to break anything.