Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

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

by

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, 9 months ago by Ivy.
Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • June 20, 2010 at 4:52 pm #1397
    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?

    June 20, 2010 at 9:06 pm #21903
    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.

    June 21, 2010 at 12:18 am #21904
    wpCommerce
    Moderator

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

    June 21, 2010 at 12:47 am #21905
    amin007
    Participant

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

    June 22, 2010 at 1:58 am #21907
    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.

    June 24, 2010 at 1:52 pm #21908
    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.

    June 25, 2010 at 1:37 am #21909
    amin007
    Participant

    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.

    July 5, 2012 at 10:18 pm #21910
    Surfsupjoe125
    Member

    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

    July 5, 2012 at 11:56 pm #21911
    Ivy
    Member

    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:

    https://support.tipsandtricks-hq.com/forums/topic/issues-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
Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • WP PDF Stamper Documentation
  • WP Photo Seller Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial
  • WP Photo Seller Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2023 | Tips and Tricks HQ