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

Tips and Tricks HQ Forum » WP eStore Forum » WP eStore Troubleshooting

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

(8 posts) (4 voices)

Tags:

No tags yet.

anotherbreed
Member

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?

Posted 2 months ago #
anotherbreed
Member

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.

Posted 2 months ago #
wpCommerce
Moderator

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

Posted 2 months ago #
amin007
Key Master

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.

Posted 2 months ago #
anotherbreed
Member

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.

Posted 2 months ago #
wpCommerce
Moderator

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.

Posted 2 months ago #
rogersmj
Member

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.

Posted 2 months ago #
amin007
Key Master
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.
Posted 2 months ago #

RSS feed for this topic

Reply

You must log in to post.