Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › Products and Customers lost (but not Settings) after moving from local PC
Tagged: local host move missing data
- This topic has 9 replies, 6 voices, and was last updated 10 years, 8 months ago by Ivy.
June 20, 2010 at 4:52 pm #1397
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?June 20, 2010 at 9:06 pm #21903
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.June 21, 2010 at 12:18 am #21904wpCommerceModerator
Even if you deactivate, delete and reinstall the plugin your settings will be still same like before.June 21, 2010 at 12:47 am #21905amin007Participant
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.June 21, 2010 at 8:20 pm #21906
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.June 22, 2010 at 1:58 am #21907wpCommerceModerator
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.June 24, 2010 at 1:52 pm #21908rogersmjMember
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.June 25, 2010 at 1:37 am #21909amin007Participant
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:
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:
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.July 5, 2012 at 10:18 pm #21910Surfsupjoe125Member
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
CheersJuly 5, 2012 at 11:56 pm #21911IvyMember
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:
- You must be logged in to reply to this topic.