Easily Import WooCommerce Orders from CSV, Excel, and XML

Drag & drop to set up an import for thousands of orders in minutes.

Support for all WooCommerce order data
Order status, billing & shipping, taxes, etc
Match orders to products and customers
Migrate WooCommerce orders from any platform

Buy Now

90-Day Money Back Guarantee

Not 100% happy? Let us know, and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

Fast, World Class Support

Over 9 years of experience with WooCommerce order imports.

"I had a large catalog with thousands of SKUs to load and modify in WooCommerce, and this plugin made it a breeze."

@cholleman

"The must-have plugin for every WooCommerce retailer. WP All Import and WP All Export are magic."

@psvos

"Efficiency at its best! This plugin is absolutely a must-have. Save thousands of hours with WooCo product management."

@gr1performance1

1500+ five star reviews and over 100,000 happy users.

Drag & drop WooCommerce order imports.

Import WooCommerce orders from CSV, XML, or any spreadsheet. Create an import for thousands of orders in minutes. No need to reorganize your data — just drag & drop.

Billing details, order items, taxes, and everything else.

You can import data into every WooCommerce order field, including status, shipping details, order notes, and more.

Link imported orders to customers and products.

Link your WooCommerce orders to existing customers and products, automatically pulling their data into your orders.

No-setup migration for orders from other WordPress sites.

Migrate orders, customers, and products without overwriting any existing data. No configuration required — everything is set up automatically.

Import WooCommerce orders from anywhere.

Import orders from any platform, even if it doesn't have an export function. Upload any file format, with no need to process, convert, or reorganize your data. XML, CSV, Excel, Google Sheets, etc. - we have you covered.

Import WooCommerce Orders Any File Format

Feature-packed WooCommerce order imports, flexible and dead simple.

Any File Type, Any File Structure

No need to reorganize your WooCommerce order data. Just upload your file, and our plugin will sort it out.

Complete Customization

Granular control over every single piece of data. Think your order import is too complicated? Think again.

Import Huge Amounts of Data

It doesn't matter how big your site is or how many WooCommerce orders you need to import.

Multilingual sites with WPML

Importing WooCommerce orders to a multilingual site has never been easier, with support from the WPML team.

Not Just WooCommerce Orders, Everything

Import and export WooCommerce products, customers, categories, image galleries, and more.

WooCommerce Extensions, ACF, and More

Import data into any theme or plugin, including WooCommerce extensions, ACF, Toolset Types, etc.

Scheduled Order Imports

Run your WooCommerce order imports automatically on a schedule. Subscribe to our point-and-click scheduling service, or set up cron jobs.

Developer Friendly

Write and test PHP right inside our plugin when setting up your import, with tons of snippets to get you started.

Go for a test drive right now.

Try Live Demo

Frequently Asked Questions for WooCommerce Order Imports

How do I import orders into WooCommerce?

Navigate to All Import -> New Import.
Upload the import file.
Select WooCommmerce Orders as the import type.
Map the incoming data elements to the order fields.
Run the import and verify the imported data.

How do I import orders from CSV to WooCommerce?

To import orders from CSV to WooCommerce, go to All Import > New Import and specify your CSV files as the source data for the import. WP All Import will automatically recognize the file type and adjust its interfaces accordingly.

How do I import orders from Excel to WooCommerce?

To import orders from Excel to WooCommerce, create a new import that uses the Excel files as the import source. Our plugin will automatically recognize the file type and adjust its interfaces accordingly.

Can I import WooCommerce orders using XML?

Yes. No matter the structure of your XML file, importing it to WooCommerce orders is simple. Just map the incoming data elements to the WooCommerce order fields using our Drag & Drop interface, then run your import.

How do I download all WooCommerce orders?

First, run a standard export without applying any filters. If you want to export all order fields (including custom order data), click the Add All button in the Drag & Drop interface. You can perform this type of order export in less than a minute.

How do I import customers and orders in WooCommerce?

If the customer and order data are in the same file, you can instruct our plugin to import customers as guest customers during the order import. Otherwise, import customers and orders separately, and our plugin will help you link them.

Where is WooCommerce order data stored?

WooCommerce order data is stored as a custom post type in the wp_posts table. The order metadata is in wp_postmeta. WooCommerce stores order item data in its own custom tables, such as wp_woocommerce_order_items and wp_woocommerce_order_itemmeta.

How do I export orders from WooCommerce?

To export orders from WooCommerce, go to All Export > New Export and select WooCommerce Orders as the export post type. User our Drag & Drop tool to select your order columns, then run the export and download your export file.