Export customer ID

Resolved antoine69
(@antoine69)

3 years ago

Hi,
From Woocommerce > customers > Export, is there a way to have export the customer ID (the ID in the database) ?
Thanks

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

Jahidul Hassan Mojumder
(@jahidulhassan)

3 years ago

Hi @antoine69,

If you export users from your site using this plugin, you will have a column named source_user_id. That will show the user ID and I believe this is what you are looking for.

I hope it will help. Thanks!
Thread Starter antoine69
(@antoine69)

3 years ago
Yes, I know I’ve tried it, but in my case, the plugin doesn’t export the 3 Woocommerce field like ‘number of orders’, ‘total spent’ and ‘AOV’ all three together. If your plugin adds these 3 fields in Export, I’m OK, if not, I need something else.
I am asking about the ID export from the Woocommerce , per default, export.
Thanks
- This reply was modified 3 years ago by antoine69.
xue28 (woo-hc)
(@xue28)

3 years ago

Hi @antoine69

Thanks for reaching out!

I understand that you would like to export the Customers ID from your site.

By default, this is not included when you download the CSV file under WooCommerce > Customers.

I did some research and found this article could be a good starting point: How to Export WooCommerce Customers to CSV, Excel, or XML

Hope this helps!

Thread Starter antoine69
(@antoine69)

3 years ago

Thank you Xue28.
I think I’ve tried each download customer plugin for Woocommerce (3 or 4 at this time) to get the most out of it.
WPALLEXPORT for customers Export is not free.
Thanks

Igor H
(@ihereira)

3 years ago

Hi,

I understand you want to get the customer ID(s), if you have access to the database you can check the table <strong>wc_customer_lookup</strong> it will show the customer IDs.

This is on the WooCommerce side:

This is on the database side:

A popular plugin to explore the database is https://ww.wp.xz.cn/plugins/wp-phpmyadmin-extension/

Once you have the data you can send it to a CSV file, spreadsheet, etc.

I hope this information is helpful to you.