All In One WooCommerce Migration: Import & Export to Excel

WooCommerce Plugin
5.0
3 Reviews
v3.0.4
Updated 5 months ago
150+
Stores Live
excel, not CSV ↓

Migrate every WooCommerce data type with one Excel file.

Products, orders, customers, reviews, subscriptions, coupons. All round-trip through clean .xlsx files. No CSV character escaping. No add-on sprawl. No 30-minute reformat. $49.99/yr or $149 lifetime.

14-day refund
Backup before import
HPOS-ready
three things CSV plugins can't do ↓

One store. Three migration nightmares.

CSV files break the moment your data has a comma. Most import plugins handle products only. WooCommerce's native importer covers products and that's it. The moment you need to move orders, subscribers, or reviews across sites, you are gluing together three plugins and praying.

problem · 1

CSV breaks when a product name has a comma.

"Sweater, Wool"$49120✕ column shift
Description with "quote"$3288✕ escape error
Arabic: ‫قميص‬$2261✕ UTF-8 mangled

Excel handles commas, quotes, and non-Latin characters natively. CSV requires escape sequences, BOM headers, and locale-specific delimiters that fall apart between Excel for Mac and Excel for Windows.

problem · 2

One plugin per data type, four licenses to renew.

WP All Import Pro$299/yr
+ WooCommerce add-onincl.
+ Subscriptions add-onincl.
Reviews? Coupons?no support

The popular import plugins cover products well, orders sometimes, and stop there. Reviews and coupons need a separate tool. This plugin covers six data types in one $149 lifetime purchase.

problem · 3

One bad import wipes 8,000 product rows.

14:02Click import
14:03Wrong column mapping
14:048,142 rows overwritten
14:05backup .xlsx · restore in 1 click

The plugin can take a full Excel snapshot of the affected data before any import runs. If the new file is wrong, re-import the backup and the store is back where it was, in minutes.

eight controls you'll use ↓

Every data type. Every field. One Excel file.

The plugin handles four jobs: export any data type to .xlsx, edit it in Excel or Google Sheets, import with add, update, or overwrite modes, and back up automatically before any destructive run.

scope · six data types

Products, orders, customers, reviews, subscriptions, coupons.

No add-ons. No staging plugin to glue on top. One install covers every data type the importer needs to touch.

format · .xlsx native

Excel, not CSV. Comma-safe, quote-safe, UTF-8 safe.

Excel handles edge cases CSV chokes on. Open the same file on a Mac, a PC, or in Google Sheets, the rows stay aligned.

templates · pre-formatted

One template per data type. Pre-labeled columns.

Every column the importer accepts is labeled and documented in the template. Start from the file, no schema guesswork.

mode · add · update · overwrite

Three import modes, picked per run.

Re-imports never create duplicates. Bulk price update? Pick Update. New product batch? Pick Add. Full migration? Overwrite.

safety · backup .xlsx

Auto-snapshot before any destructive import.

No "undo" button needed. The backup is a real .xlsx file you can open, audit, and restore from any time.

validate · before write

The plugin flags errors before a single row writes.

deep · subscriptions + reviews

The data types other importers skip.

Bulk-update renewal dates on 200 subscribers. Reassign 80 reviews from a discontinued SKU to its replacement. The kind of move that used to be a database task.

meta · custom fields included

Custom fields and third-party plugin data, per column.

Pick which custom fields and third-party plugin meta to include in the export. Skip what you don't need, keep the file slim.

setup

Four steps. Backup, edit, import, done.

i · install

Activate the plugin

Upload the .zip from Plugins → Add New, then activate. A new Store Migration menu appears under WPFactory.

All In One WooCommerce Migration: Import & Export to Excel Active
ii · export

Export the data type you need

Pick Products, Orders, Customers, Reviews, Subscriptions, or Coupons. Click Export. The plugin builds a .xlsx file with every supported column.

data type Products
format .xlsx
iii · edit

Edit in Excel or Google Sheets

Bulk update prices, stock, statuses, attributes, or any other column. Use formulas, autofill, find-replace, whatever Excel does best.

price+10% formula ✓
stockrefilled ✓
SKUrenamed ✓
iv · import

Re-import with a backup first

Pick Add, Update, or Overwrite. The plugin snapshots the affected rows to backup.xlsx, validates the file, then writes the new values.

how we stack up

Every data type. One Excel-native plugin.

WooCommerce
native · CSV only
Product CSV Import Suite
$59/yr · no lifetime
WP All Import Pro
from $299/yr · $1,299 lifetime
WPFactory
$49.99/yr · $149 lifetime
scope: what you can move
Products import / export✓✓✓
Orders import / export✕✕✓
Customers import / export✕✕✓
Subscriptions import / export✕✕via add-on
Reviews import / export✕✕✕
Coupons import / export✕✕not specified
file format & safety
Excel (.xlsx) native✕✕✕
CSV / XML support✓✓✓
Auto-backup before import✕✕✕
Sample template per data typeproducts onlyproducts onlynot specified
Pre-import validation preview✕limited✓
import controls
Add / Update / Overwrite modesbasic✓✓
Match by SKU or ID (no duplicates)SKU only✓✓
Include / skip custom fields✕limited✓
Reassign reviews to another product✕✕✕
Bulk delete from sheet✕✕not specified
pricing & ownership
Free version on .org-✕✕
Lifetime tier-✕✓ $1,299
Multi-store licensing-1 site✓
10-year cost$0~$590$1,299
50+ plugins (All Access)-✕✕
Ready to move every data type with one Excel file? ↓ Jump to pricing
scroll →
three real stores ↓

Three migrations. Three data sets.

staging → live

Apparel shop · "Move the full catalog from staging to live."

A clothing store rebuilds its catalog on a staging site. 1,400 products with variations, custom fields, and EAN codes. Export Products to .xlsx from staging, drop the file on the live site, click Import in Overwrite mode. The variations, attributes, and EAN columns land in place.

Data typesProducts only
ModeOverwrite · match by SKU
Backupauto-snapshot of live catalog before write

Migration took 12 minutes. Zero CSV escape errors. Three rollbacks were tried during testing, each restored from the backup .xlsx in under a minute.

review reassignment

Skincare brand · "Move 80 reviews from a retired SKU."

A skincare brand replaces an old serum with a v2 formula under a new product ID. 80 five-star reviews live on the old product. Export Reviews, change the product-ID column for those 80 rows to the new SKU, re-import. The reviews now hang under the v2 product.

Data typesReviews only
ModeUpdate · reassign by product ID
ResultStar rating on v2 product page · ratings preserved

Average rating on the v2 product launched at 4.8 instead of empty. Conversion rate for the new product matched the retired one within a week.

verified reviews

From stores using this right now.

Using the plugin? Leave a review on WordPress.org.

"Great plugin and even better support. Quick replies, they actually solve the problem instead of pointing at a docs page."
M
marcinp
verified buyer
verified review from another WPFactory plugin
see review →
"Solid build, does exactly what it says. Worth the price for the time it saves on bulk work."
S
stevenc
verified buyer
verified review from another WPFactory plugin
see review →
tested with

Works with the data types and plugins you already run.

Platform

WP 5.0+WP 6.9WC 4.0+WC 10.7PHP 7.4+PHP 8.3HPOS-ready

Data types

ProductsVariationsOrdersCustomersReviewsSubscriptionsCoupons

Formats

.xlsx.xlsCSVUTF-8 safemulti-tab sheets

Plugins

WC SubscriptionsWPMLPolylangACFYoast SEOCOGSEAN Barcodes
why this plugin

Built for stores where data has to move without breaking.

Every WPFactory plugin ships with the same eight guarantees. Here's what running this one looks like in practice.

Clean code, reviewed

Built on PhpSpreadsheet, the same library professional Excel tools use. Imports stream row by row so memory stays flat. Validation runs before the first write, nothing partial-commits on failure.

Docs & specs, written

Every supported column documented per data type. Sample .xlsx templates included for products, orders, customers, reviews, subscriptions, and coupons.

Support that ships

Format quirk, plugin compatibility, weird column edge case? Email the support team, they reply fast and ship fixes in days, not quarters.

14-day money-back

14-day refund on yearly and lifetime, 30 days on All Access. No questions asked. If a custom field never lands the way you'd hoped, support helps, then you walk away whole.

Bundle savings, real

All Access is $499 once for all 50+ plugins, lifetime, unlimited sites, and it includes every plugin we release later. Three lifetime licenses at $199 already cost $597, so the bundle usually wins by your third plugin.

Updates, regularly

v1.6.0 shipped recently. Tested against the latest WooCommerce within days of every release. HPOS-ready, PHP 8.3 compatible. Tracks the WC subscription schema so renewal imports stay accurate.

Plays well with others

Compatible with WooCommerce Subscriptions, WPML, Polylang, ACF, Yoast SEO, Cost of Goods, EAN Barcodes. Third-party meta keys round-trip cleanly through the .xlsx columns.

Designed for store owners

You don't need to know what SQL looks like. Pick a data type, click Export, edit in Excel, click Import. The schema work is hidden, the spreadsheet is what you touch.

6 stores joined this week·2 in the last 24h
if you're going to keep this plugin a while ↓

Three tiers. Pick once.

14-day refund on yearly and lifetime, 30 days on All Access. Lifetime pays for itself by year 3. All Access pays for itself with any 2nd plugin you'd ever use. Yearly auto-renew can be turned off in your account.

MIGRATION PRO
$149 once

Buy once. Owns itself by year 3. Use on the site that needs it.

  • 1 site license
  • Lifetime updates
  • Priority email support
  • 14-day refund
  • GPL-licensed · use on client sites
Buy Lifetime - $149 once
★ SMART MOVE ALL ACCESS · LIFETIME
$999$499oncesave 50%

This plugin + 49 others, lifetime updates, unlimited sites - for $350 more than Lifetime alone.

! Buying any 4 single lifetimes?
$596 → $499 / 50+
  • 50+ plugins, lifetime updates
  • Unlimited sites - every plugin
  • Future plugins included free, forever
  • Lifetime priority support
  • Pays back at 4th plugin you'd use
Explore All Access
What can I import and export with this plugin?
Products, orders, customers, reviews, subscriptions, and coupons. All through .xlsx Excel files. One plugin, every data type, no extra add-ons to chase down.
Does it support bulk editing?
Yes. Export to Excel, edit prices, stock, statuses, or any other field in bulk, then re-import the file. Records match by ID or SKU so updates land on the right rows.
Can I migrate my WooCommerce store to a new site?
Yes. Export every data type from the old site, drop the .xlsx files into the new site, click import. Works for staging environments, server moves, and post-crash rebuilds.
Can I import without overwriting existing records?
Yes. Pick add-only, update-existing, or overwrite-specific-fields per import. Match by ID or SKU so re-imports do not create duplicates.
Does it handle variations and custom product attributes?
Yes. Simple, variable, grouped, and subscription products are all supported. Attributes, variations, SKUs, custom fields, and third-party plugin meta all round-trip through the .xlsx file.
Is it compatible with WooCommerce Subscriptions?
Yes. Subscription plans, customer assignments, start and end dates, statuses, and renewal info all import and export. Useful for migrating active subscribers or bulk-updating renewal dates.
How do I format my Excel file for importing?
Every data type has a downloadable sample .xlsx template inside the plugin. Open it in Excel or Google Sheets, fill in the rows, save as .xlsx, upload. The template has every supported column already labeled.
Can I import orders with line items and shipping?
Yes. Full order data including product line items, quantities, totals, shipping methods, payment status, and billing and shipping addresses imports in one pass.
What happens if my file has errors?
The plugin validates the file before the import runs and flags formatting issues row by row. You fix them in Excel and re-upload, nothing in your store changes until the file is clean.
Can I undo an import?
There is no one-click undo, but the plugin can create a full Excel backup of the affected data type before any import. If something goes wrong, re-import the backup to restore the previous state.
Is there a record limit?
No hard limit. Performance depends on the server. Large stores typically split very big files into batches of 5,000 to 10,000 rows for the smoothest run.
Do I need technical skills?
No. If you can open Excel and copy a column, you can use this plugin. The sample templates take care of the formatting.
What is the refund policy?
14 days on the yearly and lifetime plans, 30 days on All Access. No questions asked. Lifetime never renews. Yearly auto-renew can be turned off in your account.
Is there a free version?
Yes. The free version on WordPress.org covers the core import and export flow for products and orders. The Pro version adds reviews, subscriptions, coupons, customers, scheduled exports, backup-before-import, and priority support.
if you've scrolled this far ↓

Stop juggling CSVs and add-ons. Move every data type in one Excel file.

Products, orders, customers, reviews, subscriptions, coupons. One plugin, one .xlsx, backup-before-import included. 150+ stores already running it. 14-day refund if it's not for you.

150+ stores · 5.0★ across 3 reviews · WordPress.org plugin · 14-day refund