Plugins we love – Order Export & Order Import for WooCommerce

Sometimes, usually during a migration, you might find WooCommerce orders are placed on the old site location during propagation, and as a result will not exist on the migrated site.

WebToffee offer a really useful and easy to use plugin that you can use to sync them across.

Step 1. Access the old website

Depending on how you have migrated the website, you might need to update your hosts file to load the site at its original location. If you’re unsure how to do this, you can use our guide here.

You might be changing URLs so in some cases the original website might still be accessible; if you’re unsure then your old host should be able to advise on how to get logged back in.

Step 2. Login to WordPress and install ‘Order Export & Order Import for WooCommerce’

You can find this plugin by logging in to the WordPress admin area, and then click on the plugin menu and ‘add new’. You can search for it by typing in the developer ‘WebToffee’:

Step 3. Export the orders

The plugin will have added two options to the ‘WooCommerce’ menu in WordPress, these are ‘Order Im-Ex’ and ‘Coupon Im-Ex’ so you can also import and export coupons if needed.

If you click on ‘Order Im-Ex’ you will go to a new page with some import and export options, you want to use the following export menu:

This will export the orders to a CSV file and download it to your computer.

Step 4. Uninstall the plugin on the original host, and install the plugin on your new hosting.

Repeat the instructions in step 2 to install the plugin on your new hosting account.

Importantly, it is a good idea to take a database backup before running the import.

Step 5. Import the orders.

Click on WooCommerce > ‘Order Im-Ex’ again and go to the import menu. Leave ‘Update order if it exists’ deselected, unless you have updated any existing orders to be shipped on the original site. Press the ‘Import Orders’ button and it should go to a new page where it provides a feed of the missing orders being imported.

The import shouldn’t replace any orders, only import the missing ones.

When the import has completed, check over your orders and make sure everything looks copied across. The plugin also offers import and export options for products and coupons.

We love this plugin because it is easy to use, and seems to copy orders across with great accuracy even without upgrading to the premium version. If you’ve ever needed a plugin like this, we suggest giving ‘Order Export & Order Import for WooCommerce’ a look.

For more WordPress plugin recommendations, see our WordPress plugins we love collection.