Order Export & Order Import for WooCommerce

Description

Introduction – Order/Coupon Export Import Plugin

Order Export Import Plugin for WooCommerce is a perfect tool for migrating order data seamlessly from one WooCommerce store to another while allowing you to maintain your order history including subscription orders (available in premium). Using the WooCommerce order export plugin you can also migrate an existing shop on a different eCommerce platform to WooCommerce.

The plugin will also allow you to migrate thousands of coupons from your old eCommerce platform or campaigns.

The following are functionalities offered by the basic version of the plugin.

🔸 Export orders to CSV.
🔸 Import orders from CSV to WooCommerce.
🔸 Export coupons to CSV.
🔸 Import coupons from CSV to WooCommerce.
🔸 Bulk update WooCommerce orders and coupons.
🔸 Supports various export filters (order status, product, coupon, customer, date range)
🔸 Export Subscription orders to a CSV file(Premium Feature).
🔸 Import Subscription orders from a CSV file(Premium Feature).
🔸 Tested OK with WooCommerce 5.7
🔸 Tested OK with WP 5.8
🔸 Tested OK with PHP 8.0

Additional features that will help you in the CSV export and import process:

🔸 Import and Export WooCommerce orders & coupons in batches
🔸 Create a pre-saved template for quick and easy export of orders and coupons
🔸 Mapping and re-ordering of export columns
🔸 Export orders starting after an offset value
🔸 Skip or update existing orders/coupons while importing.
🔸 Create and maintain import and export history with options to re-run, view logs, and delete an entry
🔸 Log of the import and export will help in identifying what went wrong for debugging purposes.

More information about the setup of the plugin and a sample CSV that is taken as input by the plugin are given in the free order export import plugin setup guide.

Compatible plugins

Order Export & Order Import for WooCommerce Premium Version Features

✅ Export WooCommerce Orders to CSV file.
✅ Import WooCommerce Orders from CSV file.
✅ Export Subscription Orders to CSV file.
✅ Import Subscription Orders from CSV file.
✅ Import Coupons from CSV file.
✅ Export Coupons to CSV file.
✅ Importing order meta to WooCommerce.
✅ Export Filters(Order Status, Product, Coupon Type, Customer etc)
✅ Change values while import using Evaluation Field feature.
Support for third-party plugins.
✅ Column Mapping Feature to Import from any CSV format.
✅ Import and Export via FTP.
✅ Schedule automatic import using Cron Job Feature.
✅ Scheduled export using Cron Job Feature.
✅ Import WooCommerce Orders from XML.
✅ Export WooCommerce Orders to XML.
✅ Excellent Support for setting it up!

For complete list of features and details, Please visit Order Export Import Plugin for WooCommerce for more details

Note: Please note that the below section applies to our free version and premium version. While the flow is the same, some of the features are only available in the premium version.

How to export orders from WooCommerce?

The Order Export & Order Import for WooCommerce Plugin’s simple interface makes it extremely easy to map the data in your CSV file to the appropriate fields in WooCommerce. The plugin supports Custom Fields, dates, and pretty much every other WooCommerce Order / WooCommerce Subscription / WooCommerce Coupon field.

Our order export plugin helps you to export WooCommerce bulk order data in XML format prescribed by other Service Providers. Using exported XML, you can import the orders to the Service Provider. It also provides an option to export XML using WooCommerce format, using which you will be able to import the orders to another WooCommerce website.

WooCommerce Export Orders

To Export WooCommerce Orders to CSV just click the Export Orders button from the plugin page. You can select the order or subscription statuses and coupon types that you want to export. Configure other settings and select the columns you want to export.

How to import orders to WooCommerce?

The Order Export & Order Import for WooCommerce Plugin’s simple interface makes it extremely easy to map the data in your CSV file to the appropriate fields in WooCommerce. The plugin supports Custom Fields, dates, and pretty much every other WooCommerce Order / WooCommerce Subscription / WooCommerce Coupon field.

Our Plugin is designed to be efficient with large imports as it splits large import files into smaller chunks, making it possible to import large files with thousands of data and records, even on slow hosting providers.

WooCommerce Import Orders

To Import WooCommerce Orders by uploading CSV, use the Import Orders button from the plugin page. The columns of your CSV may not always correspond with the WooCommerce order data fields. In such a case, you will have to manually provide a mapping and then save the mapping settings for later imports.

Please refer to the order export import plugin documentation for more detailed help.

Highlights: Simply Export Orders, Customer Order CSV Export, Export Orders to Excel, Export Coupons, Import Coupons, Export Subscriptions, Import Subscriptions. Best WooCommerce Order Export Plugin in Market.

Other useful plugins from WebToffee for migrating WooCommerce data:

Sequential Order Number for WooCommerce: Easily manage orders with all the order numbers sorted sequentially.

Product Import Export for WooCommerce: This free plugin will help you import and export products from your store using a CSV file.

Import Export WordPress Users: Import and export the users in your WordPress store using a CSV file with the help of this plugin.

WordPress Backup & Migration: Quickly migrate and backup entire WordPress site or selected files from one location to another. Backup to FTP, Google drive, Amazon S3 or local storage and easily restore them back.

About WebToffee.com

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

Screenshots

  • Order export filter options

  • Order export advanced options

  • Order import advanced options

  • Order quick import completed

  • Order advanced import completed

  • Exported order CSV

  • Debug logs

  • Import-export history

  • Coupon export filters

  • Coupon advanced export

  • Coupon advanced import options

  • Coupon quick import completed

  • Coupon advanced import completed

  • Exported coupon CSV

Installation

Pre-requisites

🔸 PHP Version:
🔸 WooCommerce version:
🔸 WordPress version:

Automatic Installation

The automatic installation of the plugin is the easiest way to install the plugin. You can install the plugin without even leaving your browser window and from within your WordPress dashboard.

From your admin dashboard, go to Plugins > Add New. From the search box, type “WooCommerce order import” or “WooCommerce order export” and then search plugins. Click the install button on the Order Import Export Plugin for WooCommerce by WebToffee and then activate the plugin.

Now you are ready to start importing and exporting orders and coupons to and from your store.

Manual Installation

In the manual installation, you will need to download the zip file of the plugin from the plugin page in WordPress.org. You can upload the file directly from your WordPress dashboard, or using an FTP application.

Plugin Updates

For every update of the plugin, you will be notified of the installed plugins page. You can directly update the plugin from your dashboard. We recommend that you keep the latest version of the plugin so that you can avail of the new functionalities and security features.

FAQ

Does this plugin export order line item details?

Yes. You can import order line items or export order line items details.

Can I update existing orders using this plugin?

Yes, you can update the existing order details while importing.

Can I create mass orders using this plugin?

Yes, you can create mass orders while importing using a CSV file. Create a CSV for this purpose with order details without specifying the order ID. This will create new orders in the store the file is imported to.

Error caused because of the same order IDs on the target website

If you are migrating the orders from one site to another site and if the order ID is already used on the target site for other posts, then the orders will be imported with a new order number. You can resolve this issue by deleting the entries in the order ID column of the CSV.
If you need to retain the order numbers, you can overcome this issue with the help of our Sequential order number plugin.

Does this plugin import/export custom fields?

No, this feature is only supported by the premium version of the WooCommerce order export import plugin.

Are the order IDs retained in an import/export?

Yes, the order IDs will be retained unless there is another post type or order of the same ID already present in the website the CSV is imported to.

Issue importing orders due to invalid date format?

To import orders in dd/mm/yy date format, you can use the {order_date@d/m/Y} expression in the mapping field for order date.

Does this plugin import orders to an XML file?

No, this is a premium feature.

Does this plugin support multisite?

Yes.

Should the CSV be UTF-8 encoded?

Yes.

Reviews

སྤྱི་ཟླ་བཅུ་པ། 18, 2021
Used it only once for migration of a website. Worked flawlessly, great stuff!
སྤྱི་ཟླ་བཅུ་པ། 4, 2021
We had a user who somehow found her way to our (out of date and unused) staging site and placed her order there. This plugin worked exactly as we needed it to, to export the orders from staging and import to live. It even has a way to deal with a duplicate order ID (just un-map the order ID on import)
སྤྱི་ཟླ་དགུ་པ། 20, 2021
Pretty robust solution packed into a simple step-by-step process for importing and exporting data from WooCommerce. I've been using the solution for several months and it fits perfectly with the requirements needed for exporting data for our CPA. Thank you.
སྤྱི་ཟླ་དགུ་པ། 20, 2021
In moving my store from one store to another--on two different themes--I feared a mess when I moved the data. But this went very smoothly.
སྤྱི་ཟླ་དགུ་པ། 8, 2021
Very useful and easy to use plugin. Helps me a lot with exporting and importing data!
Read all 177 reviews

Contributors & Developers

“Order Export & Order Import for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

2.1.1

  • WC 5.7 tested OK

2.1.0

  • Fix:- WC compatibility with shipping phone number

2.0.9

  • Added support for shipping phone number import export
  • Added import export compatibility for WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels plugin by WebToffee
  • Added import export compatibility for Sequential Order Number for WooCommerce plugin by WebToffee
  • WC 5.6 tested OK

2.0.8

  • Fixed: Grant download permission issue on import
  • Fixed: Trash orders getting exported with coupon filter applied
  • WC 5.5 tested OK
  • WP 5.8 tested OK

2.0.7

  • Fixed: Paid date import

2.0.6

  • Fixed: Mail sending with order status transition on import

2.0.5

  • Fixed: Payment date update
  • Fixed: Mail sending with on-hold status on import

2.0.4

  • Text corrections and batch count defaulted to 10

2.0.3

  • Menu access capability update

2.0.2

  • WC latest tested OK and speed optimization.

2.0.1

  • Tested OK with PHP 8.0
  • Option to connect products using SKU when importing orders

2.0.0

  • Improved UI for better user experience
  • Export/Import options: via a pre-saved template or a quick(standard columns) export/import
  • Option to export/import selective columns
  • Option to reorder columns during export
  • Import: Support for different types of delimiters
  • Export/Import options: Batch option with configurable batch count
  • History of all the Import/Export process
  • Dedicated logs for debugging failures

1.7.6

  • Tested OK with WC 5.2.2

1.7.5

  • Tested OK with WC 5.2.0

1.7.4

  • Tested OK with WC 5.1 and WP 5.7

1.7.3

  • Tested OK with WC 4.9.2

1.7.2

  • Tested OK with WC 4.7.1 and WP 5.6
  • New filter options added in order export.

1.7.1

  • Tested OK with WC 4.7.0 and WP 5.5.3

1.7.0

  • Tested OK with WC 4.6.0

1.6.9

  • [Improvement] Coupons expiry date import and export.

1.6.8

  • Tested OK with WC 4.5.2
  • [Improvement] import date format.

1.6.7

  • Bug Fix:- Access denied message when importing orders.
  • Tested OK with WC 4.5.0 and WP 5.5.1

1.6.6

  • [Improvement] import date format.
  • Tested OK with WC 4.2.0 and WP 5.4.2

1.6.5

  • [Improvement] line item tax import and export.
  • Tested OK with WC 4.1.0 and WP 5.4.1

1.6.4

  • Bug Fix:- Problem with activating plugin in multisite.

1.6.3

  • Tested OK with WP 5.4

1.6.2

  • Bug Fix:- Paid date and Completed date not importing.
  • Tested OK with WC 4.0.0

1.6.1

  • [Improvement] Security

1.6.0

  • Bug Fix:- Delete uploaded CSV temp file after import.

1.5.9

  • Tested OK with WC 3.9.2

1.5.8

  • Bug Fix:-Coupon usage count.
  • Tested OK with WC 3.9.1

1.5.7

  • Bug Fix:-Shipping tax not importing.
  • Tested OK with WP 5.3.2

1.5.6

  • provision to export for Super Admin users.
  • Tested OK with WP 5.3 and WC 3.8.1

1.5.5

  • Tested OK with WP 5.2.4 and WC 3.8

1.5.4

  • WC 3.7.1 Tested OK.

1.5.3

  • Bug fix:Error on fetching Refund amount.

1.5.2

  • WP 5.2.3 Tested OK.
  • Bug fix:’Cannot insert order without order status’.
  • Bug fix:Order note comment_author not export and import.

1.5.1

  • WC 3.7.0 Tested OK.
  • update information hook added.

1.5.0

  • Tweak: Status field made mandatory to import new orders.
  • WC 3.6.5 Tested OK.

1.4.9

  • Bug fix: Refund,Coupon,Fee Items export import.

1.4.8

  • Tested OK with WP 5.2.2 and WC 3.6.4
  • Bug fix: Orders getting imported to new IDs when import ID conflicts with existing post IDs.
  • Issue with using the plugin in multi-site setup.
  • Help tab modification.

1.4.7

  • Tested OK with WP 5.2.1 and WC 3.6.3
  • Bug Fix:- Order fields getting blank on updating when the fields are not present in CSV.
  • Coupon import optimisation.

1.4.6

  • Tested OK with WP 5.2
  • Bug Fix:- Issue with Coupon Expiry Date export and import.

1.4.5

  • Tested OK with WC 3.6.2
  • New Feature:- Filters added in order export(offset & limit).
  • Order notes optimisation.
  • Compatibility with PHP 7.3.5

1.4.4

  • Tested OK with WC 3.6.1 and WP 5.1.1.
  • Bug Fix and Improvements: Tax calculation.

1.4.3

  • Bug fix: Tax calculation.
  • WC 3.5.6 compatibility.

1.4.2

  • Bug fix.
  • WC 3.5.5 and WP5.1 compatibility.

1.4.1

  • Tools Updated.
  • Help tab added.
  • Bug fix: Import of ‘download permissions’.
  • Bug fix: 2 blank meta columns on coupon export.
  • All sample CSVs updated.
  • Order date supports formats, ‘d-m-y H:i’ & ‘Y-m-d H:i:s’.
  • WC 3.5.4 compatibility.
  • Language translation supported.

1.4.0

  • Tested OK with WC 3.5.3 and WP 5.0.3.
  • Content Update.

1.3.9

  • Tested OK with WC 3.5.2 and WP 5.0.2

1.3.8

  • WC 3.5.1 Tested OK.
  • Bug fix and Improvements.

1.3.7

  • WC 3.5.0 Tested OK.

1.3.6

  • Content Update.

1.3.5

  • WC 3.4.5 Tested OK.
  • Review link added on footer.

1.3.4

  • WC 3.4.4 Tested OK.
  • Bug fix.
  • Readme content change.

1.3.3

  • Sample CSV file updated.
  • WC 3.4.3 Tested OK.
  • Bug fix.

1.3.2

  • Bug fix.

1.3.1

  • Fixed Order currency import issue.
  • WP 4.9.5 and WC 3.3.5 Tested OK

1.3.0

  • Fixed Coupon customer import issue.
  • WP 4.9.5 and WC 3.3.4 Tested OK

1.2.9

  • Improved UI
  • Uninstall feedback

1.2.8

  • WC 3.3.3 Tested OK
  • Keeping Order ID in order import

1.2.7

  • WP 4.9.4 and WC 3.3.1 Tested OK

1.2.6

  • WP 4.9 and WC 3.2.4 Tested OK

1.2.5

  • WP4.8 , WC3.1 and PHP7 Compatibility Tested OK

1.2.4

  • Fixed some warnings.

1.2.3

  • Minor Content Change.

1.2.2

  • Minor Content Change.

1.2.1

  • Bug fix: Fixed Coupon import warnings.

1.2.0

  • Bug fix: Fixed WC Log issues.

1.1.9

  • Minor Content Change.

1.1.8

  • Compatibility with WC 3.0.3 ( fixed issue with order_date )

1.1.7

  • Compatibility with WC 2.7

1.1.6

  • Sample CSV file updated.

1.1.5

  • Plugin Icon Change.

1.1.4

  • Support Content Change.

1.1.3

  • Minor Content Change.

1.1.2

  • Optimized order line item import.

1.1.1

  • Introduced coupon export import.
  • Support for Subscription Orders export import in premium.

1.1.0

  • Security related improvements and bug fixes.

1.0.9

  • Security related improvements.

1.0.8

  • Order line items linking improvements.

1.0.7

  • Updated customer linking with order details.

1.0.6

  • CSV Parsing improvements.

1.0.5

  • Minor modification.

1.0.4

  • Shipping related fields updated in import.

1.0.3

  • German Translation file added.

1.0.2

  • Export order limit updated to unlimited.

1.0.1

  • Minor modification.

1.0.0

  • Export /Import WooCommerce Orders.