woocommerce xls import

Import WooCommerce Customers from an XLS File

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

If you have all your WooCommerce Customer details in an XLS file and you want to import the data from the XLS file to your WooCommerce store, WordPress Users and WooCommerce Customers Import Export Plugin will help you do that quickly and easily.

To import the WooCommerce customers in the XLS file using the plugin, you need to first change the XLS file into a CSV file. This can be done by saving the XLS file with the .csv file extension. Also, the CSV file should also be UTF-8 encoded for proper import. Refer to this article on how to save an XLS or XLSX file to a CSV file.

After you have saved your XLS file as a CSV file, you can now use the plugin to easily import the customer data into the WooCommerce website. What you need to do is purchase the plugins, install and activate it on the website to which the data is being imported.

Let’s take a look at how we can import the WooCommerce customers into the WooCommerce website using the plugin.

Importing WooCommerce Customers

To begin importing using WordPress Users & WooCommerce Customers Import Export Plugin, go to your WooCommerce dashboard. From the dashboard, go to WooCommerce > Customer Import Export. This will take you to the plugin page.

From the plugin page, go to the Import Users in CSV Format section.

From this section, if you wish to update the existing users in the store using the CSV file, check the Update User if exists checkbox. This will take you to the Merge Users page of the plugin.

If you leave the checkbox unchecked and click on the Import Users button, it will take you to the Step-1 of the Import page. The screen looks as shown below.

Now, based on the location where the file is saved, there are two methods with which you can import the customers to the website.

Method 1: Select a file from your computer.

In this method, you can click on the Choose File button and select the CSV file saved locally on your computer.

Method 2: Provide FTP Details

This method can be used if the CSV file you are importing is located on a remote server. You can upload the file from the server by giving the FTP details of the server.

After you have selected the CSV file with any of these methods, next click on Upload file and import. This will take you to the next step in import, mapping fields.

The mapping fields are necessary for the proper import of the customer data into the WooCommerce website. This is to ensure that the column headers of the CSV file are in sync with the WooCommerce customer data fields. The mapping should be properly done if the data that are being imported are exported from some other e-commerce platform. After the mapping, click Submit which will import all the data in the CSV file to the website.

If you need more information on how to get started with the plugin to import or export WooCommerce data, then read this article.

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Description

Introduction

Are you trying to import products into WooCommerce store or export WooCommerce products from the store. This Product import export plugin allows you to import or export WooCommerce simple products ( other pproduct types such as variable products are available only in premium version). It is super simple!

🔸 Export Simple Products in to a CSV file.
🔸 Import Simple Products in CSV format in to WooCommerce Store.
🔸 Tested OK with WooCommerce 3.5.3.

Highlights: WooCommerce Product Export, WooCommerce Product CSV Import Suite, WooCommerce bulk product upload, WooCommerce import products with images, import amazon products to WooCommerce, Export Products to xls. Pro Version supports both Simple and Variable products.

How does it work?

The WooCommerce Product Import Export Plugin takes CSV (Comma-Separated Values) file as input. You must create a CSV ( UTF-8 Encoded ) file and enter the product details in a structured format as explained in the tutorial. This is to match each field of CSV file to the field of a particular product that otherwise Admin need to input manually. For example: the post_title field gets mapped to the product name and the regular_price field gets mapped to the regular price of the product. For the plugin to work correctly, you must map headers of all of the column correctly and you must ensure that all of the fields you enter must be in the correct format.

You can create the CSV from scratch or you can export the product to get the format of CSV. You can use a spreadsheet program, such as LibreOffice , Microsoft Excel, OpenOffice or Google Spreadsheets for creating and modifying the CSV file. Save this file with extension .CSV. After entering all details about products in spreadsheet, you can import product to your online store. With this plugin, you can also export and download product details as a CSV file.

Premium version video demo

Premium version Features

Product Import Export Plugin for WooCommerce is the leading tool for Woocommerce product export and WooCommerce product import. Some of the major features are listed below

  • ✅ Export/Import simple, group, external and variation products.
  • ✅ Export products by category.
  • ✅ Import/Export product reviews..
  • ✅ Various filter options for exporting products.
  • ✅ Map and transform fields during import.
  • ✅ Manipulate/evaluate data during import.
  • ✅ Choice to Update or Skip existing imported products.
  • ✅ WPML support for simple products.
  • ✅ Import/Export file via FTP.
  • ✅ Import from URL.
  • ✅ Automatic scheduled import and export.
  • ✅ Supports product reviews export and import.
  • ✅ Third party plugin customization support.

Product Import Export Plugin for WooCommerce Premium Features

WooCommerce import products & WooCommerce export products functionalities made easy.

WooCommerce export products

There are multiple cases where one need to export WooCommerce products. It could be either for sending the details to someone else or integrating with a third-party system. For example, you can export woocommerce products as csv file in to an ftp folder on a regular basis using the cron job. This can be read by any third-party application to update its data.

Export WooCommerce Products: Export and download product data in CSV file format. Plugins supports,

WooCommerce Simple Products
WooCommerce Variable Products.
WooCommerce Grouped Products.
WooCommerce External Products.
WooCommerce Subscription Products.

In addition, the plugin helps you export Categories, Tags, Products and other Product details into WooCommerce. You can export prices, descriptions, images etc apart from the custom fields (meta), taxonomies and attributes.

How to export WooCommerce products

It is as simple as clicking a button. But if you need to customize your export we have enough advanced customization options built in to the woocommerce product export plugin.

WooCommerce Import Products

WooCommerce bulk product upload is one of the main use case where WooCommerce product import functionality is used. ‘How to import products into woocommerce’ is one of the common question people ask. Our WooCommerce product csv import suite is the perfect answer for this. With is plugin you can import products from any xml or csv to WooCommerce. This saves lot of time and minimises errors.

WooCommerce product import: You can use the import functionality to:

Import by selecting file from your computer
Import by providing file path on the server
Import from file in a remote server via FTP
Export Variable Products: Once you export variable product, you will have a simple single CSV which will have both variable and it’s parent details. It will help you to do any changes easily and enables faster import to any WooCommerce site.

WooCommerce import variable products

WooCommerce variable product import allows you to import all variations of the products easily. It imports all variable products and it’s properties from a single CSV file. This single CSV file will have both variable and parent data. WooCommerce csv import variable products is key feature of the WooCommerce product import plugin.

WooCommerce import products with images

The plugin facilitates easy import of images related to a product. When the products are imported using the plugin, the first image related to a product in the image column of the CSV file is taken as its featured image. If there are multiple images in the same column, the image(s) after the first one is taken as the gallery images of the product.

Other features

Export Products by Category: You can even choose desired product categories from the Plugin Settings Page and those Products belongs to selected categories will be exported.

Export Products by Type: You can selectively export products belonging to specific product types. All you need to do is choose the required product types from the plugin settings page while exporting.
Merge Products: This feature is useful for adding more information to existing products, for example when your existing products get modified. To get the modified product details into your online store, you can update the current product by importing modified product CSV file.

Map and Transform: You can map the fields ( WooCommerce fields ) with column headings ( CSV file header ). To map, select the required field under “Map to Column” by using drop-down list for a particular column heading. An Evaluation field is used to fix/update the required value for the particular field.

Cron Job / Scheduled Import Export: WooCommerce Product Import and Export plugin facilitates to schedule the Import and Export of the products. You can auto import the products at regular intervals from CSV which is present on FTP Server by providing starting time and intervals between import. There is an option to skip new products in scheduled import too. You can also auto export the products to FTP in a CSV file at regular intervals. There is also option to use saved mapping files for auto export.

Supports WooCommerce Product Bundles Plugin.
Supports Yoast WooCommerce SEO Plugin.
Supports WooCommerce Google Product Feed Plugin.
Supports Scheduled Cron Job.

About wbtoffee.com

WebToffee creates quality WordPress/WooCommerce plugins that are easy to use and customize. We are proud to have thousands of customers actively using our plugins across the globe.

Screenshots

WooCommerce Product Import Screen

WooCommerce Product Export Screen

Premium Export Settings Screen

  • Installation

    1. Upload the plugin folder to the /wp-content/plugins/ directory.
    2. Activate the plugin through the Plugins menu in WordPress.
    3. Thats it! you can now configure the plugin.

    Yes. You can import or export product images along with other details

    Which is the best free CSV editor suggested?

    Importing WooCommerce Products From Microsoft Excel File

    The Best Product Import Export Plugin for WooCommerce

    #1 in WordPress Official Plugin Repository With 50,000+ Active Installs

    #1 in Customer Satisfaction With Most 5 Star Reviews

    WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

    If you have product data in Microsoft Excel spreadsheet and wish to import it to your WooCommerce, our Product Import Export Plugin for WooCommerce can easily help you achieve that. Before importing, you have to save your Excel file with the .csv extension, that’s as simple as clicking Save As and selecting Comma Separated Values from the file type drop-down list.

    Let us understand this procedure with the help of the following example:

    Suppose, you have following products on your excel spreadsheet as shown in the screenshot of a sample excel spreadsheet below:

    Note: You can download a sample CSV here.

    Following are the steps to import products:

    • Navigate to WooCommerce >Product Im-Ex section of the plugin. Under Product>Import, move to Import Product in CSV Format section, as shown below:

    Import settings Choose a file from the file selection option and click Upload file and import. You can also map the fields with column headings (CSV file header), and use Evaluation field to fix/update the required value for the particular field. Finally, click Submit to import the products into your online store.

    To know more about importing products, read this article.

    Once the import is successfully we can see the products have come perfectly into the system. Here, are the product pages of simple and variation product.

    Simple Product

    In the above image, you can see the simple product – Samsung Galaxy Ace Duos is imported to WooCommerce as specified in the CSV.

    Variation Product

    In the above image, you can see the variation product – Men’s Cotton T-Shirt is imported to WooCommerce with two variations – blue and red, as specified in the CSV.

    To know more about other features of the plugin, read the documentation.

    The Best Product Import Export Plugin for WooCommerce

    #1 in WordPress Official Plugin Repository With 50,000+ Active Installs

    #1 in Customer Satisfaction With Most 5 Star Reviews

    WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

    Leave a Reply

    Your email address will not be published. Required fields are marked *