As briefly as possible, my site went down a couple of days ago. I ended up having to restore an older database than i would have liked. While i searched for a more recent copy.
While that search was underway i made a sale.
The problem is this now that I have restored to my newer database backup how do i import that sale from the older database and all associated user data.
My goal is to not have to force my customer to sign up again but have it all ready from him/her to log in as he/she would expect....
Any help greatly appreciated I am running the latest versions of wordpress and wpecommerce plus I have the gold cart upgrade. I did try the getshopped personal 1 to 1 support but it seems to be down at the moment.
Francisco Javier Carazo Gil answers:
Here you can see the database schema: http://getshopped.org/resources/docs/get-involved/database-schema/
You should have all data of the user into wp_users but the data of sale should be in more than one table, so it is not so easy.
Many thanks for the prompt reply... I was hoping for something a little more specific. I have managed to find the order on the purchase_logs table and exported that. However since i have imported that record into the new purchase_logs table the order ID doesnt match up with the data underneath. and there is no recollection of this customer ever signing up ...
Arnav Joy answers:
these are the tables which holds the data for wp ecommerce
beside this all other tables of core wp are also used like for product and for users etc..
Do you think i have a hope of achieving my goal, or should i ask the customer to sign up again.. I would create his account again for him but i don't know the password he selected....
John Cotton answers:
If you've got his entry in the wp_users table, you can just copy it across to your restored version. You don't need to know his password, it's just a string in the database - WP takes care of the matching.
His ID in the old and new will need to match though.
Thanks John will give it a whirl..
John Cotton comments:
Don't forget that you need to copy over all the rows in wp_usermeta that match his id.