WordPress Users & WooCommerce Customers Import Export is an ideal plugin for exporting and importing user/customer details to and from your WooCommerce store.
Features Offered
- The main migration methods are:
- Quick import/export
- Based on a Pre-saved template
- Advanced import/export
- Import/export data processing in batches ensures successful import/export irrespective of its size/count.
- One can automate migration via FTP profiles and schedules.
- Detailed history, debug logs and cron schedules are other main peculiarities.
Pre-requisites
- Make sure mbstring is enabled on the server.
- Both CSV/ XML and XLSX file formats are supported.
- Download a CSV with Sample data.
- CSVs should be in UTF-8 format.
Getting Started
To initiate the plugin, download, install and activate.
From the WordPress admin dashboard, navigate through the WebToffee Import/Export(Pro) menu.
The plugin consists of six different sub-modules :
You can click on the above links to know about each module in detail.
Wayne Hodkinson
September 3, 2024
When we import it does not add the imported data to customers under WooCommerce 🙁
Hema
September 18, 2024
Hello Wayne,
Thanks for reaching out. We need to look into your CSV file to resolve this issue. Kindly contact customer care for further assistance.
Evan
May 23, 2024
How do you format meta:wc_last_active and meta:_last_order column in date format? Currently, when I exported a user both meta:wc_last_active and meta:_last_order are not in date format.
Hema
May 28, 2024
Hello Evan,
Thanks for reaching out. I would suggest you to refrain from opening the exported file in any spreadsheets. The spreadsheet tends to change the date format. Try doing this with a freshly exported file.
Kamil
September 26, 2023
Hi,
I imported a customer list from CSV. They are located in the “Users” tab, but they are not in Woo->Clients. Why?
Vineetha
September 28, 2023
Hi Kamil,
Thanks for reaching out! The reason why the imported users do not show up under Woocommerce > Customers is that for any user to appear in this section, (DB view wp_customer_lookup) needs to have at least one placed order. And freshly imported users have 0 order. So once an imported user places their first order, this view will be populated and the users will show up under Woocommerce > Customers.
To display the imported users under the Customer section. Navigate to Analytics > Settings from your WordPress dashboard and click the Start button. This action will list the customers under WooCommerce > Customers.
Site Owner
March 31, 2022
After installing a plugin, I cannot find it in the plugin list. How can I disable a plug-in and uninstall it?
Alan
April 20, 2022
Hi,
Please ensure mbstring is enabled on the server and you have followed the installation and activation steps correctly.
On successful installation, you can view the plugin listed in the Installed plugin’s page, from where you can activate the plugin as shown.
For uninstalling the plugin, navigate to the Installed plugin’s page, then deactivate and delete the plugin as shown.
DItte
October 26, 2021
Hallo – how do I fix this?
An unknown error has occurred! Refer to our troubleshooting guide for assistance.
I only installed the plug-in?
Mark
October 29, 2021
Hi,
Please reach us via support and share your fatal error log.
MakeOnlineShop
February 28, 2017
Hello,
I only have a list of emails in a text file, 1 email on each line, how can I import it with your plugin ?
Thank you.
Anindo
February 28, 2017
You can just use one column user_email in CSV to import users with this plugin.
If you want to assign any roles, you can use one more column roles , there you can put customer for Customer user
Only user_email column is mandatory for creating user.
Hope that helps!