How to Delete Products in Bulk via CSV in WooCommerce

Last updated on August 24, 2021

How to Delete Products in Bulk via CSV in WooCommerce

Sometimes you will want to delete your products in bulk. The most common method to achieve this is by selecting all the products you want to delete from the Product page and then performing the bulk action by moving products to trash.

But if you have hundreds and thousands of products to delete, the above-mentioned method will be tiresome. This is where the second, simple and effective method comes into play. The extension plugin Product Import Export Plugin For WooCommerce will be very useful to delete products via the CSV effectively.

How to Delete Products through CSV import?

First of all, install Product Import Export Plugin For WooCommerce to your WooCommerce store and activate the plugin

Make sure that you have the file, that doesn’t have any of the products that needed to be deleted, in your computer, another server, or in any other location accessible via URL.

Now, follow the steps given below and you can easily delete products in bulk through CSV import.

  1. Select a file to be imported from one of the three sources
  2. Select option to delete products in the store
  3. Map imported columns to product data fields and Import

Step 1: Select file to be imported from one of the three sources

Log into your account and use the sidebar navigation menu to:

  1. Navigate to the WebToffee Import Export (Pro)
  2. Click on the Import sub-tab, you will be taken to the ‘Import’ page
  3. Select ‘Product’ post-type to import
  4. Select a source of the file to be imported 
  • Method 1: Select a file from your computer
  • Method 2: Provide FTP details
  • Method 3: Enter the URL of the file
window to upload csv file

Select a file from your computer

By using this method you can select a file(less than 1GB size) from your computer by clicking on the Choose file button. Then, select the file that needs to be imported.

Provide FTP details

This method helps you to import products from another server via FTP. For that enable FTP import and fill out all the necessary fields as shown below.

choose or add ftp profile

Method 3: Enter the URL of the file

Provide the URL of the CSV where it can be downloaded from within the Enter the URL of the file text field. It is to be noted that the URL should be a public URL for it to be accessed for files for importing.

Example: https://www.webtoffee.com/wp-content/uploads/2017/05/Product_WooCommerce_Sample_CSV.csv

field to enter URL to import the CSV file

From the above three methods select one of the convenient methods and follow the steps below.

Step 2: Map imported columns to product data fields and Import

After uploading the CSV file containing products you need to move to the next step Import – Map Fields page. Here you can 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. 

import mapping section

Step 3: Select the option to delete products in the store

In the next step, the Advanced Options section. You will find an option to Delete non-matching products from store. 

advanced options for import

By choosing ‘Yes’ you will be able to delete existing products in your store that are not present in the CSV. 

Now you can click on the import button.

import complete popup

After, click on the Submit button you can see the progress of the import as given below

Once you have successfully imported the products you will get rid of all the existing products in the store.

Conclusion

By following these simple steps you will be able to delete hundreds of products easily and quickly along with importing new products at the same time. Learn about getting started and working with the plugin from the plugin documentation.