WooCommerce offers an in-built CSV product importer that imports files that already follow WooCommerce's rigid column format. Supplier files frequently arrive in other formats, which poses a challenge. The built-in tool cannot transform values or filter rows during an import, so mismatched prices, image columns, and variation structures have to be fixed in the spreadsheet before upload.
The plugins reviewed in this article import WooCommerce products from CSV files with less of that cleanup, each to a different degree. Each entry covers pros, cons, reviews, pricing, and the store types it fits best.
📑 Table of Contents
What a WooCommerce CSV Import Plugin Should Handle
WooCommerce's built-in importer covers files that already match its column format. A strong CSV import plugin, however, goes beyond the basics and earns its place by handling the files that don't. These six capabilities define that difference for WooCommerce products:
- Automatic field mapping: CSV columns automatically pair with WooCommerce product fields on upload, so mismatched column names don't require a manual match for each one.
- Flexible file structure: Supplier files import in whatever column order, naming, or delimiter they arrive in, with no reformatting beforehand.
- Data transformation: Prices, dates, and stock values change during the import itself, which takes away the need to make corrections in the spreadsheet.
- Variable product support: Variation rows link to their parent products through SKUs, IDs, or other shared identifiers, even when the file doesn't follow WooCommerce's parent/child layout.
- Image handling: Whether a file separates image URLs in one cell or spreads them across several columns, the plugin downloads each image and builds the product gallery.
- Update matching: Re-importing a revised file updates existing products matched by SKU or ID, and only the selected fields change, so no duplicates are created.
The Best WooCommerce CSV Product Import Plugins
1. WP All Import
WP All Import is a freemium plugin by Soflyy that handles a clean product CSV and a difficult one, all inside the same import.
Automatic Setup for Standard CSV Files
WP All Import maps a standard WooCommerce product CSV automatically. Automatic Setup launches from the Set up automatically callout on the All Import › New Import screen. Once the file is uploaded and WooCommerce › Products is selected, WP All Import identifies the product type and maps each recognized column. The Your Import Is Ready screen lists the fields mapped and records to import, and Run Import creates the products.
Manual Setup for Files That Need Changes
When a CSV needs more than mapping, Manual Setup opens the same import in the drag-and-drop editor, where WP All Import transforms the data as it imports. XPath IF statements choose the right price column for each row, and PHP functions reformat dates, text, and numbers before WooCommerce saves them. For variable products, a parent SKU column links each variation to its parent product, while filters keep rows that don't belong in the store out of the import. When a revised version of the file arrives, WP All Import matches each record to an existing product by SKU and updates only the selected fields.
Pros
- Automatic Setup maps standard product CSV files without manual configuration.
- Drag-and-drop mapping accepts any column order or naming, and any delimiter character.
- Built-in price adjustment marks prices up or down or converts currency during the import.
- XPath IF statements and PHP functions transform any value before WooCommerce saves it.
- Variable product support links variations to parent products through a parent SKU column.
- One import screen handles CSV, XML, Excel, and Google Sheets files.
Cons
- Variable, grouped, and external product imports, PHP functions, and imports from a URL require the paid version.
- Automatic Scheduling is a separate monthly subscription. Scheduling through server cron jobs is included.
Reviews
- WordPress.org: 4.7 with 1,962 reviews
Price
WP All Import offers a free version for basic imports. Premium packages that include WooCommerce product imports start at $169 per year with the WooCommerce Import Package, and a one-time lifetime license is available for $1,299. All packages include unlimited site installs and a 90-day money-back guarantee.
Recommended For
WP All Import is recommended for WooCommerce stores that import a one-time catalog from a clean CSV and for stores that run recurring supplier feeds needing price rules, row filters, and variation linking.
2. WP Ultimate CSV Importer
WP Ultimate CSV Importer is a freemium import plugin by Smackcoders. The free version imports simple WooCommerce product data, while variable, grouped, and external products require the free Import WooCommerce Suite add-on. Field mapping runs in either a drag-and-drop mode or an Advanced Mode with dropdown selection.
Pros
- Imports CSV, XML, XLS, XLSX, and TSV files.
- Imports variable, grouped, and external products through a free add-on.
- Scans import files for structural errors before the import runs.
- Resumes interrupted imports.
- Saves field mappings as reusable templates.
- Pro supports formulas and custom PHP functions on mapped fields.
Cons
- Updating existing products requires Pro.
- Scheduled and recurring imports require Pro.
- Full WooCommerce product type support requires a second plugin.
- Automatic mapping applies only when file headers match WordPress or WooCommerce field names.
Reviews
- WordPress.org: 4.4 with 589 reviews
Price
WP Ultimate CSV Importer offers a free version on WordPress.org. Pro plans start at $199 as a one-time payment, and the Premium plan, which includes the full feature set, costs $299. All Pro plans cover unlimited sites.
Recommended For
Stores that want a free starting point for WooCommerce product imports and a one-time Pro license for updates and scheduling.
3. Woo Import Export
Woo Import Export is a premium plugin by VJInfotech, sold on CodeCanyon. It imports and exports WooCommerce products, orders, product categories, coupons, comments, and users. The plugin accepts CSV, XLS, XLSX, JSON, TXT, ODS, and XML files. Field mapping is done through a drag-and-drop screen.
Pros
- Imports CSV, XLS, XLSX, JSON, TXT, ODS, and XML files.
- Detects CSV delimiters automatically.
- Runs imports in the background, with pause, resume, and stop controls.
- Filters rows in the uploaded file before import.
- Pulls import files from FTP/SFTP, Google Drive, Dropbox, and OneDrive.
- Includes scheduled imports.
Cons
- Automatic mapping covers all fields only for files exported from Woo Import Export.
- Last updated on CodeCanyon in March 2025.
- The free Lite version on WordPress.org does not include WooCommerce imports.
- Support lasts six months unless extended at extra cost.
- The vendor lists support response times of up to five business days.
Reviews
- CodeCanyon: 3.94 with 194 reviews
- WordPress.org (WP Import Export Lite): 4.0 with 113 reviews
Price
Woo Import Export sells on CodeCanyon for $229 under a Regular License, which covers a single end product and includes six months of support. Extending support to 12 months costs $84. A free Lite version is available on WordPress.org, but WooCommerce imports require the premium plugin.
Recommended For
Stores that import WooCommerce orders, coupons, and users alongside products, or that source import files from cloud storage.
4. Import WP
Import WP is a freemium import and export plugin by James Collings. The free version imports posts, pages, taxonomies, users, and attachments from CSV and XML files. WooCommerce product imports run through a free WooCommerce add-on, and field mapping uses a visual data selector.
Pros
- Imports CSV and XML files from uploads, remote URLs, FTP, server paths, and Google Sheets.
- Imports simple, grouped, external, and variable products through a free add-on.
- Filters records before import.
- Supports custom PHP methods in field mappings.
- Skips unchanged records on repeat imports.
- Sets insert, update, and delete permissions per import.
Cons
- Automatic field population applies only to files exported from Import WP with default column names.
- Scheduled imports require Pro.
- Custom fields and custom post types require Pro.
- Excel files require a separate add-on.
- Pro licenses cover a single site and renew annually.
Reviews
- WordPress.org: 4.4 with 25 reviews
Price
Import WP offers a free version on WordPress.org. Import WP Pro costs $49.99 per site per year and includes 12 months of support and updates.
Recommended For
Single-site stores that import WooCommerce products from CSV or XML feeds and do not need scheduled imports.
5. Product CSV Import Suite
WooCommerce Product CSV Import Suite is a premium extension developed by Woo and sold on the WooCommerce.com Marketplace. It imports, merges, and exports products and variations using CSV files. Column mapping uses dropdown selections. Variations import through a separate variations CSV.
Pros
- Developed and maintained by Woo.
- Imports custom fields and custom taxonomies.
- Supports data from Product Vendors, WooCommerce Brands, WooCommerce Photography, and Google Product Feed.
- Updates existing products matched by ID or SKU.
- Exports draft products and limits exports by row count or offset.
Cons
- Column headers must match the extension's exact, case-sensitive format.
- Variations require a separate CSV file and import step.
- Imports CSV files only.
- No data transformation during import.
Reviews
- WooCommerce.com: 2.8 with 12 reviews
Price
Product CSV Import Suite is available on the WooCommerce Marketplace for $59 per year, or $94.40 for a two-year plan. Both plans include updates, customer support, and a 30-day money-back guarantee.
Recommended For
Stores that use supported Woo extensions such as Product Vendors or WooCommerce Brands and prepare CSV files in WooCommerce's column format.
Final Thoughts on the Best Plugins to Import WooCommerce Products from CSV
WP All Import is the best plugin to import WooCommerce products from CSV because it handles a clean catalog and a difficult supplier file inside the same import. Its Automatic Setup maps each recognized column without requiring a specific export format or header naming, and its drag-and-drop editor transforms values during the import when a file needs changes. Full WooCommerce product features require a paid package.
The other plugins on this list suit narrower needs. WP Ultimate CSV Importer offers a one-time Pro license for unlimited sites. Woo Import Export covers orders, coupons, and users alongside products. Import WP includes variable product imports through a free add-on and has the lowest-priced Pro plan. Product CSV Import Suite supports data from Woo extensions such as Product Vendors and WooCommerce Brands.
Import WooCommerce Products from CSV — Frequently Asked Questions
Can WooCommerce import products from CSV?
Yes. WooCommerce includes a built-in product CSV importer under Products › All Products › Import, which maps CSV columns to product fields and can update existing products matched by ID or SKU. The built-in importer does not transform values or filter rows during an import, so files that don't follow WooCommerce's column format need a dedicated plugin such as WP All Import.
How do I bulk import products into WooCommerce?
To bulk import products into WooCommerce, use WP All Import, which maps a standard product CSV automatically and creates every product in the file in a single run:
- Go to All Import › New Import and click Set up automatically.
- Upload the product CSV, or fetch it from a URL, an existing file, or an FTP/SFTP server.
- Select WooCommerce › Products as the import type.
- Click Start Automatic Setup to map the file's columns to product fields.
- Review the fields mapped and records to import on the Your Import Is Ready screen.
- Click Run Import to create the products.
How do I import variable products into WooCommerce from CSV?
To import variable products into WooCommerce from CSV, use WP All Import, which links each variation to its parent product through a parent SKU column:
- Go to All Import › New Import, upload the CSV, and select WooCommerce Products.
- Drag the title and description columns into the matching fields in the drag-and-drop editor.
- In the WooCommerce Add-On section, set the product type to Variable product.
- In the Variations tab, choose the option that links each variation to its parent through the parent SKU column.
- Map the variation attributes, such as size or color, in the Attributes tab.
- Continue to Import Settings, then click Confirm & Run Import.
How do I update existing WooCommerce products with a CSV?
To update existing WooCommerce products with a CSV, use WP All Import, which matches each record to an existing product by SKU and updates only the fields you select:
- Go to All Import › New Import and upload the revised CSV.
- Select Existing Items and choose WooCommerce Products.
- Set the import to match records to existing products by SKU.
- Map only the columns that contain changed data, such as price or stock.
- In Import Settings, choose which product fields the import is allowed to update.
- Click Confirm & Run Import to update the matched products.
How do I automatically import products into WooCommerce?
To automatically import products into WooCommerce, schedule the import to run at set intervals. WP All Import runs scheduled imports through server cron jobs or through its optional Automatic Scheduling service, which is configured inside the plugin. WP Ultimate CSV Importer and Import WP include scheduling in their Pro versions, and Woo Import Export includes it in the base plugin.
Best Plugins for Importing WooCommerce Products from CSV — Related Information
