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?
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.
- Select a file to be imported from one of the three sources
- Select option to delete products in the store
- 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:
- Navigate to the WebToffee Import Export (Pro)
- Click on the Import sub-tab, you will be taken to the ‘Import’ page
- Select ‘Product’ post-type to import
- 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
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.
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.
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.
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.
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.
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.
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.