woocommerce database structure??? | WordPress.org

johanna75
(@johanna75)

7 years, 6 months ago

Hi all,
In phpmyadmin the registered customers seems to be in 2 differents tables?
One with only name, email and login
And a second one with delivery adress and all the rest.

I need to import from an excell file new customers but how to do this in 2 mixing tables…
I’m lost, please help! 🙁

Viewing 2 replies - 1 through 2 (of 2 total)

anphira
(@anphira)

7 years, 6 months ago

@johanna75 that is the standard WordPress user structure. The essential details (username, pass, email) are stored in the wp_users table while all data about a user (access level, capabilities, address, etc) are stored in the wp_usermeta table.

I’d recommend looking at a plugin to help you with the import, I haven’t used this plugin but it is well rated: https://wordpress.org/plugins/import-users-from-csv-with-meta/

Thread Starter johanna75
(@johanna75)

7 years, 6 months ago

Thanks u very much anphira !
Will check

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘woocommerce database structure???’ is closed to new replies.

In: Plugins
2 replies
2 participants
Last reply from: johanna75
Last activity: 7 years, 6 months ago
Status: not resolved