Server went down lost 20 days of customers and orders

[supersnow]

Hi there, well I have had a big lesson this week; backup the database on a regular basis especially around busy times. Well our site went down due to our hosting company have "issues" and even though they assured me that my database and website were fine it was just a technical problem I have loss all my orders and new customers since the start of the month.

Well my question is how can I easily restore the orders, the correct order comments and status etc plus restore the customer information using either sql statements or via the zencart admin?

For the customers that made an order I least have their shipping and billing address and pretty much everything else, just not a password, and I thought of using the mod for adding customer from admin http://www.zen-cart.com/index.php?ma...roducts_id=454
put I am worried about the customers that i only have a email and name from the create account email we were sent by the system, how do we add these?

But the next problem is adding the orders. I am quiet comfy using mysql for the most part but i would like some suggestions for inputted the data into the various tables that cover the orders. Any suggestions on a sql statements etc would be fab!

Also how can I restore the gift certificates, only have a few of those and I would like to make sure that they are allocated correctly. Have a few that have been sent out via email and have the codes but have not been redeemed as of yet by the recipients, some that have been redeemed but not spent, i.e. person has the amount in their gift certificate account. Some that have purchased sent, redeemed and have been spent. So I just need some help to make this all visible in the database again.

I am kicking myself and not getting a lot of sleep because of not doing backups and I would really like any help.

Thanks so much.

[Webskipper]

Sorry to hear this.

All I can say is that after my host screwed up I started burning a copy of the site every month around the 1st and also after every big update.

The host must have a copy.

Work with what you have and go forward.

[bobdog]

Wow, sorry to hear this.

A few years back I had bad experiences with a local web host. They were constantly going down and reverting to months old backups.

I guess you just learned the hard way- Always have current backups.

[supersnow]

Thanks for the sympathy and yes I have learnt the hard way.

But does anyone have advice on how to turn the email confirmation and create account emails etc into data in the database?

[kobra]

I am kicking myself and not getting a lot of sleep because of not doing backups and I would really like any help.

If you have cPanel as an account management tool , others might be similar, a DB backup takes less than 5 minutes and normally on the order of 2 or less minutes.

Backup the DB daily to insure that you might only lose that days activity...Time well spent.

Reconstructing 20+ days of activity is not going to be easy if even possible.

[DrByte]

Um ... just do it.

- for the customers for whom you have enough information (ie: an order) add them
- for those you don't ... either forget them, or email them and ask them to come back and re-register
- for the orders, impersonate the customer (ie: master password contribution) by logging into their account, and place the order. Maybe change their email address to point to yourself first, or turn off email altogether while doing this.
- for gift certificates ... sorry ... if you've lost the data, you've lost the data. The only way you could reconstruct part of it is to tally all the details from your email records and manually fudge the data into the database tables http://www.zen-cart.com/wiki/index.p...fig.2FTracking

And where you don't have the info, blame the server crash.
Surely your host has better backups than 20 days ago ... ?

[supersnow]

- for the customers for whom you have enough information (ie: an order) add them
- for those you don't ... either forget them, or email them and ask them to come back and re-register
- for the orders, impersonate the customer (ie: master password contribution) by logging into their account, and place the order. Maybe change their email address to point to yourself first, or turn off email altogether while doing this.
- for gift certificates ... sorry ... if you've lost the data, you've lost the data. The only way you could reconstruct part of it is to tally all the details from your email records and manually fudge the data into the database tables http://www.zen-cart.com/wiki/index.p...fig.2FTracking

Thanks for the advice but how do I turn off email altogether? I would suspect somewhere in configuration in the admin; but can you point me in the right direction?

In regards to the manually fudging the information into the database I am willing to do it. Does anyone have any suggestions with the sql statements I can use to make it a little easier?

[DrByte]

how do I turn off email altogether? I would suspect somewhere in configuration in the admin; but can you point me in the right direction?

Admin->Configuration->Email Options->Send Emails? --- set to false

In regards to the manually fudging the information into the database I am willing to do it. Does anyone have any suggestions with the sql statements I can use to make it a little easier?

Have you collected all the Gift Certificate details yet?

[supersnow]

Admin->Configuration->Email Options->Send Emails? --- set to false

Great thanks!

Have you collected all the Gift Certificate details yet?

Yes I have everything on saved email