Billing address WooCommerce database table

Question

I would like to know, what database table is WooCommerce using for the Billing Address for each user?

I really need to know, because I need to import users from another database. Thanks.

table usermeta, connecting user_id to db table users... – Reigel Gallarde Apr 19 '16 at 08:01 — Reigel Gallarde, Apr 19 '16 at 08:01

score 2 · Accepted Answer · answered Apr 19 '16 at 08:14

2

The table used for customers billing address is 'usermeta'.

To import users from an other database, you need the data from 'users' and 'usermeta' tables…

answered Apr 19 '16 at 08:14

LoicTheAztec

score 2 · Answer 2 · answered Apr 09 '19 at 20:21

2

It's actually wp_postmeta. Just filter required order ID in post_id column.

answered Apr 09 '19 at 20:21

Mike Shema

2 Answers2