Blog

Bulk add products to WooCommerce: How to quick add multi products to WooCommerce stores (2 ways)

Bulk add products to WooCommerce
Table of Contents

Do you have a large number of new products that you need to import quickly on your WooCommerce store? It is not surprising if you are looking for the fastest way to bulk add products to your online shop. Generally, you have two ways to quickly import a large number of products to the WooCommerce site: the first method is to import the Excel file of products to WooCommerce, and the second method is to use the WooCommerce products bulk edit pro plugin. In this ultimate guide to bulk add products to the WooCommerce, we explain both and show you the easiest method for quick add multi products to the site.

Bulk add products to WooCommerce by importing an Excel file

If you have the list of your products ready in an Excel file prepared in the format accepted by WooCommerce, bulk add products to your online store in the fastest possible way. In this method, you don’t need to install any plugin, and you can add your products to the site with just a few clicks.

But the main problem is preparing the Excel file. To prepare this file, you have to insert the information of each product manually into the file, which is a very time-consuming task.

Another problem is entering the product data in the correct format, which must exactly match the WooCommerce default format. In this guide, we also share with you the solution to fix these problems.

Let’s see how, in 3 steps, you can bulk add products to WooCommerce by importing the right Excel  format file.

Step 1: Export a default WooCommerce product format

If you have a complete list of products, it is better to first sort them in an Excel file for the sake of simplicity, this sorting will make it easy to insert all the products. But if you don’t have the WooCommerce product default format, don’t worry. You can simply export this default format from your WooCommerce site by following the below instructions:

  1. In the WordPress dashboard, go to Products > All Products and press the Export button.
Export a default WooCommerce product format
  1. In the new page, you have to set the below configurations:
    • Which columns should be exported: You can choose all columns or mark as many columns as you need in the list.
set final export products CSV file configurations
  • Which product types should be expected: It is possible to export all types of products or choose one of them, like grouped, variable, external, etc. from the list.
  • Which product category should be exported: In this field, you can choose all categories or one of them from the list to export the products related to it in the Excel file.
set export products type in configurations page
  • Export custom meta: If you want to export custom fields as well, mark “Yes,…
  1. Press Generate CSV to download the default format of the WooCommerce Excel file
Export WooCommerce products to a CSV file - final step

Step 2: Preparing the Excel file of products

Now, you have the default Excel format – like below- for preparing your products list and bulk add products in WooCommerce. 

Open WooCommerce products list in Excel

Let’s suppose that we want to insert information to the Excel file from the below picture:

enter images code information in Excel file

The exported CSV file columns with the value which you can assign are as follows:

Product fieldValue in the Excel fileOur example
IDID number
TypeProduct types like simple, Variable, …
SKUSKU numberKim-28810
NameProduct name as textSurgical …
Published0 or 1
Is featured?0 or 10
Visibility in catalogVisible or leave emptyVisible
Short descriptionTextHalyard Heart …
DescriptionTextHalyard Heart …
Date sale price startsdate format like 2023-08-12
Date sale price endsdate format like 2023-08-12
Tax statusTaxable or leave it emptyTaxable
Tax class
In stock?0, 10
StockStock quantity as number
Low stock amountnumber
Backorders allowed?0, 10
Sold individually?0, 1
Weight (kg)number 0.001
Length (cm)number 60
Width (cm)number40
Height (cm)number 100
Allow customer reviews?0, 1
Purchase notetext
Sale pricenumber
Regular pricenumber16
CategoriesText, use comma as a separator and > for subcategories Medical> Mask, Medical
TagsText, use comma as a separator
Shipping class
ImagesURL, use comma as a separator if there are more URLs for product gallery As illustrated in the below picture
Download limitnumber
Download expiry daysnumber
Parenttext
Grouped productstext
Upsellstext
Cross-sellstext
External URLURL
Button texttext
Position
Download
AttributesText, taxonomy term hierarchy is denoted with > while terms are separated with commas
Enter product image URL in images column of CSV file

Important points to consider when preparing the Excel file:

  • Sort products by ID. For example, for 100 products, put IDs from 1001 to 1100. With this, creating URLs and image IDs for importing to the Excel file is easier.
  • The information such as name, title, short description, description, and price must be inserted exactly as a text or number.
  • All site images must be named according to the ID number of products. (For example, for the product with the ID 1001, set the name of the featured image as 1001 and the gallery images as 1_1001 and 2_1001) and then enter all of them into the WordPress media (WordPress menu > Media > Add New). Now, you can copy the URL of one of the products and then replace the ID of the images and place it in the Excel file under the image column.
  • For true or false values, use 1 or 0 (respectively). 
  • Separate multiple values with commas.
  • Denote hierarchy with >.
  • Save the CSV file in UTF-8 format. 

Step 3: Import the product list from the prepared CSV file

When the CSV file has been prepared, you can go to the All Product page and press the Import button.

Now, to bulk add products in WooCommerce using the product file, proceed with the following:

  • Press the Choose file button and upload the Excel file from your system.
  • If you want to update some data in the products that you have already added to WooCommerce, mark Update existing products.
  • Press the Continue button.
Choose final CSV file to import products, in upload csv file page
  • On the next page, you can match the columns of the CSV file with the WooCommerce field. To do this, you need to open the dropdown list in front of each field and choose one of the CSV columns. If you have edited the default format of WooCommerce exported from your website, you can ignore this step. 
set products fields in column mapping page
  • Press the Run the importer button.
  • Wait some minutes to let the plugin import data from your file.
Importing WooCommerce products process
  • In the end, when you see a message like below, you can make sure that you have bulk add products to WooCommerce, successfully.
Completing import WooCommerce products from CSV file

Although bulk add products to WooCommerce by getting help from this complete guide is successfully possible, it is really time-consuming and frustrating. Store managers usually don’t have enough time to edit the data of Excel files manually, especially when they need to import a lot of products quickly into their stores.

If you are in the same situation and looking for a quick and easy solution, let’s introduce the WooCommerce products bulk edit pro plugin, which is a handy tool for bulk adding products in WooCommerce efficiently.

Bulk add products to WooCommerce by using WooCommerce products bulk edit plugin

The WooCommerce products bulk edit plugin is a useful and practical tool for managing WooCommerce products that you can easily work with their options without any need to write codes or use Excel files.

By getting help from this plugin, bulk editing any WooCommerce field, like categories, prices, images, etc., is quickly possible. In this plugin, all products of your website are displayed in a table where you can make changes to each of them individually or in bulk. This plugin supports 40+ WooCommerce product fields and all custom fields for filtering and bulk editing. In addition to bulk editing, you can bulk add products in WooCommerce with just one click.

In the following, we review the simple steps of quick add multiple products with this plugin:

Step 1: Download and install the plugin

The first step to using WooCommerce products bulk edit is to download and install it on your WordPress website.

After activating the plugin, go to the WordPress dashboard and navigate to the below address:

IT bulk editing > Woo Products

Here, you can find a list of all products in a table with all the necessary tools you need to manage your products in a toolbar above the table.

Step 2: Bulk add new products to WooCommerce 

To quick add multiple products, click on the + button of the toolbar.

Bulk add new products to WooCommerce using WooCommerce products bulk edit plugin

Now, you can see a pop-up asking you to insert the number of new products you want to add to your online store.

You can type any number in this box, or use the Up and Down arrows on the right corner to increase/decrease the number.

For example, we wrote 20 in the box to bulk add 20 new products in WooCommerce.

Enter how many new products to create

As soon as pressing the Create button, 20 new products are added to WooCommerce with empty fields. So, in the next step, you need to use one of the editing methods to assign data to the WooCommerce fields of these products.

Step 3: Edit new product fields

One of the amazing features of the WooCommerce products bulk edit plugin is displaying all products in an editable table. So, when you bulk add new products in WooCommerce, all of them are listed in the table, and you have access to different tools to edit their data directly in the table or by using a comprehensive bulk edit form.

Edit new product fields in WooCommerce products bulk edit plugin

Let’s review these tools briefly.

First method: Inline edit newly added product fields

The easiest method for editing the product fields directly in the table is Inline Edit. Let’s make some examples to see how inline editing works in our plugin.

Example 1: Inline edit WooCommerce product name

Suppose that the list of your products is like below, and you want to change the name of the first new product to Food Dish.

Inline edit  product name in Excel

To do this, follow the below steps:

  • Open the Column Profile form and mark Product Title to add this column to the table.
  • Find the product you want to change its name in the table.
  • Click on the related cell in the table.
  • Type Food Dish.
  • Press Enter on the Keyboard. 
Inline edit WooCommerce product name in WooCommerce bulk edit products plugin

That’s it. You easily changed the product title in the table.

Example 2: Inline edit WooCommerce product description 

In this example, we want to insert the below description to the table for one of the new products.

inline edit product description in Excel

As we mentioned before, first, we need to add the product description column to the table by using the Column Profile form.

Then, we can easily copy the description by CTRL + C.

Then, click on the Description Cell of the targeted product in the table to see the below pop-up page.

inline edit WooCommerce product description in WooCommerce bulk products editing plugin

Now, by pressing CTRL + V, we can paste the copied description in the text area.

By pressing the Apply Changes, the description is assigned to the given product as we expected.

Method2: Bulk edit multi product fields

The bulk edit method is useful when there is some similar data to be added to multiple products at once.

To bulk edit WooCommerce products, you can follow the below instructions:

  • Mark some of the products in the table.
  • Press the Bulk edit icon on the Toolbar. 
  • Find the field you want to edit in the Bulk Edit form.
  • Make your desired changes and press the Do Bulk Edit button.
Bulk edit WooCommerce multi product fields

Now let’s make some examples to see how you can bulk edit the data of newly added products very quickly.

Example 1: Bulk edit multi product category

Let’s suppose that you want to add some of the newly added products in the Accessories category.

Bulk edit multi product category in Excel

As we mentioned before, you need to select some products and then open the bulk edit form, now:

  • Go to the Categories/Tax/Taxonomies tab.
  • Find the Product Categories field. Choose Append in the Operator field then choose Accessories from the categories list. 
Bulk edit multi product category in WooCommerce products bulk edit plugin
  • Press the Do Bulk button.

As you can see in the below picture, the Accessories category is appended to the selected products.

Result category column in WooCommerce bulk edit products

Conclusion

If you are a WooCommerce site manager, you must have faced the problem of bulk adding new products to your WooCommerce store. Fortunately, the WooCommerce products bulk edit pro plugin solves this problem for you with the below amazing features:

  • A very simple user interface allows you to add as many products as you want with one click. 
  • Various advanced bulk edit tools help you to import all product data in a few minutes.

Leave a Reply

Your email address will not be published. Required fields are marked *

Shopping cart
Sign in

No account yet?

We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies.

Start typing to see products you are looking for.