No street address column in customers table

Hi @kluo,

There are city, state, country and postal code. But why there is no street address in customers lookup table?

I’m not sure I specifically understand where in WooCommerce you are looking, could you help clarify for me? When you say a lookup table, I assumed you’re not looking specifically in the database. ??

Thanks!

@ryanr14 – Hi, I’m looking in the database, but also on the front end, there is no street address. I’m looking at Admin panel -> WooCommerce -> Customers.

Hi @kluo,

I’m looking in the database, but also on the front end, there is no street address. I’m looking at Admin panel -> WooCommerce -> Customers.

Thanks so much for clarifying. I don’t see the fields from within the Customers report either and that isn’t included in the export I can use from there. I assume then of course, as noted, it’s not in the lookup table that powers this report.

You’d mentioned the front end as well, are you saying at checkout there’s not a field for the street address too? I know my test site has that, so it’s definitely collected as a field on user profiles. I just wanted to be sure you have that as well.

Either way, ultimately I think you’re wanting a street address for some reporting reason. What is your end goal you’re after and perhaps we can find a way to get there!

@ryanr14 – Hi: By front end, I mean the admin panel of WP. That’s what I’m confused about, because at checkout, I filled in the address but it looks like only street address was not saved in customers report.

So, my end goal is to access WP database and export guest customers data out. The table I’m using is wp_wc_customer_lookup, which is the table that powers the customers report.

I think I’m confused because since WP already stores city, state and country during checkout, it doesn’t make sense to not store street address.

• This reply was modified 3 years, 3 months ago by kluo.

Hi @kluo,

Ah ok, that makes more sense.

So, my end goal is to access WP database and export guest customers data out. The table I’m using is wp_wc_customer_lookup, which is the table that powers the customers report.

I would then suggest using the wp_users and wp_usermeta tables. That’s where you’ll be able to get a user email and match it with their user ID. With that ID you can then get the details like billing address, etc… saved to the users account

There are also extensions that could help get that data for you as well, if that’s helpful, but if you’re comfortable in the database I assume you want to stay there. ??

https://woocommerce.com/products/product-csv-import-suite/

Ultimately maybe an article like this also helps explain where bits of data are from WooCommerce. – https://usersinsights.com/woocommerce-customer-database/

I hope this helps so far, let us know if you’ve got further questions. Thanks!

Hi @kluo

We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above information was helpful. If you have further questions, please feel free to open a new topic.