The Best Plugins to Import Variable Products to WooCommerce
Importing variable products into WooCommerce with the wrong plugin has cost me hours of manually fixing broken products afterward. A single product with six variations can turn into six unrelated simple products with no parent or shared attributes. They just end up being six standalone listings with the same name and different prices, sitting in the catalog like six separate mistakes.
This is the most common issue when importing variable products into WooCommerce, and it occurs because the plugin performing the import lacks a reliable mechanism to link a variation row back to its parent. I ran the same test file through four import plugins to see which ones actually preserve that link, which ones need extra setup to get there, and which ones I wouldn’t trust with a real catalog.
Quick Comparison Table
| Plugin | Best For | Variation Mapping | Starting Price |
|---|---|---|---|
| WP All Import | Stores wanting variation fields mapped automatically for quick imports, with manual mapping available for more complex product structures | Automatic Setup auto-maps variation fields; drag-and-drop manual mapping supports parent SKU/ID, Group ID, title, or pipe-separated linking | $169/yr (WooCommerce Import Package) |
| WP Ultimate CSV Importer Pro | Stores preferring a one-time payment over a subscription | Visual, in-plugin dropdowns | Free (limited) / $299 one-time (full WooCommerce) |
| WP Import Export | Stores wanting import and export bundled without separate add-ons | Supports parent SKU, Group ID, title, or attribute-based linking | $249 one-time |
| WebToffee Product Import Export (Pro) | Stores needing a paid tier specifically to unlock variable products | Manual CSV syntax + WooCommerce-side setup | $69–249/yr (variable products require Pro) |
I built one test file with multiple variable products, each with several attributes and variations, and a unique image assigned to each variation. I ran that same file through all four plugins and watched for three things.
First, does the plugin map variation data through its own interface, or does it require hand-editing raw CSV syntax? Second, are there any preconditions the store needs to set up in WooCommerce itself before the import will work, or does the plugin handle that on its own? Third, does linking a variation to its parent allow selecting from a menu of supported methods (parent SKU, Group ID, title match), or does the plugin only support a single rigid structure?
I didn’t test general WordPress migration features beyond what’s needed for variable products. This article is strictly about getting variable products into WooCommerce cleanly.
4 Best WooCommerce Variable Product Import Plugins
WP All Import
WP All Import‘s Automatic Setup builds the field mapping for a WooCommerce variable product import automatically, without requiring any manual configuration first. For imports that need closer control, the plugin also offers manual mapping through a visual Attributes tab, with no fixed column names required.
My Experience Using WP All Import
I was excited to try out WP All Import for many reasons, and at the top of the list was its automapping feature. I ran my test file through Automatic Setup by uploading it, choosing the type of content I want to import, WooCommerce in this case, and selecting Products.
From there, it mapped the fields with a 98% confidence score, split into two groups: Core WordPress Fields (Post Title, Post Content) and WooCommerce Import Add-On fields (Product Type, Product ID matching, Parent Product ID, Product SKU, Regular Price). It also showed the number of records to be created before anything ran and gave me the option to review the full configuration first or run the import immediately. I ran it, and it completed without any hassle. The products were all added to the store with their variation dependencies preserved.
I also mapped the same file manually through the Variations tab, where I picked parent SKU matching as the linking method. WP All Import supports six ways to link a variation to its parent. The options include parent SKU or ID, Group ID, product title match, XML child elements, or pipe-separated values in a single row.
Manual mapping took a few minutes longer than Automatic Setup, but gave more direct control over which fields got matched to what.
What I Liked
- Mapped 19 variable product fields with a 98% confidence score and flagged the number of records that were ready to import, all before anything actually ran
- Imports variation-only files that don’t include a corresponding parent product row
- Offers multiple methods for linking a variation to its parent: parent SKU, parent ID, Group ID, title match, XML child elements, or pipe-separated values in one row
- Accepts files from multiple sources, including local upload, a direct URL, an existing file already on the server, or FTP/SFTP
- Reads various file types directly, including XML, CSV, Excel, Google Sheets, JSON, and TXT, plus ZIP or GZ compressed files
- The same setup process handled a handful of test variations and scales to a catalog of several thousand SKUs without switching tools
What I Didn’t Like
- The free version doesn’t include the WooCommerce add-on, so variable product import requires a paid tier
- Large imports can strain server resources on shared hosting
Pricing
WP All Import offers a free plugin on WordPress.org, though it doesn’t include WooCommerce variable product support. The entry point for variable products is the WooCommerce Import Package at $169/year. Store owners needing broader import add-ons can move up to the Import Pro Package at $199/year or the Import + Export Pro Package at $299/year, and a Lifetime License is available for a one-time $1,299 payment with no renewal fees.
Recommended For
Stores that want automatic mapping with a preview before committing to an import, and stores with supplier files that don’t follow one consistent structure.
WP Ultimate CSV Importer Pro
WP Ultimate CSV Importer Pro is the paid upgrade to Smackcoders’ free WP Ultimate CSV Importer plugin. Variable product import is available in the free plugin through a separate, free add-on called Import WooCommerce Suite. Pro adds the ability to update previously imported products and schedule recurring imports.
My Experience Using WP Ultimate CSV Importer Pro
WooCommerce product import wasn’t available with WP Ultimate CSV Importer Pro until I installed the free Import WooCommerce Suite add-on separately. Once that was active, I uploaded my test file and selected WooCommerce Products as the content type, which switched the interface into a WooCommerce-specific mapping screen. From there, I mapped SKU, price, stock, and attribute fields one at a time using drag-and-drop, since the plugin doesn’t include an automated mapping step.
An Advanced Mapping mode was also available for connecting source columns to fields more directly, which I used for a couple of attribute columns that didn’t line up cleanly with the default mapping view. Before running the import, Pre-Flight Validation checked the file’s structure and returned a File Health Score, flagging formatting issues ahead of time rather than after the import hit them. Once the import ran, I could review progress and completed records from the same screen, along with a log of what had been processed.
What I Liked
- Pre-Flight Validation checks file structure and returns a File Health Score before import
- Auto Recovery and Resume continues an interrupted import instead of restarting it
- Reads CSV, XML, Excel, TSV, and published Google Sheets links
- Migration and One-Click Import option for moving content between two WordPress sites
- One-time payment across all four pricing tiers, no subscription
What I Didn’t Like
- Variable product import requires installing a separate add-on before it’s available
- Updating previously imported products requires a paid tier
- Field mapping is done column by column, with no automated mapping option
Pricing
WP Ultimate CSV Importer Pro is a paid upgrade to Smackcoders’ free plugin, sold in four one-time-payment tiers: WooCommerce Import at $199, Custom Field Import at $199, WPML Import at $199, or Premium at $299, which combines all three. The free base plugin supports variable product import via the separate Import WooCommerce Suite add-on, but updating previously imported products or scheduling recurring imports requires a paid Pro tier.
Recommended For
Stores that want to generate or enhance product descriptions using a connected AI service during the import itself, rather than as a separate step.
WP Import Export
WP Import Export is a WordPress plugin for moving site data between installs, including WooCommerce products. Variation data links to a parent product through one of five available methods, including pipe-separated attribute values, parent SKU matching, or a shared Group ID.
My Experience Using WP Import Export
I ran my test file through the plugin on the live demo site. The interface looks modern at first glance, but it wasn’t especially intuitive to navigate. Notifications appeared throughout the process, one after another, and became distracting rather than helpful.
My file used parent SKU and variation SKU columns, so I selected the Parent SKU method for linking variations to their parent product. From there, mapping fields turned into a rather repetitive process: each field had to be clicked into, then out of, one at a time, to drag the corresponding column from my file into place. There was no way to map several fields in one continuous motion. By the time I finished, I wasn’t fully confident that every field had landed where it was supposed to.
I ran the import anyway. It completed without an error message, and the products appeared in the WooCommerce store afterward, though I went back to double-check a few of the variation fields given how uncertain the mapping process had felt.
What I Liked
- Reads multiple file formats including CSV, XLS, XLSX, XML, TXT, ODS, and JSON
- Offers multiple methods for linking a variation to its parent product
- The import completed and the products appeared correctly in the WooCommerce store
- Offers background processing with pause, resume, and stop controls
What I Didn’t Like
- Notifications appeared throughout the process and became distracting
- Fields had to be clicked into and out of one at a time to map each column, with no way to map several at once
- No live preview functionality to see how the mapped data will actually look before the import runs
Pricing
WP Import Export is free to install from WordPress.org. Variable product import is included in the free plugin. The Pro upgrade is a one-time $249 fee and includes all 17+ add-ons.
Recommended For
Stores that want every add-on included in a single purchase rather than several separate tiers.
WebToffee Product Import Export (Pro)
The free version of Product Import Export for WooCommerce does not support variable products; that’s only available in the Pro version. Variation data links to a parent product using specific column syntax: attribute and attribute_data fields, with visibility, position, and variation status encoded as pipe-separated values in the cell.
My Experience Using Woo Import Export
Before touching the plugin, I had to go into WooCommerce’s own attribute settings and enable “used for variation” on the attribute I planned to use, since the import doesn’t prompt for this or set it automatically. From there, I built my CSV with an attribute_data column for the attribute, formatted as three pipe-separated values in a fixed order: position, visibility, and variation status. Getting that order wrong on my first attempt meant going back to WebToffee’s own documentation to confirm the exact sequence, since the interface gives no indication of what’s expected in that cell.
Once the file matched the required format, I uploaded it through the plugin’s import screen and mapped the remaining fields.
Afterward, I checked the product page directly to confirm the variations had linked to the right parent, given how much of the setup happened outside the plugin’s own interface.
What I Liked
- Imports variable products, in addition to simple, grouped, external, and subscription products
- Reads CSV, XML, and Excel formats for variable product files
- Product images and gallery images import alongside variation data
What I Didn’t Like
- A file exported using WooCommerce’s own default export tool can’t be re-imported without manually altering the attribute columns first
- Variation data requires editing pipe-separated values directly in the CSV cell, rather than mapping through the plugin’s interface
- WPML support is limited to simple products, so variable product translations aren’t covered
Pricing
The free version of Product Import Export for WooCommerce is available on WordPress.org, but does not support variable products. The Pro version starts at $69/yr for one site, $129/yr for five sites, or $249/yr for twenty-five sites.
Recommended For
Stores comfortable formatting attribute data directly in a CSV file, since variation linking isn’t handled through the plugin’s own interface.
Which is the Best Plugin for Importing WooCommerce Variable Products?
Honestly, after running the same variable product data file through all four plugins, WP All Import is the one I’d actually use. Two of the other plugins made me go do something else first; flip a setting in WooCommerce, or sit there hand-editing a CSV cell with pipe symbols in it, before the variations would even link up right. WP All Import just took the file and figured it out.
And that’s really the whole test, when you get down to it. A plugin that makes you do prep work outside its own interface before it’ll handle the one job you bought it for isn’t saving you any time. WP All Import mapped everything itself, and when I switched over to manual mapping just to see how it handled a messier file structure, it still didn’t ask for anything the others required upfront. So if variable products are the actual task at hand, WP All Import is the one that gets out of your way and does it.
Common Questions About Importing Variable Products to WooCommerce
How do I import variable products into WooCommerce?
To import variable products into WooCommerce, use a plugin that maps variation data to a parent product, since WooCommerce’s own default settings don’t handle this automatically. Plugins like WP All Import handle this mapping directly, using either an automated setup or manual field mapping depending on the file.
How do I link product variations to a parent product in a CSV file?
To link product variations to a parent product in a CSV file, use a shared identifier across each variation row, such as a parent SKU, parent ID, or Group ID, depending on which method the import plugin supports.
Can WooCommerce’s built-in importer handle variable products?
No. WooCommerce’s built-in CSV importer requires two separate import passes to create a variable product: one to convert an existing product into a variable product with attributes, and a second to add the variation rows separately. WP All Import handles both steps in a single import, mapping the parent product and its variations together.
Can I import variable product variations without a parent product row?
Yes. Some plugins can generate the parent product automatically when a file contains only variation rows grouped by a shared identifier, such as a Group ID or a matching product title.
What is the best plugin for importing WooCommerce variable products?
WP All Import is the best plugin for importing WooCommerce variable products. Automatic Setup builds the field mapping without manual configuration, and six supported linking methods handle files with different structures without reformatting.
Further Reading
