How to Bulk Upload Products in WooCommerce

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

If you have a huge amount of products that you want to upload to your WooCommerce store, manually entering the products and its details are far from practical. Using Product Import Export Plugin for WooCommerce, you can upload all the products and product types (simple, variable, grouped, and external) in bulk with incredible ease.

Most people opt for maintaining a spreadsheet or CSV file of product data. It makes the manipulation of the data easier on a larger scale. To upload products to your WooCommerce store, Product Import Export Plugin for WooCommerce takes a CSV file as input. If you have the details of the products in a spreadsheet, we have to convert the spreadsheet into a CSV file.

If you have your products and the details about the products in a spreadsheet, then all you need to do is change the format of the file to CSV file by adding the extension .csv to the file. The articles on Importing WooCommerce Products from Microsoft Excel File and the article Importing and Exporting Products to Google Spreadsheets will help you more on how to bulk import products from these two popular spreadsheets.

Another important factor when using a CSV file with Product Import Export Plugin for WooCommerce is that it should be UTF-8 encoded.  Scary it may sound, but you can refer to this article, Saving CSV/Excel File as UTF-8 Encoded, to know how simple it is to do so and encode your spreadsheet by yourself.

When you want to bulk upload the products to a WooCommerce store using a CSV file, what you are essentially doing is importing the products in the CSV file into the WooCommerce store. So, to import the CSV file, go to the WooCommerce store, install and activate Product Import Export for WooCommerce.

After the plugin has been activated, navigate to the WooCommerce store dashboard and then go to WooCommerce > Product Im-Ex. This will take you to the Product Import Export plugin page.

From this page, go to the Product tab, then click on Import. It will take you to the Import page.Product import section

From the Import page, you can see that there are three different methods to import the products from your CSV file into the WooCommerce store.

  1. By uploading the CSV file from your local computer
  2. By providing the FTP Details
  3. By entering the URL of the CSV file

1 – By Uploading the CSV File From Your Local Computer

In this method, you can upload the products using the CSV file saved on your local computer. Click on the Choose File button to upload the CSV file from your computer to import the products to your CSV file.Product import method 1 - Upload file from computer

2 – By Providing the FTP Details

In this method, you can select the CSV file from your FTP server. Enter the FTP details in the given spaces.Product Import method 2 - Upload file via FTP

To import a CSV file from the remote server using FTP, first enable the checkbox for FTP import/export. Next, give the following details.

  1. FTP Server/ Host IP: Here you enter your FTP hostname.
  2. FTP Username: In this field, enter the FTP username.
  3. FTP Password: Enter the FTP password.
  4. FTP Port: Enter the FTP port number.
  5. FTP Server Path: Enter the FTP server path.
  6. Use FTPS: Check this option to enable FTPS, a secured extension of FTP.

Next, click on Test FTP, to check whether you have a working FTP connection. Then, the plugin will fetch the CSV file from the server and import it into the WooCommerce store.

3 – Enter the URL of the File

In this method, you can enter the URL of the CSV file from where the CSV will be downloaded and the products in the CSV will be imported into the WooCommerce store.product-import-method3-provide-url

Next, as you scroll down, you have the following additional options that you gives you much more flexibility over the products that are imported.

  • Select a Mapping File – if you have already saved a mapping file, you can choose the mapping file from here. Mapping files are created by mapping the column header of the CSV file to the product data fields.
  • Update Products if Exists – Check this box to update the existing products with the same SKU with the data in the CSV file.
  • Skip New Products – Checking this box will skip all the products that are not already present in the WooCommerce store.
  • Delimiter – Select the delimiter that is used in the importing CSV file.
  • Merge Empty Cells – Check this box to merge empty cells in the CSV.
  • Delete Existing Products – Checking this option will delete all the products that are not already present in the CSV.
  • Use SKU to link Upsells and Cross-sells – By checking this options, upsells and cross-sells will be linked using the product SKU.
  • Disable Thumbnail Generation – Checking this box will disable the regeneration of thumbnails on import.
  • New Product Status – This option overrides the statuses of all the products in the CSV.
  • Use SKU to Link Grouped Products – Check this option to link grouped items using SKU.

After the import options have been configured to meet the requirements, scroll down and click on Upload file and import button.

Next, you have the Map Fields page, where you map the CSV file to the WooCommerce data fields. Mapping is required to ensure that the column headers in the CSV file match with the corresponding WooCommerce data fields.Product import map fields

If you already have a mapping file, then you can choose the mapping file and then click on Submit. You will see a screen that will show the progress of the import.Variable product import successful

After the import is successful, you can view the products on the products page of your WooCommerce store. This way you can easily upload products to your WooCommerce store using Product Import Export Plugin for WooCommerce.

Visit the product page for more details about the plugin. Learn about getting started and working with the plugin from the plugin documentation.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

2 thoughts on “How to Bulk Upload Products in WooCommerce

  1. mmrs151
    mmrs151 says:

    Hello,

    I am trying to import 60K products, the file is about 100 MB, it is almost 17 hours and only 40% import is done.

    We need to import about 100K product each night and it is currently far from reality.

    How can we achieve this.

Leave a Reply

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