eStore – can't view or add products though they are in the DB

[dward]

I have been using the estore plugin for years, and installed the latest version a few weeks ago for a new site (clean install). I am migrating one site to another, and started trying to manually enter products from the old site to the new one. Each time I tried to save the product on the new site, it was never created in the database, and didn’t throw an error message to that effect. Thinking it was a quirk, I successfully imported all of my products from the old site into the new one using the CSV bulk importer. I can see the correct data in mysql, but when I click on “Manage Products” it says “No products found.” What could be the cause of these strange problems? I thought that it might be the table wp_wp_eStore_cat_prod_rel_tbl, which was populated in the old site and not the new, so I copied the data (the IDs match). That didn’t have any effect.

[Peter]

Try deactivating and deleting the old plugin and then install a fresh version of eStore as per the following:

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

Then import all eStore data from the old site to the new site by using PHPMyAdmin as per this video:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

The following posts should also be very helpful:

https://support.tipsandtricks-hq.com/forums/topic/changed-hosting-db-is-screwy

https://support.tipsandtricks-hq.com/forums/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc

[dward]

Sorry, just noticed the post was answered, didn’t get an email. I have deactivated the plugin, deleted the directory, and downloaded and activated a fresh copy of the plugin. Now, in MySql I see two sets of wp-estore tables, some with a capital S (wp-eStore) and some with a lowercase S. The lowercase seem to have my data. Is the new version using the capitol S tables?

[dward]

Answered my own question – I simply took the data from wp_wp_estore_cat_prod_rel_tbl and wp_wp_estore_tbl and copied it into the respective capital S tables. Looks like all is working now.

[Author]

Posts