Ask your WordPress questions! Pay money and get answers fast! (more info)

Help with Wpecommerce WordPress

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.

Answers (4)

2012-10-17

Francisco Javier Carazo Gil answers:

Hi,

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.


Stewjd comments:

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 ...

2012-10-17

Arnav Joy answers:

these are the tables which holds the data for wp ecommerce

wp_wpsc_also_bought
wp_wpsc_cart_contents
wp_wpsc_checkout_forms
wp_wpsc_claimed_stock
wp_wpsc_coupon_codes
wp_wpsc_currency_list
wp_wpsc_download_status
wp_wpsc_meta
wp_wpsc_product_rating
wp_wpsc_purchase_logs
wp_wpsc_region_tax
wp_wpsc_submited_form_data

beside this all other tables of core wp are also used like for product and for users etc..


Stewjd comments:

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....

2012-10-17

Sabby Sam answers:

Hi,
Make a one testing site and try to evaluate on testing first and then transfer this site to the main site.
I hope this will help you.

2012-10-17

John Cotton answers:

Hi Stewart

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.

JC


Stewjd comments:

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.