"Save as CSV, then break the formatting."
The native WooCommerce importer is CSV-only. Every Excel file gets a clean-up pass first, every clean-up pass introduces a new bug.
The fastest way to move products in and out of WooCommerce.
Import, update, and export products straight from Excel (.xlsx) or Google Sheets. Drag-and-drop column mapping, single-row variable products, scheduled cron syncs, ACF and Yoast SEO support, bulk delete by ID or SKU. $49.99/yr or $149 once.
Stock changes daily. Suppliers send Excel files, not CSV. Variable products explode into hundreds of rows. The built-in importer chokes on all three. So you either spend a day cleaning data or you hire a developer.
The native WooCommerce importer is CSV-only. Every Excel file gets a clean-up pass first, every clean-up pass introduces a new bug.
A 50-product catalog with sizes and colors becomes 400+ rows. One bad SKU breaks the parent, every variation orphans, you re-import twice.
The native importer is one-shot, in-browser, manual. By Wednesday your "in stock" column is a fiction and the refunds queue is growing.
The plugin does four jobs: read Excel and Google Sheets natively, map columns to WooCommerce fields with reusable templates, create or update any product type (including a full variable product from one row), and schedule the whole thing via cron so suppliers keep your catalog fresh.
Multi-byte characters, commas, line breaks, formulas - all preserved. Upload the file your supplier sent, not a re-saved copy.
Save a mapping as a template, reuse it next month. No code, no docs lookup, no remembering which column is which.
Pipe-delimited attribute values. The plugin builds the parent, every variation, and the attribute taxonomy in one pass.
Point the schedule at a public Excel URL or Google Sheets share link. The plugin pulls, maps, and updates without a human in the loop.
Suppliers, warehouses, agencies usually maintain catalogs in Sheets already. Skip the export-import dance, point at the source.
Match by ID, SKU, or title. Works on products and categories. Discontinued line? Drop the SKU list, click Delete.
Grant the wpeieWoo capability per role. Agencies hand the importer to clients without exposing the rest of wp-admin.
Upload the .zip from Plugins → Add New, then activate.
Products → Import Export Excel → Upload. Excel, Google Sheets, or any public URL works.
The plugin reads the header row and offers every WC field. Save the mapping as a reusable template.
Click Import for a one-shot. Or pick an interval (hourly, daily, custom) and the plugin re-pulls the sheet on its own.
WooCommerce native · CSV only |
WP All Import Pro from $299/yr · $1,299 lifetime |
WebToffee from $69/yr · no lifetime |
WPFactory $49.99/yr · $149 once |
|
|---|---|---|---|---|
| core: file formats | ||||
| Native Excel (.xlsx) import | ✕ | via paid add-on | ✓ | ✓ |
| CSV import | ✓ | ✓ | ✓ | ✓ |
| Google Sheets URL as source | ✕ | ✕ | ✓ | ✓ |
| Drag-and-drop column mapping | ✕ | ✓ | ✓ | ✓ |
| Reusable mapping templates | ✕ | ✓ | ✓ | ✓ |
| product types & fields | ||||
| Variable products | partial | ✓ | ✓ | ✓ |
| Single-row variable products | ✕ | ✕ | ✕ | ✓ |
| External / affiliate products | ✕ | ✓ | ✓ | ✓ |
| Subscription products | ✕ | ✓ | ✓ | ✓ |
| Downloadable file URL + expiry + limit | limited | ✓ | ✓ | ✓ |
| ACF + ACF Pro fields | ✕ | ✓ | ✓ | ✓ |
| Yoast SEO title + meta description | ✕ | ✓ | ✓ | ✓ |
| Custom taxonomies with hierarchy | ✕ | ✓ | ✓ | ✓ |
| Featured image + gallery from URLs | URL only | ✓ | ✓ | ✓ |
| operations | ||||
| Update existing by ID, SKU, or Title | ID only | ✓ | ✓ | ✓ |
| Bulk delete products / categories | ✕ | ✕ | products only | ✓ |
| Scheduled cron imports | ✕ | ✓ | ✓ | ✓ |
| AJAX batch processing | ✓ | ✓ | ✓ | ✓ |
| Per-role access (wpeieWoo capability) | ✕ | ✕ | ✕ | ✓ |
| pricing & ownership | ||||
| Free version on .org | - | ✓ | ✓ | ✓ |
| Lifetime tier | - | ✓ $1,299 unlimited | ✕ | ✓ $149 unlimited sites |
| Unlimited sites on entry tier | - | ✓ | ✕ 1 site | ✓ |
| 10-year cost | $0 | $1,299 | ~$2,490 | $149 |
| 50+ plugins (All Access) | - | ✕ | ✕ | ✓ $499 |
|
Ready to import a real catalog? ↓
Jump to pricing
|
||||
An apparel brand exports its Shopify catalog as Excel, drags four columns onto the WooCommerce mapping, and runs the import in AJAX batches of 200. Variable products with size and color expand from one row each. Featured images and galleries pull from Shopify's CDN URLs.
Two AJAX runs, 4 hours total. Zero rows lost. Mapping saved as a template for the next supplier feed.
A drop-shipping store points the plugin at the supplier's Google Sheets URL. Cron runs at 04:00 every day, pulls the sheet, updates stock_quantity and price on 1,400 SKUs. Discontinued lines get deleted automatically when the supplier removes their row.
Oversold orders dropped from 6/wk to 0. Shop manager runs the importer instead of a developer.
A B2B parts store maintains the catalog in a master Excel with ACF specification fields (voltage, weight, certification) and Yoast SEO titles. The plugin imports all three language versions in one run via WPML's language column.
Spec-sheet updates that used to take half a day per language now run in 18 minutes total. Yoast meta no longer drifts between languages.
Using the plugin? Leave a review on WordPress.org.
"Finally a Woo importer that just reads my .xlsx. Saved me a full day on a 5,000-SKU catalog migration."see review →
"Cron + Google Sheets is the killer feature. Supplier maintains the sheet, my catalog updates itself overnight."see review →
"Single-row variable products. Other plugins make you flatten the parent + children sheet. This one just works."see review →
Every WPFactory plugin ships with the same eight guarantees. Here's what running this one looks like in practice.
AJAX batches keep PHP memory and timeout headroom. The PhpSpreadsheet engine reads .xlsx natively, no shelling out. Mapping templates and cron schedules live in their own option keys, not in postmeta sprawl.
Every supported field is listed in the docs with the exact column key. Sample .xlsx templates ship with the plugin. Filters exposed for column transforms and pre-save validation.
Email-only support, no SLA promises, but bug reports turn into releases within days. The plugin shipped 12 minor versions in the past 12 months.
14-day refund on yearly and lifetime, 30 days on All Access, no questions asked. If your sheet shape isn't supported, support helps; if it still isn't a fit, you walk away whole.
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.
v12.1.5 shipped this month. Tested against WooCommerce 10.8 within days of release. HPOS-ready, PHP 8.3 compatible.
ACF, ACF Pro, Yoast SEO, WPML, Polylang, WooCommerce Subscriptions all hook in cleanly. Custom post types and taxonomies map like first-class fields.
You don't need to be a developer to point at a sheet and run an import. The wpeieWoo capability lets you hand the importer to non-admin staff safely.
This is what you see inside WordPress once the plugin is activated.
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.
Buy once. Owns itself by year 3. Use on every site you own.
This plugin + 49 others, lifetime updates, unlimited sites - for $350 more than Lifetime alone.
If yours isn't here, our support replies fast.
Popular guides
wpeieWoo capability you can assign to any role, so shop managers can import without granting full administrator access.Native .xlsx and Google Sheets. Drag-and-drop column mapping. Single-row variable products. Scheduled cron syncs. ACF, Yoast, custom taxonomies. Bulk delete. Per-role access. 2,200+ stores already running it. 14-day refund if it's not for you.
2,200+ stores · 4.6★ across 30 reviews · WordPress.org plugin · 14-day refund