July 15, 2026
Do you want to know how to easily import WooCommerce products with attributes into your store?
Product attributes like size, color, material, and similar variations let customers filter your store’s catalog and find what they need faster. Importing WooCommerce products with attributes manually is slow and error-prone, often leading to inconsistent product data that confuses shoppers.
WP All Import removes the need for manual attribute entry with its Automatic Setup feature that detects and maps product fields, including product type, SKU, and variation data, without manual configuration. The plugin also offers a manual drag-and-drop interface for full control over attribute names, taxonomies, and variation logic. This article walks through both methods.
WooCommerce product attributes are specific characteristics of your products that make it easy for customers to find exactly what they need when shopping in your store.
They include features such as product size, color, material, brand, etc., which enable filtering through products in a WooCommerce store, so customers can make purchases aligned with their preferences.
Product attributes are especially useful for selling products with variations. This saves you the stress of creating individual products for each size, color, material, etc. your store offers. Additionally, they help boost your products’ SEO by improving keyword targeting and enabling them to be displayed as rich snippets when relevant.
WooCommerce product attributes are generally a powerful way to create richer product listings that are easy for customers to navigate, enhancing the shopping experience and increasing conversions.
Now that we know what WooCommerce product attributes are, let’s jump into how to import products with attributes!
In this section, we will show you how to import WooCommerce products with attributes using the leading WooCommerce and WordPress import plugin – WP All Import.
WP All Import imports every WooCommerce product type, including products with attributes and variations, through either an automatic field-mapping setup or a manual drag-and-drop wizard.
With the WP All Import plugin, you get two ways to import WooCommerce product data: Automatic Setup, which detects and maps fields without configuration, and a 5-step manual wizard for full control over field mapping. WP All Import imports from CSV, Excel, Google Sheets, and XML files up to 256MB per file.
WP All Import also includes:
The WP All Import plugin assures efficiency and ease in your WooCommerce product import processes, which is why it is our preferred choice for importing WooCommerce products with attributes.
To start the import process, you must first purchase and download the WP All Import plugin and its WooCommerce Import Add-On to get started.
Once you have done this, install the WP All Import plugin first, by going to your WordPress admin dashboard and navigating to Plugins › Add New Plugin › Upload Plugin › Choose File › Install Now › Activate Plugin. The plugin will immediately be installed and ready to use on your website.
Follow the same steps to install the WooCommerce Import Add-On. After this, you will be ready to create your first import of WooCommerce products with attributes.
To start an Automatic Setup import, go to All Import › New Import. On the New Import screen, click Set up automatically in the highlighted box at the top. WP All Import’s Automatic Setup opens on a file selection screen with four source options: uploading a file directly, downloading from a URL, using a file already in your account, or pulling from FTP/SFTP.
WP All Import accepts XML, CSV, JSON, TXT, ZIP, and GZ files up to 256MB through this screen.
Once the file loads, WP All Import presents its import categories: WooCommerce, Posts & Pages, Taxonomies, Users, and Comments. Selecting WooCommerce expands a second set of options: Products, Orders, Coupons, Customers, and Reviews.
Select Products, then click Start Automatic Setup. An optional Add Setup Instructions field is also available for specifying any details about the file’s structure before the automatic mapping runs.
After you click Start Automatic Setup, WP All Import analyzes the file and lands on a “Your Import Is Ready” screen showing how many fields it mapped from the file and how many records will be imported.
Clicking Field Mappings expands the full breakdown. For a simple product file, this includes Core WordPress Fields like Post Title and Post Content, along with WooCommerce Import Add-On fields such as Product SKU, Regular Price, Stock Quantity, Manage Stock, and Product Weight. WP All Import also detects and maps product attributes directly within this same breakdown, pairing an Attribute Name field with its corresponding Attribute Value.
From here, WP All Import offers Manual Setup, which switches to the manual drag-and-drop wizard covered in Method 2, and Run Import, which starts the import using the mapping Automatic Setup generated.
Clicking Run Import starts the import immediately. WP All Import displays a progress modal with the option to cancel mid-run.
When the import finishes, WP All Import reports how many records were created, updated, and skipped.
To create a new WooCommerce product import, go to All Import › New Import from your WordPress dashboard menu. This will bring you to the New Import screen with options to specify how you want to load your product import file.
WP All Import allows you to add your import file in three ways. You can upload the file from your PC, download the file from a URL or FTP/SFTP, or use a file that you have previously uploaded.
Load your import file using any of the provided methods.
The New Items option appears next, letting you specify the import type. Select WooCommerce Products and click Continue to Step 2 to proceed.
On the Review Import File screen, WP All Import offers a convenient way to review the product data you uploaded to be sure that everything has been detected correctly. You will see a notification of the number of rows that will be imported. You can use the gray left and right arrows provided to navigate between records and thoroughly review the data.
Scroll down the page to see the Manage Filtering Options panel. This panel lets you apply filters if you only want to import specific products from your import file to your WooCommerce store.
You can filter using any import file element, including product attributes. For example, if your product file contains some products with their attributes specified and some without, you can choose to import only products with attributes. You will do this by selecting the attribute column name as the Element and setting “is not empty” as the Rule. Then click Add Rule › Apply Filters to XPath, and the filter will be created.
Note that you will need to specify a Value for most filters. However, it is not required for the “is not empty” and “is empty” rules. You can also add multiple filters if needed.
Once you have reviewed your uploaded data and added relevant filters, click Continue to Step 3.
The Drag & Drop screen is where the most important steps of the WooCommerce product import process happen.
WP All Import provides a convenient drag-and-drop data mapping interface to simplify the product import process for users at any experience level. The mapping fields are listed on the left, while the incoming product data is in a table on the right.
Start by mapping your products’ title and description in the Title & Description panel. Simply drag the relevant elements from your incoming data table and drop them in the mapping fields provided.
The WooCommerce Add-On panel contains all the tabs for mapping the standard WooCommerce product details, including product attributes.
The first step is to specify the Product Type. WP All Import lets you import simple, variable, grouped, and external/affiliate products.
Once you have chosen your Product Type, the relevant tabs will be displayed, allowing you to map your product data into the appropriate fields. You can map the product SKU, Regular Price, and Sale Price from the General tab which is opened by default. Simply drag and drop the relevant elements into the provided fields.
You can follow the same mapping technique to map product fields in the Inventory, Shipping, Linked Products, Advanced & Add-On Options tabs.
We will focus on the Attributes tab the most for this article.
Open the tab and click the Add Attribute link to create a new Name and Value input field for each attribute you want to import.
Next, enter the attribute’s Name and drag and drop the incoming data element containing the value for the attribute into the Value field. If you have already created attributes in your store, enter the exact attribute name to ensure the imported value is correctly linked.
WP All Import provides Advanced options for each attribute you create, to define how they should be imported. These are:
You can define all options dynamically by enabling the Set with XPath selection.
Once you have created all your product attributes, you will see a Link all variations checkbox towards the bottom of the Attributes tab. It is unchecked by default, but you can select it only if the data for your variations is stored in a single row within a column, and you want WP All Import to auto-generate variations for various combinations of your product attributes.
That’s it! You have successfully mapped your product attributes.
The Images panel provides options to map your WooCommerce product images.
WP All Import lets you import your product images from any external source. You can download images from an external URL, use images already in your Media Library, or use images uploaded within a folder in your website’s backend.
To learn more about mapping product images, check out our guide on Importing WooCommerce Products with Images.
In the Custom Fields panel, you can import your product custom fields by specifying a Name and Value for each custom field.
You can learn more about it in our importing custom field data to the WooCommerce products guide.
The Taxonomies, Categories, Tags panel has fields for mapping your Product Category and Product Tag based on various options.
For more details on mapping this section, read our guide on how to Import WooCommerce Products with Categories guide.
Once you finish mapping all relevant fields, click Continue to Step 4 at the bottom of the screen to proceed to the next step.
The Import Settings screen provides additional options to configure how your product import should run.
Click the Auto-detect button to create a Unique Identifier for your import. The Unique Identifier is important as it helps WP All Import correctly link the records in the current import to those in an updated file if you re-run the import. This prevents duplicates and keeps your product data clean.
There are additional settings within the panel that you can leave as default or change if needed.
Scrolling down the screen will reveal the Scheduling Options and Configure Advanced Settings panels. Within the Scheduling Options panel, you will find settings to schedule your product imports to run automatically at specific times and days of the week. You can learn more about import scheduling from WP All Import’s documentation.
The Configure Advanced Settings panel provides settings for optimizing the speed of your import. The default selections work for most imports, but you can tweak it if necessary.
Once done, click Continue to move to the next step.
We’ve now reached the final step of importing WooCommerce products with attributes!
On the Confirm & Run screen, WP All Import provides a high-level summary of all the import settings you have applied. This lets you double-check that you have applied the correct settings for your import to run without glitches.
If you notice any mistakes, you can go back to change the settings. Otherwise, proceed with the import by clicking the Confirm & Run Import button.
The import process will start immediately and should be completed within minutes. Once it’s complete, you will see an Import Complete notification.
Check that your products and their attributes were imported successfully by navigating to Products › All Products and clicking a few products to review the imported data.
A product file with a hundred attribute values used to mean a hundred manual entries, checked one at a time for typos and mismatched terms. WP All Import’s Automatic Setup reads the file and maps attribute names and values to the correct WooCommerce fields, with the results ready to review on the same screen.
The manual wizard is still there, and for good reason. A file with inconsistent naming, attributes that need to feed into specific variations, or a structure that Automatic Setup didn’t quite guess right on still calls for the drag-and-drop control covered in Method 2.
Neither choice locks a store out of the other. Clicking Manual Setup from the Automatic Setup results screen carries the same file straight into the manual wizard, so testing the faster path first costs nothing but a few seconds.
To import products with custom fields in WooCommerce, you need to have the WP All Import plugin and its WooCommerce Import Add-On installed on your site.
To import variable products into WooCommerce, WP All Import maps variation fields automatically through Automatic Setup. On a variable product file, Automatic Setup detects Product Type as variable and maps Parent Product ID alongside other fields like Product SKU and Regular Price, without manual field configuration.
WP All Import’s manual wizard is also available for direct control over the mapping:
To bulk import products into WooCommerce, use WP All Import; every import it runs handles multiple products in a single pass, whether the file has ten rows or ten thousand. WP All Import’s Automatic Setup analyzes a bulk file and maps its fields without manual configuration, while advanced features like filtering (importing only a subset of products) and automatic scheduling (running imports on specific days and times) remain available for more controlled bulk workflows.
To export and import products in WooCommerce, download and install the WP All Import & WP All Export plugins on your site.
Get maximum flexibility with unlimited licensing and domain activations.
Get your money back within 60 days of purchase, no questions asked. It's risk-free!
We offer premium support to ensure the ultimate customer experience.
For a limited time, we're offering an unlimited site license for just $199.99/year. Buy now to lock in this price.