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 (export orders and import orders) 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. Coupon CSV import and coupon export are essential features if you have a store with a large number of coupons.

The following are functionalities offered by the basic version of the order import and order export plugin.

🔸 WooCommerce Export orders to CSV.
🔸 Import orders from CSV to WooCommerce.
🔸 Export coupons to CSV.
🔸 Import coupons from CSV to WooCommerce.
🔸 Supports importing selected columns from the order import CSV file.
🔸 Bulk update WooCommerce orders and coupons.
🔸 Compatible with YITH WooCommerce Order Tracking plugin.
🔸 Supports various export filters (order status, product, coupon, customer, date range) for order export to CSV.
🔸 Tested OK with WooCommerce 9.3.3
🔸 Tested OK with WordPress 6.6.2
🔸 Tested OK with PHP 8.3

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

🔸 Import and Export WooCommerce orders in batches
🔸 Import coupons from CSV and Export coupons to CSV
🔸 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.
🔸 Auto-suggestion of coupon codes making coupon-based filtering easier.
🔸 Export Subscription orders to a CSV file.
🔸 Import Subscription orders from a CSV file.

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, subscriptions and coupons to CSV/XML/Excel (XLS/XLSX) file formats.
✅ Import WooCommerce orders, subscriptions and coupons using CSV/XML/Excel (XLS/XLSX) file formats.
✅ Import and export subscription orders.
✅ Import and export custom fields and third-party plugin fields.
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.
✅ 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 order import export 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

You can select the order or subscription statuses and coupon types that you want to export. The ‘export order CSV file’ will contain the order-related data that you have configured to export via the plugin. So ensure to configure all required export settings for a smooth WooCommerce order export. To Export WooCommerce Orders to CSV just click the Export Orders button from the plugin page.

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 WooCommerce order import 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. All the data in the import file CSV will be automatically added to your WooCommerce store upon successful import.

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.

RELATED PLUGINS FROM WEBTOFFEE

🔸 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.
🔸 WebToffee WooCommerce Product Feed & Sync Manager: Generate WooCommerce product feed for Google, Facebook and Instagram Shops and sync WooCommerce products with Facebook catalog.
🔸 WebToffee Gift Cards for WooCommerce: Create and sell gift card in your WooCommerce store. Allow your customers to buy, redeem, and share gift card.

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 on 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 d/m/y date format, you can use the {order_datewt_iew@d/m/Y} expression in the mapping field for order date.

Does this plugin import orders from an XML file?

No, this is a premium feature.

Does this plugin support multisite?

Yes.

Should the CSV be UTF-8 encoded?

Yes.

Reviews

25 Նոյեմբերի, 2024
Everything worked and saved me a tone of work. Thanks!
18 Հոկտեմբերի, 2024
Works great, quite straightforward process. We used it to export products from an old hosting plan to a new VPS with a 24 hour gap of missing products in between when the database was exported and the server build was carried out.
Read all 296 reviews

Contributors & Developers

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

Contributors

“Order Export & Order Import for WooCommerce” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “Order Export & Order Import for WooCommerce” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

2.5.8 2024-11-07

  • [Compatibility] — Tested OK with WooCommerce 9.3.3
  • [Compatibility] — Tested OK with WordPress 6.6.2

2.5.7 2024-10-11

  • [Compatibility] — Tested OK with WooCommerce 9.3.3
  • [Compatibility] — Tested OK with WordPress 6.6.2

2.5.6 2024-08-29

  • [Compatibility] — Tested OK with WooCommerce 9.2.3
  • [Compatibility] — Tested OK with WordPress 6.6.1

2.5.5 2024-07-11

  • [Compatibility] — Tested OK with WooCommerce 9.0.2
  • [Compatibility] — Tested OK with WordPress 6.5.5

2.5.4 2024-06-18

  • [Fix] — Issue with exporting while HPOS is enabled.

2.5.3 2024-06-12

  • [Fix] — Improvement in Encoding Characters.
  • [Compatibility] — Tested OK with WooCommerce 8.9.4
  • [Compatibility] — Tested OK with WordPress 6.5.4

2.5.2 2024-05-08

  • [Compatibility] — Tested OK with WooCommerce 8.8.3
  • [Compatibility] — Tested OK with WordPress 6.5.3

2.5.1 2024-03-26

  • [Add] — Import and export order attribution data.
  • [Compatibility] — Tested OK with WordPress 6.5

2.5.0 2024-03-20

  • [Fix] — Vulnerable to PHP Object Injection.
  • [Improvement] — Implemented a user interface update for the import/export screen, transitioning to a card-based layout for post type selection.
  • [Compatibility] — Tested OK with WooCommerce 8.7.0

2.4.9 2024-02-28

  • [Fix] — Enhanced Validation for Reading Log Files.
  • [Compatibility] — Tested OK with WooCommerce 8.6.1

2.4.8 2024-02-08

  • [Fix] — Invalid File type CSV.
  • [Fix] — Unable to download downloadable products.
  • [Compatibility] — Tested OK with WooCommerce 8.5.2
  • [Compatibility] — Tested OK with WordPress 6.4.3

2.4.7 2024-01-16

  • [Fix] — Invalid File type CSV.
  • [Compatibility] — Tested OK with WooCommerce 8.5

2.4.6 2024-01-04

  • [Fix] — Conflict with order item meta key named quantity and quantity.
  • [Compatibility] — Tested OK with WooCommerce 8.4
  • [Compatibility] — Tested OK with PHP 8.3

2.4.5 2023-12-28

  • [Fix] — Invalid File type CSV in Windows OS/Firefox.

2.4.3 2023-12-08

  • [Improvement] — File type validation on the ‘upload_import_file’ function.
  • [Compatibility] — Tested OK with WooCommerce 8.3.1.
  • [Compatibility] — Tested OK with WordPress 6.4.2.

2.4.2 2023-11-21

  • [Compatibility] — Tested OK with WooCommerce 8.3.0.

2.4.1 2023-11-09

  • [Fix] — Missing Tax item details of imported orders
  • [Compatibility] — Tested OK with WooCommerce 8.2.2.
  • [Compatibility] — Tested OK with WordPress 6.4.1.

2.4.0 2023-10-12

  • [Compatibility] — Tested OK with WooCommerce 8.2.0.

2.3.9 2023-09-5

  • [Compatibility] — Tested OK with WooCommerce 8.0.3.

2.3.8 2023-08-21

  • [Fix] — HPOS compatibility.
  • [Compatibility] — Tested OK with WordPress 6.3.
  • [Compatibility] — Tested OK with WooCommerce 8.0.2.
  • [Compatibility] — Tested OK With WP Overnight WooCommerce Order Proposal plugin.

2.3.7 2023-07-11

  • [Fix] — Error when performing order export while HPOS order sync is in progress.
  • [Compatibility] — Tested OK with WooCommerce 7.8.2.

2.3.6 2023-06-12

  • [Fix] — Auto delete history option does not delete import logs.
  • [Fix] — Incorrect max count value of line items.

2.3.5 2023-06-06

  • Fix: Error while importing orders with refund data.
  • Fix: Class OrderUtil not found.
  • Fix: Importing custom CSV contains colon in header columns.
  • Update: Tested OK with WooCommerce 7.7.2.

2.3.4 2023-05-15

  • Fix: Missing order subtotal in bulk order export from orders listing page.
  • Add: HPOS (High-Performance Order Storage) support added.
  • Add: WooCommerce Stripe Payments fee, WebToffee WooCommerce Stripe payments fee export import.
  • Update: Tested OK with WooCommerce 7.7.

2.3.3 2023-04-05

  • Update: Tested OK with WooCommerce 7.5, WordPress 6.2 & PHP 8.2.

2.3.2 2023-03-21

  • Update: Tested OK with WooCommerce 7.5.

2.3.1 2023-03-16

  • Add: WooCommerce PayPal Payments fee export import.
  • Update: Tested OK with WooCommerce 7.4.
  • Update: Added order subtotal in export.
  • Fix: Error when exporting orders without few line item details(line_total,line_tax).

2.3.0 2023-01-30

  • WooCommerce 7.3 Tested OK.

2.3.0 2023-01-02

  • WooCommerce 7.2 Tested OK.

2.2.9 2022-11-23

  • WooCommerce 7.1 Tested OK.
  • WordPress 6.1 Tested OK.
  • Enhancement: Revised import mapping screen.

2.2.8 2022-10-20

  • WooCommerce 7.0 Tested OK.
  • Enhancement: Set Min and Max limit for import and export default batch count in General setting page.

2.2.7 2022-08-25

  • WooCommerce 6.8 Tested OK.
  • Bugfix: Duplicate export button on order and coupon listing pages when both Pro and Free versions are active.

2.2.6 2022-08-08

  • WooCommerce 6.7 Tested OK.
  • Bugfix: Orders search by billing/shipping address not working for imported orders.
  • Bugfix: Delimiter reset when using the re-run option from the History section.

2.2.5 2022-07-04

  • WooCommerce 6.6 Tested OK.
  • Enhancement: Export to CSV option to Bulk Action drop-down menu in WC Orders listing page.
  • Enhancement: Import progress screen improvements.

2.2.4 2022-05-26

  • WordPress 6.0 Tested OK.
  • WooCommerce 6.5 Tested OK.
  • Enhancement: Option to choose delimiter when exporting.

2.2.3 2022-05-09

  • WC 6.4 Tested OK.
  • Enhancement: Bulk delete import logs.

2.2.2 2022-04-05

  • Enhancement: Option to — Update stock status and sales count of products upon order import.
  • Enhancement: Compatibility with WooCommerce shipment tracking and Advanced Shipment Tracking for WooCommerce.

2.2.1

  • Bugfix: Download link in imported orders not working.

2.2.0

  • Bugfix: Coupon import without status.
  • Enhancement: Performance and UI improvements, text corrections.

2.1.9

  • Bugfix: CSV mapping issues.

2.1.8

  • WP 5.9 Tested OK
  • Bugfix: WP custom plugins folder support.

2.1.7

  • Enhancement: Auto-suggestion of coupon codes making coupon-based filtering easier.

2.1.6

  • WC 6.1 Tested OK
  • Help text updated.

2.1.5

  • WC 6.0 Tested OK

2.1.4

  • WC 5.9 Tested OK
  • Compatibility with YITH WooCommerce Order Tracking

2.1.3

  • Bug fix: Time zones issue with coupon expiry date when importing coupon.

2.1.2

  • WC 5.8 Tested OK
  • Feature: Export order line items to separate row or column.
  • Bug fix: Time zones issue with coupon expiry date when importing coupon.
  • Improvements: Added filter wt_import_csv_parser_keep_bom for escaping cyrillic letters.
  • Fixes: Keeping previously selected options when e-running the export/import and wp_max_upload_size(), mb_detect_encoding() related issues.

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.