Products and Customers lost (but not Settings) after moving from local PC

[anotherbreed]

Hi,

I just moved my local PC wordpress site online by copying files and database. Everything is working fine but eStore seems to have lost all the products and customers stats, but settings are still there. I also did a quick deactivate and reactivate.

I checked the database tables and they do contain my original product and customers data. Somehow eStore is just not finding them.

Funnily enough I entered a new product with variations, hit save and received a msg indicating the product was saved successfully. I then went to the Manage Products panel to find nothing there.

Any ideas?

[anotherbreed]

I have fixed for now by deactivating, deleting the plugin and all the database tables of eStore. I reinstalled it, and now can add AND save products successfully.

The strange thing: Settings data is still there…!

I will work only online.

[wpCommerce]

Even if you deactivate, delete and reinstall the plugin your settings will be still same like before.

[amin007]

All the data is stored in the database and do not get deleted when you deactivate the plugin. This is to protect your data. Imagine what would happen if you mistakenly deactivated the plugin with thousands of products already configured!! This also make the plugin upgrade smooth as you don’t have to redo the settings or anything.

If you want to delete these data for good simply go to Your PHPMyAdmin and delete the database tables created by this plugin manually.

[anotherbreed]

Yeah I understand, but I don’t get how it can recall settings data even if I deleted all eStore database tables! Or why it didn’t read (and save new) products data already present in the database displaying me no products in the WordPress admin panel.

Maybe is there an other place where it saves those informations?

P.S.: I already solved my problem by adding everything again, but I’m interested in this discussion.

[wpCommerce]

Settings data are stored in the main WordPress database but products and customer records are not. The products and customer records are stored in a table that is created by eStore which sits inside your wordpress database. So after moving your database the settings were still there because you only moved the core database tables and not all the tables.

[rogersmj]

OK, but how about an actual answer as to why this happens? We frequently have to move sites because we don’t develop in a production environment, and we’ve found both eStore and eMember seem to forget all of our categories, products, etc whenever we import the MySQL database to another server. This seriously hampers our development cycle and we won’t be buying any more licenses until this is fixed.

[amin007]

I thought anyone working with database tables should have this simple knowledge:

For example, you have 3 tables in your WordPress database:

Table1 – holds record of Apples

Table2 – holds record of Oranges

Table3 – holds record of Mangoes

Now, when you move this WordPress database you only move table1 and table2 to your new server. Are you going to have access to the data stored in table3? No! because you didn’t transfer it. Thats exactly what is happening in this case.

WordPress has 11 core database tables that it creates at installation time. The tables are:

wp_commentmeta

wp_comments

wp_links

wp_options

wp_postmeta

wp_posts

wp_terms

wp_term_relationships

wp_term_taxonomy

wp_usermeta

wp_users

WordPress lets the plugin developers store their plugin’s settings data inside the table called “wp_options”. Now, how will a plugin store other data for example product data? WordPress says create a table inside the WordPress database and store it. So the eStore creates a table inside the wpdb with the following name:

wp_wp_eStore_tbl

This is where all the product data is stored.

When you transfer your server you are suppose to transfer every table inside your WordPress database (this includes the 11 core WordPress tables and any other tables created by other plugins).

What you are doing is only transferring the 11 core WordPress tables and leaving the other tables created by the plugin behind and asking me why the data is not on the new server! The settings data is there because it was stored in the “wp_options” table which you didn’t forget to transfer.

Let me know if it makes sense.

[Surfsupjoe125]

After migrating files to new host, there are some weird things going on. customers can pick product, complete sales transaction, receive email receipts, but they are not added to the customers list in eStore.

I have gone through everything with the host company as they are very familiar with WP and troubleshoot quite effectively.

Does anyone have any ideas or suggestions please

Cheers

[Ivy]

When you did the move did you remember to deactivate and reactivate the plugin. This needs to be done so the database tables sync.

You can read more about this here:

Issue(s) Related to Database Table Columns Out of Sync

https://support.tipsandtricks-hq.com/forums/topic/migrating-db-from-windows-server-to-linux-server-loses-products-and-categories

[Author]

Posts