How to Quickly Import Products in WooCommerce

Are you looking to bulk add products to your WooCommerce site?

If you’re launching a new eCommerce store or expanding your existing catalog, manually adding hundreds of products can be an overwhelming and time-consuming task. Fortunately, WooCommerce includes various plugins that streamline this process.

In this comprehensive guide, we’ll explore how to quickly bulk-import products using a WooCommerce import plugin. But before we look at the step-by-step guide, let’s first explore the best product import plugins available for WooCommerce.

Best WooCommerce Bulk Product Import Plugins

To help you quickly import products into WooCommerce, here are some of the best plugins you should consider using.

1. WP All Import

WP All Import is the best plugin to quickly import WooCommerce products because Automatic Setup maps your catalog data, variation attributes, and pricing on upload without requiring manual column matching. While there are plugins that specialize only in importing products, WP All Import supports all WooCommerce data types. The plugin features an automatic setup wizard and an intuitive drag-and-drop template editor to make it easy, even for beginners, to quickly import multiple products into your store. It supports all product types, including variable products, and lets you upload CSV, Excel, Google Sheets, and XML files. Unlike other plugins, it doesn’t force you to follow a specific format while creating your import file and lets you edit it during the import process using the various built-in PHP functions.

Key Features

• Supports CSV, Excel, Google Sheets, and XML file formats.
• Import all product types, including variable and subscription products.
• Integrates with SEO plugin and custom fields.
• Advanced filtering options for precise import control.
• Scheduled recurring imports for automated product data updates.

Pricing

WP All Import starts at $169/year for the WooCommerce Import Package and can be used on unlimited websites.

2. Product Importer Deluxe

Product Importer Deluxe is part of the WooCommerce plugin package that focuses on the import and export of WooCommerce data. It includes automatic field mapping when the column names in your spreadsheet match WooCommerce product fields. It gives you flexible import options that let you skip specific rows, set import range, or control import speed to manage server load effectively.

Key Features

• Supports CSV, TXT, and TSV file formats.
• Multiple image import options, including external URLs.
• Handles simple, variable, external, and subscription products.
• Option to update existing products or add new ones.

Pricing

Product Importer Deluxe comes in a package with a store exporter plugin and costs $158/year.

3. WooCommerce Product CSV Import Suite

WooCommerce Product CSV Import Suite is developed by WooCommerce and supports importing products from a CSV file. It integrates and works seamlessly with various WooCommerce extensions. The plugin not only allows you to import products but also supports exporting them. However, one drawback is the strict requirements for CSV file formatting, which may require additional preparation of import data.

Key Features

• Compatible with various WooCommerce extensions.
• Support for special product data such as vendors and brands.
• Export feature for full or partial product data.

Pricing

WooCommerce Product CSV Import Suite is available for purchase from the WooCommerce marketplace for $59/year.

How to Bulk Upload Products in WooCommerce

Now that we’ve covered the best plugins, here is the step-by-step process for bulk uploading products to WooCommerce using WP All Import.

We’ve chosen this plugin for our tutorial due to its user-friendly interface, powerful features, and flexibility in handling various import scenarios.

Similar to any other premium WooCommerce plugin, you need to:

1. Buy the WP All Import plugin along with its WooCommerce Import add-on.
2. Download the plugin’s zip files to your computer.
3. Log into your WooCommerce site’s backend and go to the Plugins page.
4. Click on Add New › Upload Plugin and choose the plugin file you just downloaded in the previous step.

5. Click on Install Now › Activate.
6. Follow the same process to install and activate its WooCommerce Import add-on plugin.

Once everything is set up, let’s walk you through the process of importing products using WP All Import.

Step 1. Create a New WooCommerce Product Import

To start the import process, move your mouse cursor to All Import in your WordPress navigation menu and click on New Import. At the top of the screen, click the Set up automatically banner to open the automated import wizard.

WP All Import will give you options to load your import file, which can be in CSV, Excel, and XML format.

Choose your file by either uploading it from your computer, downloading it from a URL, or selecting an already uploaded file on your server. Once you’ve uploaded your file, move to the next step. 

Next, choose to import new items and select WooCommerce › Products as the import type.

Click Start Automatic Setup to allow the plugin to analyze your catalog data and configure field mapping automatically.

Step 2. Review Uploaded Data and Run Automatic Import

Once the analysis finishes, WP All Import presents a summary card showing the detected import type, total record count, number of fields mapped, and an overall confidence score.

Take a moment to review this summary. You can scroll through the Field Mappings list right inside the card to verify that core WordPress fields, WooCommerce pricing, SKUs, images, and variation attributes were identified correctly.

From here, you have two clear paths:

• Run the import as-is: If the file is straightforward and the summary card looks accurate, you can click Run Import to import your products immediately with zero manual mapping.
• Review and fine-tune: If you want to preview live product pages, add filter rules, or inspect the field mappings before committing, click Review Import Configuration.

Step 3. Add Product Filters

Clicking Review Import Configuration opens the template editor, fully pre-filled with the auto-detected mappings. From this screen, you can inspect and adjust every detail.

If you only want to import a specific subset of products (like items where stock is greater than zero), click the Back to Create Filters button at the bottom of the screen.

Expand the Manage Filtering Options panel and start adding your filter rules. Each rule consists of three fields. You can select the Element and Rule value from the dropdown, and for the Value field, enter the exact value you want to apply the filter by.

Then, click the Add Rule button and then click Apply Filter to XPath to apply your filter rule. This will update the total records at the top. You can also add multiple filter rules to the same import and combine them using AND and OR conditions.

This feature can be particularly useful for large imports or when you need to update only a subset of your product catalog.

Once your filters are set (or if you don’t need any), return to the template editor to review the mapped product fields.

Step 4. Inspect WooCommerce Product Field Mappings

On the left, you’ll see the different WooCommerce fields categorized into different panels, and on the right, your import data is presented in an XML/CSV tree.

Automatic Setup has already filled in the appropriate tags for you, but you can customize anything by dragging elements from your data file to the corresponding fields on your left. You can review essential details like product title, description, and short description.

To inspect other fields, expand the WooCommerce Add-on panel. You’ll see an interface similar to when you add a product manually in WooCommerce, with tabs for General, Inventory, Shipping, Linked Products, Attributes, and more.

WP All Import supports all popular product types such as Simple Products, Subscriptions, Grouped Products, External Products, Variable Products, and more. Automatic Setup detects the correct product type automatically.

If you’re importing variable products, the Variations tab will already be active and configured with the detected variation matching method. You can click through each of the tabs to verify or fine-tune any auto-mapped fields.

Before moving forward, click Preview in the header. The preview modal provides two helpful views:

• WP Admin View: Shows exactly how incoming data will populate backend WooCommerce fields.
• Frontend View: Renders a live product page with working image galleries, pricing, and functional variation dropdowns, allowing you to click through records and verify edge cases before publishing.

When you’re happy with the preview, click Continue to Step 4 to configure the final settings.

Step 5. Extra Import Settings

In this step, you’ll configure how WP All Import should handle your data during import. 

The first setting is to set a unique identifier for your products. This is important to prevent duplicate product import and enable future re-running of the same import.

You can set the Unique Identifier automatically by clicking the Auto-detect button or manually by dragging the fields from the table. The auto-detect option is easy and works well most of the time.

The unique identifier panel also has other options which let you decide how the plugin should behave on subsequent imports; whether to create new products, update existing ones, or delete products no longer present in your import file.

The next panel is the Scheduling Options panel and it lets you set recurring imports. This is beneficial when you need to regularly import products without manual intervention.

The Scheduling Options doesn’t work when you upload a local file and you’ll need to either load the data from a URL or select the file from your server. To learn more, WP All Import has a documentation article that explains the scheduling option in detail.

There’s also an advanced settings panel, which lets you configure some import speed optimization settings and other additional import settings.

After configuring all of the settings, click the Continue button to move to the last step.

Step 6. Confirm and Run the Product Import

The final step is to review your import settings and run the import. WP All Import will present you with a summary of your import configuration. Take a moment to double-check everything before clicking the Confirm & Run Import button.

The plugin will then start the import process and start adding products to your WooCommerce store. The plugin may take a few minutes, especially for large imports or if you’re downloading many images. It shows a real-time progress bar with the number of products imported. 

Once complete, you’ll see a confirmation screen with details about how many new products have been created and if any of the existing products have been updated.

After the import finishes, it’s important to verify your newly imported products. Navigate to the Products page in your WooCommerce dashboard to review the imported items.

Check that all details, including variations, product images, and pricing, have been correctly added.

Import Products into WooCommerce – Frequently Asked Questions

How Do I Bulk Upload Variable Products in WooCommerce?

1. Go to All Import › New Import and click the Set up automatically banner.
2. Select your import file and choose WooCommerce Products as the import type.
3. Click Start Automatic Setup to allow the plugin to detect variation attributes and link parent-child rows automatically.
4. Click Manual Setup if you want to inspect or fine-tune mapped attributes in the template editor.
5. Run the import.

How Do I Bulk Add Products From Excel to WooCommerce?

To import products from an Excel file, just select the Excel file as your import source in the All Import > New Import page. WP All Import will recognize the file format and will automatically adjust its interface accordingly.

How Do I Upload Bulk Products to WooCommerce From Google Sheets?

WP All Import accepts a Google Sheets URL directly through its Download from URL option. Publish your Google Sheet to the web, copy the share link, paste it into the import screen, and the plugin will fetch and import your product data without requiring a CSV conversion.

Can You Import Orders Into WooCommerce?

WP All Import is a powerful all-in-one WooCommerce import plugin and it supports different data types including WooCommerce Orders. Go to All Import › All Import, upload your order data file, and select the import type as WooCommerce Orders. Follow the rest of the steps of the wizard to complete the import process.