wp eStore database tables

[giggzey]

Hi

Could anyone help me with this…?

1/ If I reinstall wordpress on my site, how do I get WP eStore plugin to recreate its database tables (before the next purchase)?

2/ BEFORE I reinstall wordpress , is there anything I need to be made aware of about WP eStore?
I mean: if WP eStore is to be used again on the site, make sure “…” is done first before reinstalling wordpress (please fill in the blanks if there’s something to be done)

Many thanks,
Giggzey

[wzp]

1/ If I reinstall wordpress on my site, how do I get WP eStore plugin to recreate its database tables (before the next purchase)?

If the intent is to “nuke” your existing eStore and start all over again:
WP eStore –> Admin Functions –> The Almighty Reset Buttons –> Pick one or more buttons of doom

2/ BEFORE I reinstall wordpress , is there anything I need to be made aware of about WP eStore?

Unlike some of our other plugins, there are not license key deactivation/reactivation steps required.

• This reply was modified 1 year, 9 months ago by wzp.

[giggzey]

Aha! I didn’t realise you had replied until i checked my junk box lool!

First, thanks for your guidance and answers to my questions…
Ok so please accept my apologies, I see that maybe I wasn’t clear enough before, I don’t intend to nuke eStore *undo boom* :-),
I just want to add eStore database tables because they were deleted during a WPress reinstallation (I changed my site from a WPress single site to WPress Multisite), and by so doing the wpress database was nuked and recreated, unbeknown to me that the eStore tables were gone in that process. So now the WPress is installed as a multisite along with database & tables but eStore is missing its tables in this database.
So I just want to add the eStore db tables and keep all other [plugin] settings as is. So this is not about reinstalling eStore, instead just about adding the eStore tables to the db. Is it possible? (I don’t mind if you can give me the full SQL statement that I can execute here in PhpMyAdmin to add these eStore tables into the db)

Also, I have a question:
I found that when I go to “WP eStore->Manage Customers”, a table is displayed with the following columns:
“Customer ID|First Name|Last Name|Email Address|Product ID & Name|Transaction ID|Date|Price|Paid blabla…”

The rows displayed on this table, where are they stored??
(I’m asking because at the moment, I don’t have any eStore table in my WPress db as I explained earlier, so where are these rows of data coming from?)

Many thanks for your help 🙂
G.

[admin]

Hi, The data of the “Manage Customers” menu will be in the following table:

wp_eStore_customer_tbl

When you activate the plugin, if tables are not there, it will try to auto create the DB tables within the WP database (where the plugin is installed). So try deactivating the plugin and re-activating it.

In your case, you might be looking at the wrong database table. If you have multiple WP installs on your hosting account, you need to make sure that you are looking at the correct WP table for that WP installs. Each of your WP install will have a separate WP database. The tables for that site will be within that WP database.

The issue that you are facing is related to migration gone wrong or backup/restore of site gone wrong. So my answer may not be to the point.

[giggzey]

Okay, I deactivated and activated the plugin, it’s all fixed now 🙂

(Also just for good measure, i double-checked the db, wpeStore is using the correct one for the said site)

Wonderful, thanks folks!
*boom!*

[giggzey]

Setting to Resolved

[Author]

Posts