Plugins Plugin hub Backup SEO Caching Security Forms WooCommerce Images Best backup plugins
Hosting Hosting directory Shared hosting Managed WordPress Cloud hosting VPS hosting By reader location Hosting finder
Themes & builders Compare Rank Math vs Yoast
Tools All tools Hosting finder Plugin stack builder Cost calculator Salt generator Theme detector Who is hosting this? Speed test Headline analyzer robots.txt generator Redirect generator Uptime calculator Blog name generator
Blog Best backup plugins Deals
Guides All guides Speed up WordPress Choose hosting Back up WordPress
How we test

WooCommerce · Guide

How to Import WooCommerce Orders (Step by Step)

How to Import WooCommerce Orders (Step by Step)

Short answer

WooCommerce has no built-in order importer, so install a plugin like Order Export and Order Import for WooCommerce or WP All Import. Import products and customers first, map CSV columns to order fields, switch off customer emails, test a few orders, then import the rest.

Key takeaways

  • WooCommerce core imports products only, not orders.
  • Import products and customers before orders so line items and accounts link correctly.
  • Map the order date and status, or every order will look new.
  • Turn off customer emails before importing to avoid spamming old buyers.
  • Test with five to ten orders, then compare totals after the full import.
  • Developers can create orders through the REST API for ongoing syncs.

How do you import orders into WooCommerce?

WooCommerce has no built-in order importer, so you use a plugin such as Order Export & Order Import for WooCommerce or WP All Import, map your CSV columns to order fields, run a test, then import the full file.

The built-in WooCommerce importer under Products > Import only handles products. Orders need either a plugin or the REST API.

The overall process looks like this:

  1. Export orders from the old system as CSV or XML.
  2. Import or match customers and products first.
  3. Install an order import plugin.
  4. Map columns to WooCommerce order fields.
  5. Import a small test batch.
  6. Import the rest and check totals.

People usually import orders when moving from another platform, merging two stores, or restoring order history after a problem. Each case uses the same core steps.

If you are moving a whole WooCommerce store between hosts, a full site migration is easier than importing orders. Our guide to migrating a WooCommerce store covers that route.

Step 1: How do you prepare your order data?

Export orders to a CSV with one row per order or per line item, include customer email, product SKU, quantities, prices, totals, dates and status, and clean it before importing.

Good order data is the difference between a smooth import and hours of fixes. Open the file in a spreadsheet and check these columns exist:

  • Order ID or number from the old system.
  • Order date in a consistent format such as 2026-03-15 14:20:00.
  • Status such as completed, processing or refunded.
  • Customer email, plus billing and shipping names and addresses.
  • Line items with product SKU, quantity and line total.
  • Shipping, tax, discount and order total.
  • Payment method title and transaction ID if you have it.

Then clean it:

  • Remove blank rows and duplicate orders.
  • Make sure every SKU exists in your WooCommerce catalog.
  • Use the same currency for every order.
  • Save as UTF-8 CSV so names with accents import correctly.

If your old store is also WooCommerce, export with the same plugin you will import with. Our guide to exporting WooCommerce orders to CSV explains the export side.

Step 2: Why should you import products and customers first?

Orders link to products and customers, so if those records do not exist yet, line items lose their product link and orders become guest orders.

Order importers match line items to products, usually by SKU. If no product has that SKU, the item may still import as plain text, but it will not link to stock or reports.

Import your catalog first. Our guide to importing WooCommerce products with images covers that step.

For customers, most import plugins can either:

  • Match an existing user by email address.
  • Create a new customer account during the order import.
  • Leave the order as a guest order.

Decide which you want before you start. Creating accounts can trigger welcome emails, which you probably do not want for old customers.

Step 3: Which plugin should you use to import orders?

For most stores, the free Order Export & Order Import for WooCommerce plugin handles CSV order imports, while WP All Import suits complex files that need custom mapping.

Here are the main options:

OptionCostBest forNotes
Order Export & Order Import for WooCommerce (WebToffee)Free, with paid upgradeStandard CSV order movesImports files in its own export format
WP All Import with its WooCommerce add-onPaid for order importsUnusual files, XML, custom fieldsDrag-and-drop field mapping
WooCommerce REST APIFreeDevelopers, ongoing syncsSend orders with POST requests
Platform migration servicesPaidMoving from Shopify or othersMoves products, customers and orders together

The Order Export & Order Import for WooCommerce plugin is free on WordPress.org. WebToffee also publishes a guide to importing orders into WooCommerce with screenshots. Check its plugin page for which features need the premium version.

WP All Import is the more flexible choice for files from other systems. Order import needs its paid WooCommerce add-on. See our guide to using WP All Import for how its mapping screen works.

Step 4: How do you map CSV columns to WooCommerce order fields?

Upload the file in your import plugin, then match each CSV column to its order field, such as billing email, line item SKU, order total and status, before running the import.

The exact screens differ, but most importers follow the same flow:

  1. Go to the plugin's import screen, often under WooCommerce or All Import.
  2. Choose Order as the post type.
  3. Upload your CSV.
  4. Map columns to fields.
  5. Set options for existing orders, customers and emails.
  6. Run the import.

Fields to map with care:

  • Order date. If you skip it, every order gets today's date and your reports will be wrong.
  • Status. Map it so completed orders stay completed.
  • Line items. Match by SKU, not product name, where possible.
  • Totals. Map them directly rather than letting WooCommerce recalculate.

Some plugins let you save a mapping template. That saves time if you import in several batches.

Step 5: How do you avoid sending emails to customers during import?

Turn off order and account emails in your import plugin's options, or temporarily disable them under WooCommerce > Settings > Emails, before you run the import.

This is the step people forget most often. Importing hundreds of completed orders can send hundreds of Your order is complete emails to real customers.

Two ways to stop that:

  • Plugin setting. Many importers have a checkbox to skip emails. Use it.
  • Disable emails temporarily. Go to WooCommerce > Settings > Emails, open each customer email and untick Enable this email notification. Turn them back on after the import.

Also watch for:

  • New account emails if the import creates customers.
  • Stock changes. Importing old orders can reduce stock. Check whether your plugin offers an option to skip stock updates, or fix stock levels after the import.
  • Third-party hooks that send orders to shipping or accounting tools. Pause those integrations during the import.

Step 6: How do you test and finish the import?

Import five to ten orders first, check them against the source data, fix the mapping if needed, then import the full file and compare totals.

Test on a staging site if you can. Our guide to setting up a staging site for WordPress explains the options.

For each test order, check:

  • Date, status and order number.
  • Customer name, email and addresses.
  • Line items, quantities and prices.
  • Shipping, tax, discounts and total.

When the test passes, run the full import. Large files may time out on shared hosting. Split them into smaller CSV files, or use a plugin that imports in batches.

Afterwards, compare a few numbers:

  • Total order count in the source versus WooCommerce.
  • Sum of order totals for a sample month.
  • A handful of random orders checked line by line.

Can you import orders with the WooCommerce REST API?

Yes. Developers can create orders by sending POST requests to the orders endpoint with line items, billing details and status in JSON, which suits ongoing syncs.

The WooCommerce REST API documentation covers the orders endpoint. You need a key with Write permission, which our guide on getting a WooCommerce API key explains.

The older REST API reference on GitHub Pages lists every order property with sample requests in several languages.

A minimal order body includes:

  • status, such as completed.
  • billing and shipping objects.
  • line_items with product_id or sku and quantity.
  • set_paid if the order was already paid.

The API is better for continuous syncs from another system. For a one-time move, a plugin is usually faster and needs no code.

What problems come up when importing WooCommerce orders?

The most common problems are wrong dates, unlinked products, duplicate orders, sent emails and timeouts, and most are fixed by better mapping and smaller batches.

ProblemCauseFix
All orders show today's dateDate column not mappedMap the date and re-import
Products not linkedSKU missing or differentFix SKUs in the catalog or CSV
Duplicate ordersImport run twiceUse the plugin's skip or update existing option
Customers got emailsEmails left onDisable emails before importing
Import stops halfwayServer timeout or memory limitSplit the file and raise limits
Totals differWooCommerce recalculatedMap totals directly

Stores using High-Performance Order Storage keep orders in their own tables. Make sure your import plugin supports it. Our guide to enabling HPOS in WooCommerce explains what it changes.

Back up your database before every import. Our guide to backing up a WooCommerce store covers the safe way to do it.

Frequently asked questions

Can WooCommerce import orders without a plugin?

Not through the dashboard. The built-in importer handles products only. Without a plugin, the only option is the REST API, which needs code or an automation tool to send each order as a POST request. For most store owners, a free import plugin is the simpler route.

Will importing old orders reduce my stock levels?

It can. Some importers reduce stock as orders are created, just like a live sale. Check the plugin options for a setting to skip stock updates. If none exists, note your stock levels before the import and correct them afterwards.

Can I keep the original order numbers?

Order IDs are assigned by WooCommerce, so they rarely match the old system. Some import plugins store the old number in a meta field, and sequential order number plugins can display it. Check your import plugin's options for keeping original order numbers.

How do I import orders from Shopify into WooCommerce?

Export orders from Shopify as CSV, then reshape the file to match your import plugin's format, or use a flexible importer with custom mapping. Paid migration services can move products, customers and orders together, which is often easier for large stores.

What file format do WooCommerce order importers accept?

CSV is the most common format. Some plugins, such as WP All Import, also accept XML and spreadsheet files. Whatever the format, save it with UTF-8 encoding so names and addresses with special characters import correctly.

Sources

  1. Order Export & Order Import for WooCommerce WordPress.org Plugins
  2. Import orders to WooCommerce WebToffee
  3. WP All Import WordPress.org Plugins
  4. WooCommerce REST API WooCommerce Developer Docs

Is your product missing, or something out of date?

Tell us what to add or correct. We read every note and reply when we need a source. A message does not buy a ranking.

About the editors

Written and checked byWPLegible Editorial Team Independent WordPress reviews and guides

Researched from the primary sources listed above and checked against our editorial rules before publishing.