https:\/\/docs.google.com\/spreadsheets\/d\/1S4RMJPXqaoBz3oB_UrWAwtN4CDgYQX3lW7aqf-LRWvg\/edit?usp=sharing<\/a>.<\/p>\n\n\n\nIf you look inside this file, you will see that it contain 5 customer records consisting of 24 columns. We\u2019re only showing the first 8 columns here:<\/p>\n\n\n\nTo start the import, go to All Import > New Import<\/strong>. This will open the New Import<\/strong> screen:<\/p>\n\n\n\n\nClick Download a file.<\/strong><\/li>\n\n\n\nSelect From URL.<\/strong><\/li>\n\n\n\nEnter the link for the sample Google Docs spreadsheet.<\/li>\n\n\n\n Click the Download<\/strong> button.<\/li>\n\n\n\nClick New Items.<\/strong><\/li>\n\n\n\nSelect WooCommerce Customers<\/strong> in the Create new<\/strong> selection box.<\/li>\n\n\n\nClick the blue Continue to Step 2<\/strong> button at the bottom.<\/li>\n<\/ol>\n\n\n\nReview the Import File<\/h2>\n\n\n\n The Review Import File<\/strong> screen lets you verify that WP All Import has parsed the import file correctly:<\/p>\n\n\n\nAs you can see, WP All Import has detected 5 records, as expected, and if you browse the record contents, you will see that they match the contents of the import file.<\/p>\n\n\n\n
Because everything looks as expected, click the Continue to Step 3<\/strong> button.<\/p>\n\n\n\nDrag-and-drop Import Data into WooCommerce Customer Fields<\/h2>\n\n\n\n In this step, we\u2019ll map the data from our import file to the WooCommerce fields in the import template. Thanks to the drag and drop system, you don\u2019t have to manually edit your file so that every column has the correct name and order – instead, just drag the columns from the right into the appropriate fields on the left.<\/p>\n\n\n\n
Here\u2019s a look at the mapping process for just the Customer Account Info<\/strong> section. Note that we haven\u2019t drawn all the red drag & drop paths because it would get too messy. But, as you can see, in addition to the First Name<\/strong> and Last Name<\/strong> mappings, the incoming email value gets mapped to the customer Email<\/strong> field, the incoming username value gets mapped to the Username<\/strong> field, and the incoming password value gets mapped to the Password<\/strong> field.<\/p>\n\n\n\nWP All Import\u2019s drag-and-drop mapping makes it easy to import data from files with different layouts. If you\u2019re importing data from an external source where the columns don\u2019t match WooCommerce\u2019s format, you can still map the fields to fit WooCommerce\u2019s requirements.<\/p>\n\n\n\n
Let’s say you have a CSV file with columns labeled \u201cFirst_Name\u201d and \u201cLast_Name,\u201d but WooCommerce uses \u201cBilling First Name\u201d and \u201cBilling Last Name.\u201d WP All Import allows you to drag \u201cFirst_Name\u201d to the Billing First Name field in WooCommerce, so your import goes smoothly without needing to modify the original file.<\/p>\n\n\n\n
Note that the incoming password value is a hashed value, so we indicate this to WP All Import by checking the This is a hash password from another WordPress site<\/strong> option. We\u2019ll explain more about hashed passwords shortly.<\/p>\n\n\n\nJust as we mapped the name, email, and password values to the fields in the Customer Account Info<\/strong> section, we will also map all the incoming billing and shipping address values to the fields in the Billing & Shipping Info<\/strong> section.<\/p>\n\n\n\nWhen this mapping is complete, click the blue Continue to Step 4<\/strong> button.<\/p>\n\n\n\nWooCommerce Customer Import Settings<\/h2>\n\n\n\n The Import Settings<\/strong> screen allows you to control exactly what WP All Import does with the data mapped in the Drag & Drop<\/strong> interface. Here are the relevant settings in the top two sections of this page:<\/p>\n\n\n\n\nUnique Identifier<\/strong>. This identifier must be unique for each customer, including all the customers already in your WooCommerce database. In the example image above, we\u2019re using the incoming username value. However, this may not be sufficient. For example, what if an existing customer already has the same user name as one of the incoming customers? There are many ways to deal with this. In this simple scenario, we\u2019ll just assume that there are no conflicts with existing customer user names.\n\nA unique identifier is a special field\u2014such as username or email\u2014that WooCommerce uses to tell customers apart. During imports, it\u2019s essential to make sure there are no conflicts, especially with usernames, which need to be unique across the store.<\/li>\n\n\n\n If you\u2019re merging customer lists from two stores, use a unique identifier like the customer\u2019s email address to prevent importing duplicate usernames. WP All Import can match based on this field, so existing customers aren\u2019t duplicated, and each customer is identified correctly in the new system.<\/li>\n<\/ul>\n<\/li>\n\n\n\n Create new customers from records newly present in your file<\/strong>. If checked, WP All Import will create a new customer for every incoming customer whose unique identifier is not already present in the existing WooCommerce customer data.<\/li>\n\n\n\nNote that the Update existing customers with changed data in your file<\/strong> option is NOT checked. This means that we will not try to deal with updating existing customers. If this option were checked, it would open up a large number of options that would allow us to deal with update issues on a field-by-field basis. But as we\u2019re trying to keep this tutorial simple, we\u2019ll skip this option for now.<\/li>\n\n\n\nBlock email notifications during import. Normally, if you update a WooCommerce customer, WordPress will email the customer by default. This setting allows you to avoid these updates when importing customer data.<\/li>\n<\/ol>\n\n\n\nIgnore the Scheduling Options<\/strong> and Configure Advanced Settings<\/strong> sections of this page for now. We\u2019ll return to these subjects shortly.<\/p>\n\n\n\nClick the blue Continue<\/strong> button at the bottom of the screen.<\/p>\n\n\n\nRun the WooCommerce Customer Import<\/h2>\n\n\n\n The next screen is the Confirm & Run<\/strong> page. On this page, click the green Confirm & Run Import<\/strong> button.<\/p>\n\n\n\nWhen the import is complete, you should see a confirmation screen that looks similar to this:<\/p>\n\n\n\nThis screen should indicate that your five customers were imported. If you attempt to create an order in WooCommerce, you will find that you can now use these customers in the order entry process.<\/p>\n\n\n\n
That\u2019s it \u2014 you\u2019ve just completed the basic process of how to import WooCommerce customers with WP All Import.<\/p>\n\n\n\n
Advanced Features in WP All Import<\/h2>\n\n\n\n In the preceding sections, we skipped over a few of the advanced features of WP All Import for importing customers. In this section, we briefly describe some of those features.<\/p>\n\n\n\n
Filtering Import Data<\/h3>\n\n\n\n Back in the Review Import File<\/strong> screen (Step 2), there was a section at the bottom of the screen called Add Filtering Options<\/strong>. This filter works in a similar manner to the filtering process shown earlier for WooCommerce customer exports. The main difference is that you are filtering incoming data instead of existing WooCommerce customer data.<\/p>\n\n\n\nHandling Hashed Passwords<\/h3>\n\n\n\n As mentioned, incoming password information is often hashed.<\/p>\n\n\n\n
Hashing is a one-way action that irreversibly scrambles a string of text. It is not possible to reverse the hashing process to identify the original password. However, if the hashed password values are coming from another WordPress website, then your WordPress site will understand them so that customers will be able to log into your store using their old passwords.<\/p>\n\n\n\n
Mapping Custom Fields<\/h3>\n\n\n\n If any incoming customer information belongs in a custom field on your website, you will be able to map them to your system in the Custom Fields<\/strong> section of the import\u2019s Drag & Drop<\/strong> screen. This is one of the great benefits of using WP All Import, as it can identify and populate custom fields or fields from any plugin or add-on.<\/p>\n\n\n\nFunction Editor<\/h3>\n\n\n\n If you need to manipulate the incoming customer information in any way during the import process, you can create PHP functions to assist in this manipulation.<\/p>\n\n\n\n
Scheduling Imports<\/h3>\n\n\n\n If you need to run a customer import process on a schedule, you can do so through the Scheduling Options<\/strong> section of the Import Settings<\/strong> page. This is particularly useful if you need to keep your WooCommerce customer data synchronized with an external system. In this model, the external system can output a new customer import file on, say, a weekly basis. As long as the external system drops this file in an agreed-upon location, WP All Import can automatically import it by following a compatible schedule.<\/p>\n\n\n\nScheduling is helpful for stores that frequently update customer data, allowing you to sync information automatically at regular intervals. This feature helps keep WooCommerce data aligned with external sources, like CRMs or mailing lists.<\/p>\n\n\n\n
If you\u2019re running a WooCommerce store that regularly updates customer lists from a mailing system, you can set WP All Import to check for new customer files every day. This daily sync ensures your customer records are always up to date without needing to import manually each time.<\/p>\n\n\n\n
Advanced Settings<\/h3>\n\n\n\n Importing an especially large customer file? No problem. WP All Import provides a Configure Advanced Settings<\/strong> section on the Import Settings<\/strong> page. These settings allow you to break imports up into more manageable processing chunks, and also to increase import processing speed by disabling certain functions, importing only specified records, or using a StreamReaders instead of an XMLReader to parse the import data.<\/p>\n\n\n\nWooCommerce Store Migrations<\/h2>\n\n\n\n WooCommerce is one of the most widely used e\u2011commerce platforms in the world<\/strong>, powering over\u00a05<\/strong>.3 million active online stores<\/strong>\u00a0and holding a\u00a028.19% market share<\/strong><\/a>\u00a0of all online stores.<\/p>\n\n\n\nJust as we\u2019ve described using WP All Export and WP All Import for exporting\/importing WooCommerce customer data, you can also use these plugins to handle complete store migrations.<\/p>\n\n\n\n
Why choose WP All Export\/Import over a dedicated migration plugin? Because these two plugins not only handle all the typical store data (customers, products, orders, etc.), but also the data for all add-ons\/extensions, too, including all settings and SEO information. And if you need to intervene in any portion of the migration process, you can do so using the convenient drag & drop functionality.<\/p>\n\n\n\n
FAQ<\/h2>\n\n\n\nCan I Export Woocommerce Customers Without a Plugin?<\/strong><\/h4>\n\n\n\nWooCommerce doesn\u2019t have a built-in feature to export customers directly.<\/p>\n\n\n\n
Are Customer Passwords Transferred Securely?<\/strong><\/h4>\n\n\n\nYes, customer passwords are transferred as secure, hashed values. This means that while the passwords themselves can\u2019t be read, customers can still log in with their existing credentials if you import the hashed passwords into another WooCommerce site. This approach ensures security while maintaining a smooth experience for your customers.<\/p>\n\n\n\n
Is Wp All Import Compatible With Custom Fields?<\/strong><\/h4>\n\n\n\nAbsolutely! WP All Import\u2019s drag-and-drop interface allows you to map custom fields easily. This means you can import data into any custom fields you\u2019ve created or that exist through WooCommerce extensions. This flexibility is especially useful if you need to transfer unique customer data or information tied to plugins.<\/p>\n\n\n\n
Can I Schedule Automated Imports and Exports?<\/strong><\/h4>\n\n\n\nYes, both WP All Import and WP All Export allow you to set up scheduled imports and exports.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n As you can see, WP All Export and WP All Import make it easy to export and import WordCommerce Customers. Give it a try with the steps outlined in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"
WooCommerce is the most popular eCommerce platform on the planet. Unfortunately, it doesn\u2019t have the built-in capacity to export or import customers. Why is this important? There are three main reasons why you might need to export your WooCommerce customers: Likewise, you might need to import new customers from a marketing campaign or a store […]<\/p>\n","protected":false},"author":1,"featured_media":3845,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[23],"tags":[26,25,65,64,66],"class_list":["post-3754","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","tag-export","tag-import","tag-users","tag-woocommerce","tag-wpallimport"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"acf":[],"_links":{"self":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/posts\/3754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/comments?post=3754"}],"version-history":[{"count":5,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/posts\/3754\/revisions"}],"predecessor-version":[{"id":13992,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/posts\/3754\/revisions\/13992"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/media\/3845"}],"wp:attachment":[{"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/media?parent=3754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/categories?post=3754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativethemes.com\/blocksy\/wp-json\/wp\/v2\/tags?post=3754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}