Migrate WooCommerce data with CSV Importer

Publish Date - October 13, 2021
Author by Smackcoders

Blog
Migrate WooCommerce data with CSV Importer

The invention of the WooCommerce plugin helps online merchants to build a powerful eCommerce store. WooCommerce is the easiest-to-use, full-featured, customizable, and open-source eCommerce plugin for WordPress that helps entrepreneurs to sell products to anyone across the world. It is used by 4,414,537 live websites and downloaded 30,000 times at least each day from wordpress.org. The use of this plugin is still increasing. Its free version active installation is 5+ million. If you are a user already, you may know the worth and advantages of using WooCommerce.

When comparing WooCommerce with its competitors, it is most likely chosen by the people. 6.32% of the top 1 million sites using WooCommerce. WooCommerce is the most popular plugin on the internet and it is the second fast-growing Content Management System.

Many start to migrate from another eCommerce plugin like Magento, Shopify to WooCommerce. But, If you want to migrate old WooCommerce site data to a new WooCommerce site. You’re in the right place. Keep reading.

WP Ultimate CSV Importer plugin eases this process and lets you export and import data to the WooCommerce site.

Why migrate your data to WooCommerce

There may be many reasons to migrate to the new WooCommerce store. The common reasons are:

Mostly are changing hosting plans or switching to a new hosting provider. The business grows gradually and will need more space than the current plan or provider offers. So in this case the migration happens. Switching to a new hosting provider may be due to improved security, better control, and access, need more space, etc., When you switch to a new host you may feel some difficulty in migrating your existing bulk content. With WordPress importer and exporter plugins, you can export all the existing data from the WooCommerce site as CSV or XML files, and import them to a new site.

WordPress plugins for WooCommerce data migration

There are many WooCommerce data import and export plugins available in the market. Here we have picked the best in them.

1. WP Ultimate CSV Importer

WP Ultimate CSV Importer is a data importer and exporter plugin. You can import data to WordPress in some minutes. It has an in-built drag and drop mapping which helps to import data to the exact WordPress field location. The plugin supports uploading file types like .csv, .xml, .txt, & .zip files. You can import WordPress Posts, Pages, Custom Posts, Users, WooCommerce Products, WooCommerce Product Bundles plugin, AIOSEO, RankMath data import, and more. This free plugin has two additional addons which are Import WooCommerce and Export WordPress Data with Additional filters. You need to install these plugins to import and export WooCommerce data. With the Import WooCommerce plugin, you can import WooCommerce Products, WooCommerce Product Add-ons, WooCommerce Chained Products, WooCommerce Retailers, WooCommerce Returns and Warranty Request, WooCommerce Pre-Order, and WooCommerce Custom Attributes. With the free exporter plugin, you can export WooCommerce products data. If you want more features to export and import, you can buy our Pro plugin here.

2. Product Import Export for WooCommerce

This plugin can both import and export WooCommerce Products(WooCommerce simple, grouped, and external/affiliate products). It only supports CSV file import. You can import and export:

To import other WooCommerce data, you need to install separate plugins. Install the Order Export & Order Import for WooCommerce plugin to export and import Orders, Coupons, and Subscriptions. To export and import WooCommerce customers and WordPress Users, install this Import Export WordPress Users and WooCommerce Customers plugin. For importing and exporting Product Reviews, you can install this Product Reviews Import Export for WooCommerce.

3. WP All Import

WP All Import plugin imports CSV and XML files data to WordPress. It lets you import Posts, Pages, WooCommerce Products, Orders, Coupons, Users, Refunds, and more to WordPress & WooCommerce sites. To export data, you need to install a WP All Export plugin. Import Products from any XML or CSV to WooCommerce plugin eases your bulk products data import from any CSV or XML to WooCommerce. You can use this plugin for your WooCommerce products import. If you want more features you can upgrade to its pro version.

4. WP Import Export Lite

WordPress Import Export plugin lets you quickly and easily import and export WordPress site data. It supports exporting data in multiple file formats. You can then import that file to your WordPress site. You can export and import your Posts, Pages, Custom Post Types, Taxonomies, Comments, and Users. The main features of the plugin are:

It offers freemium addons. For WooCommerce import & export, you need to buy this Woo Import Export.

5. WooCommerce CSV Import Export Plugin

This is a premium plugin, especially for WooCommerce data import & export. You can quickly import or export WooCommerce Products, Categories, Customers, and Orders data in bulk. You can export data in CSV file format. It offers filters to export specific types of data. WooCommerce Coupons, Product Reviews import, and export are possible with this plugin. To do faster import and export, you can use PHP Excel Library.

Why choose CSV Importer plugin for WooCommerce migration

WP Ultimate CSV Importer plugin simplifies your WooCommerce data migration process. It offers so many features to perform safe and fast data migration. You can both export and import data to WordPress & WooCommerce. You can also automate your import and export using the schedule option. It also helps you quickly update existing WordPress site data. Here are some of the highlighted features of the plugin:

How to migrate WooCommerce data with WP Ultimate CSV Importer

With WP Ultimate CSV, XML Importer plugin you can bulk export all data as CSV/XML from your old WooCommerce site and import them to your new website. Below we explained how to export and import CSV/XML data from and to WooCommerce site.

Export or backup old WooCommerce site data

To export data, you need to install the plugin. You can download the plugin here for free. If you need more features you can buy the plugin from here. Once installed, move to the Export tab. WP Ultimate CSV Importer lets you export all data of a specific post type. Choose the post type you need to export. You can export WooCommerce data like WooCommerce Products, Orders, Coupons, Refunds, and Variations. Select the items you want to export.

You can export your WooCommerce data in either of the file formats like CSV, XLS, XML, or JSON. Provide a name for the file to export. If you have bulk records you can split the records and export them. WP Ultimate CSV Importer provides advanced filter options to export particular categories of data. You can also schedule exports from there. If you want to export promptly, then just click ‘Export’.

Try our demo for data exporting with WP Ultimate CSV Importer here.

Easy Import WooCommerce data into the new site

After you export the data from your old website you can import them into your new site. Just follow four easy importing steps and get your data inside your new WooCommerce store.

WP Ultimate CSV Importer has four simple import steps:

1. Upload CSV/XML and choose a post type

Initially, locate the ‘import/update’ tab of the plugin and upload the CSV/XML file exported from the old WooCommerce site. You can import CSV/XML from locations like desktop, FTP/SFTP, upload from external URLs and server. Once you have uploaded, select the post type. If you want to import WooCommerce products, then choose ‘WooCommerce products’ from the drop-down. Make sure you have installed and activated the WooCommerce plugin on your new website. Then Continue to the next step.

2. Map CSV headers with WP fields

Now you need to map the CSV headers for the WordPress fields. The plugin maps the fields automatically if both have the same header. Otherwise, you can select the appropriate field from the dropdown. You can use Drag ‘n’ Drop mapping to do quick field mapping. Make sure to map all WooCommerce fields. Based on your mapping all data of the fields get imported. To continue next, give a name for the mapping inside the ‘Save this mapping as’ text area to save it as a mapping template. You can use this mapping template later if you import new data.

3. Configure Media Handling

Enable media handling feature if you import any external URL images into WordPress. This section is specially made to handle images importing into WordPress. You can overwrite existing images to avoid duplicate image creation. You can download external images to WP media. You can configure the image sizes and here you can map the media SEO fields if you have mentioned in your CSV/XML file.

4. Configure data importing

To ensure safe importing you can enable the rollback and maintenance mode options. If you enable maintenance mode, it will notify your website visitors that your site is in maintenance mode. You can handle duplicate records here by enabling the ‘Do you want to handle the duplicate on existing records?’ and select one field. It handles duplicates based on that field. For instance, I select ‘Id’ from the dropdown. If I have the same two post IDs in my CSV file, the importer will skip the second record which has the same ID, and imports the first record. You can enable schedule options here. To import instantly, just click the ‘Import’ button.

How to Schedule your import & export

Scheduling your data import, export process is easy with WP Ultimate CSV/XML Importer plugin. It gives you comfort doing data export and import to WooCommerce. Below you can know how to schedule import and export separately.

Schedule your import

You can configure the scheduling option in the ‘Import Configuration section’. You will find this section after Media Handling. In the Import configuration section, enable the ‘Do you want to Schedule this Import ?’ option. Then provide the schedule data, frequency, time zone, and schedule time. Once you give, click on the ‘Schedule’ button. Now your import is scheduled and data will get imported at the specified time.

Schedule your data export

After you choose the data type you want to export, on the next page enable the ‘Do you want to Schedule this Export?’ option. Like you configure schedule import, provide here the schedule date, frequency, time zone, and schedule time. Here you can configure FTP/SFTP hosts by providing the details like Hostname, Host port, Host Username, Host Password, Host Path, and Connection Type. If you do so, then the file backup of the selected module will be stored at the mentioned Host location.

Try our demo here for data import with WP Ultimate CSV Importer. You can download sample CSV and sample XML files here.

Wrap Up

This is how you export and import data from and to the WooCommerce site with WP Ultimate CSV Importer. Try it now and successfully import data to your new WooCommerce store. If you have any queries, please drop a mail at [email protected].