How To Import Attributes for WooCommerce Variable Products
Do you want to import WooCommerce products with attributes?
If you sell variable products on your WooCommerce store, you already know how crucial attributes are for your products. Without them, customers have limited options, which ultimately drives them to shop with your competitors, who have a wider range of selections. This means lost business for you and lower profit margins.
However, when you need to add hundreds or thousands of variable products with attributes to your WooCommerce store, it can be challenging to do it manually. It’s time-consuming and inefficient. This is why it is important to know how to import variable WooCommerce products with attributes to your store easily.
In this article, we break down how to import attributes for WooCommerce variable products with the leading WooCommerce product import plugin – WP All Import.
What Are Product Attributes and Why Do They Matter for Variable Products?
Product attributes define specific features and characteristics of your WooCommerce products to describe them better to customers. These could include features such as color, size, material, etc. This gives customers a broader range of selections and makes filtering through the product catalog easy.
Attributes are important for variable products as they are used to create variations. For example, if you sell mobile devices in your store, a device can have attributes such as storage space (16GB, 64GB, 128GB, etc.), color (black, space gray, white, etc.), and brand (Apple, Samsung, Huawei, etc.).

These attributes can then inform variable pricing. For example, a 64GB device will not cost the same as a 128GB device. It also makes it easy for customers shopping on your site to filter by brand, color, and storage space to find exactly what they need.
Now that we have explained WooCommerce product attributes and their usage in variable products, we will discuss how you can import them in the next section.
How To Import Attributes for WooCommerce Variable Products
While WooCommerce provides a native importer tool, it is not recommended for importing variable products as it has limited support for complex product types. You need a third-party plugin to import WooCommerce products with attributes. In this article, we will use the WP All Import plugin.
The WP All Import plugin is the best WooCommerce product import plugin. It offers Automatic Setup that inspects your spreadsheet on upload, detects variation attributes like size and color, and links parent-child products automatically without manual column matching.

Some of its exciting features include:
- WP All Import imports product attributes from CSV, XML, Excel (.xlsx, .xls), and live Google Sheets URLs up to 256 MB without requiring file format conversions.
- Support for importing all WooCommerce product types, including variable products.
- Automatic Setup inspects incoming spreadsheets on upload to detect product variations and map global taxonomy attributes (like size, color, and brand) automatically.
- Powerful filtering tool to import a specified subset of your products to your store.
- A built-in PHP function editor allows store owners to execute inline PHP functions directly on attribute terms and price fields during the import.
- WP All Import lets you preview products in both WP Admin and Frontend View to verify attribute dropdowns and product galleries.
- Support for importing other WooCommerce data types, including orders, customers, etc.
- Support for importing other WordPress post types such as users, pages, etc.
- Scheduling tool to run recurring imports automatically on pre-defined days and times.
- Support for importing products with custom fields, and more.
To import WooCommerce products with attributes to your site with WP All Import, first, you must purchase and install the plugin and its WooCommerce Import Add-On. The WooCommerce Import Add-On is necessary for importing all WooCommerce product types and data.
After purchasing and downloading them on your PC, go to your WordPress dashboard and navigate to Plugin › Add New Plugin. Start by installing the WP All Import plugin. Click Upload Plugin › Choose File › Install Now › Activate Plugin.

Follow the same steps to install and activate the WooCommerce Import Add-On.
Once both have been installed and activated, you can now create a new import of WooCommerce products with attributes.
1. Create a New WooCommerce Attribute Import
To create a new WooCommerce product attributes import, go to All Import › New Import from your WordPress admin menu.
On the new page that opens, click the Set up automatically banner to open the automated import wizard.

On this screen, you can load the import file of your WooCommerce products with attributes. WP All Import provides three options for this. You can Upload a file (from your PC), Download a file (from a URL or FTP/SFTP), or Use existing file (if you have previously uploaded the import file).

Once you have loaded your import file, select WooCommerce, then choose Products (Simple, Variable, Grouped). You can also add specific instructions about your product import file to let WP All Import understand it better.

Once everything is configured, click the Start Automatic Setup button. WP All Import analyzes your spreadsheet, detects variation attributes, determines the parent-child structure, and maps your product fields automatically.
2. Review Mapped WooCommerce Product Data
Once analysis completes, WP All Import displays a Your Import Is Ready summary card showing the detected import type, total record count, number of fields mapped, and an overall confidence score.

Below the summary card, scroll through the Field Mappings list to verify that your variation attributes are assigned accurately.
If you need to apply filters or adjust settings before running the import, click Manual Setup to open the pre-filled template editor.
3. Filter Uploaded Product Data
To access WP All Import’s powerful filtering tool, scroll down the screen and click the Back to Create Filters button. Within the Manage Filtering Options panel, you can create multiple filter rules for various elements in your import file. This lets you control which products will be imported to your WooCommerce store.
For example, if your import file contains a mix of simple and variable products, you can create a filter to import only products with variations. To do this, select the product type as the Element for your filter, set the Rule as equals, and input variation (or whatever name you have in your import file for variable product types) as the Value. Next, click Add Rule › Apply Filter to XPath, and the filter will be created.

Click Continue to Setup Import to move to the next step.
4. Review Mapped Product Data in WooCommerce Fields
Because Automatic Setup analyzes your file on upload, the template editor opens with your product fields already mapped. You don’t have to build the template from scratch; instead, this screen allows you to review the auto-mapped fields, verify attribute settings, or make fine adjustments before running the import.
Your incoming product data is displayed in the data tree on the right, while the target WooCommerce fields are arranged in panels on the left. If you ever need to change a mapped field, you can simply drag a different element from the right panel into the target field on the left.
Title & Description
Automatic Setup pre-fills the Title and Description fields using the corresponding columns from your import file. You can review the mapping, adjust the text formatting, or drag additional elements into these fields if you want to include extra details in your product descriptions.

WooCommerce Add-On
Open the WooCommerce Add-On panel to review your core product configurations.
Automatic Setup automatically sets the Product Type to Variable product, which displays the specialized variable product tabs on the left.
Under the General tab, confirm that the SKU, Regular Price, and Sale Price fields are mapped to their respective data elements.
You can also check the Inventory and Shipping tabs to ensure stock quantities, backorder rules, and shipping classes are configured as desired.

Import WooCommerce Product Attributes
Open the Attributes tab to review the attributes mapped for your variable products. Automatic Setup automatically detects your attribute columns (such as size, color, or material) and fills in their Name and Value fields.
If you are importing data into an attribute that already exists on your site, ensure that the name matches the existing attribute. You can also add more attributes by clicking the Add Attribute link.

Under each attribute, click Advanced to review additional options that define how WP All Import handles your attributes.

The options are:
- Variations: Enables or disables the use of an attribute in variations. In Variations is selected by default for variable products. You can also define this dynamically by selecting Set with XPath.
- Visibility: Sets whether the attribute is visible on the frontend product page (Is Visible is enabled by default).
- Taxonomy: Determines whether to import the attribute as a global taxonomy attribute (Is Taxonomy) or as a custom product-level attribute (Not Taxonomy).
- Auto-Create: Controls whether newly found attribute terms are created during import (Auto-Create Terms is enabled by default).
Import WooCommerce Variable Products
Open the Variations tab to confirm how your variable products are grouped.
Automatic Setup inspects your file structure and automatically selects the matching variation grouping option. WP All Import provides six options for grouping product variations into a single variable product, whether your file contains both parent and child rows or flat variation rows with no parent products.

Each option includes a visual example of the file structure. Because Automatic Setup selects the correct method and maps the linking fields (such as Parent SKU or Group ID) for you, you typically only need to confirm that the matching logic looks correct.
You can learn more about the six variation grouping options in the documentation for How to Import Variable Products into WooCommerce.
Import Variable Product Images
In the Images panel, you can verify how your product photos are imported. Automatic Setup selects the appropriate image sourcing method (such as downloading external image URLs or linking existing Media Library files) and maps the image elements into the provided fields.

To learn more about mapping the data in the Images panel, read the article on Importing WooCommerce Product with Images.
Import Product Custom Fields
If your products contain custom metadata, open the Custom Fields panel. Automatic Setup can auto-detect custom fields from previously published products on your site and map the incoming values automatically. You can also manually add field names and drag elements into their values.

To learn more, read the article on How to Import Custom Field Data to WooCommerce.
Import Product Taxonomies, Categories, and Tags
The Taxonomies, Categories, Tags panel contains the settings for product categories and tags. Automatic Setup maps your category and tag columns automatically, including hierarchical category structures.

This article on how to import WooCommerce product categories provides more details on this panel.
Once you have reviewed all the pre-mapped fields, scroll to the bottom of the screen and click Continue to Import Settings.
5. Apply Additional WooCommerce Product Import Settings
The Import Settings screen provides additional settings for optimizing your product import process.
The first setting is the Unique Identifier, which Automatic Setup configures using the Auto-detect button. The Unique Identifier ensures that WP All Import correctly links records in your import file to those in your database, preventing duplicate products and enabling clean catalog updates if you re-run the import later.

You can keep the default selections for the remaining options in this panel, as they are configured to work well for most product imports.
Below, you will see the Scheduling Options and Configure Advanced Settings panels.
The Scheduling Options panel contains settings for WP All Import’s powerful scheduling tool. It is not relevant to this import, so we will not go into detail. However, you can read the Run WordPress Import on a Schedule documentation to learn more.
The Configure Advanced Settings panel includes options to adjust batch processing sizes and optimize the speed of your import. WP All Import sets the recommended values by default, so you can leave them as is unless your server requires custom timeout limits.

Click Continue to proceed to the final confirmation screen.
6. Verify and Run WooCommerce Product Attribute Import
The Confirm & Run screen is the last step of the process of importing WooCommerce products with attributes using the WP All Import plugin.
On this screen, WP All Import provides a summary of all the settings you have applied for your import. Review them to be sure your import will run without issues. If you notice any errors, go back and fix them before proceeding.

If there are no issues, click the Confirm & Run Import button to start the import process.
Once the import is completed, you will see an Import Complete notification.

Verify your imported products by navigating to Products › All Products. Open the product tab for a few products to double-check that all the data was imported successfully.

Import WooCommerce Products With Attributes – FAQs
How Do I Import Products With Custom Fields in WooCommerce?
To import products with custom fields in WooCommerce, download and install the WP All Import plugin and its WooCommerce Import Add-On, then follow the steps below:
- Navigate to All Import › New Import and click the Set up automatically banner.
- Upload the import file of your products with custom fields.
- Choose WooCommerce Products as the import type.
- Click Start Automatic Setup to let WP All Import detect and map your custom fields automatically.
- Run the import and verify the imported products with custom fields from the All Products page.
How Do I Import Variable Products Into WooCommerce?
You can import variable products into WooCommerce with the WP All Import plugin and its WooCommerce Import Add-On. After installing and activating them on your site:
- Go to All Import › New Import and click the Set up automatically banner.
- Upload your product import file and select WooCommerce Products as the import type.
- Click Start Automatic Setup to automatically detect variation attributes and link parent-child products.
- Run the import and the variable products will be imported to your store.
How Do I Import Bulk Products Into WooCommerce?
To import bulk products into WooCommerce, install WP All Import and its WooCommerce Import Add-On on your site, then follow the steps below:
- Navigate to All Import › New Import and click the Set up automatically banner.
- Upload the import file (CSV, Excel, Google Sheets, or XML).
- Select WooCommerce Products as the import type.
- Click Start Automatic Setup to map product fields, prices, and stock automatically.
- Run the import and your products will be bulk-added to your WooCommerce site.
How Do I Export and Import Products in WooCommerce?
You can export and import products in WooCommerce with the WP All Export and WP All Import plugins. First, install and activate the plugins on the source and destination sites, then follow the steps below:
- Use WP All Export on the source site to export your product data as a Bundle file.
- On the destination site, go to All Import › New Import, click Set up automatically, and upload the Bundle file.
- The bundle automatically configures the import settings, allowing you to run the import with zero manual mapping.
Get Oxygen
Build it your way with Oxygen.
Not per year, not per site, not per seat. 60 day money back guarantee.