Reduced by 1% when order is placed
Hurry up to get the best offer!
Rating 0 stars - 0 votes

How to Delete WooCommerce Products via Import

Recently, a question was asked on a WooCommerce forum: how to delete WooCommerce products via import? This is an interesting case indeed. When you receive a file from your supplier you may want to delete some product upon importing the file to your store. We’ve explored the case and described below how to accomplish this task.

Steps to delete WooCommerce products via import will be as follows:

Mark Products as Drafts to Delete Them via Import

Open the file in a spreadsheet editor. To mark products as drafts, find the Post Status column in your file and set value to “draft”. If there isn’t a Post Status column in your file, add it and populate it with necessary values - draft for products to be deleted, publish for products to be kept.

Here is how our sample file looks like:

WooCommerce Products Import Delete File

Save the file as .csv and go to the import step.

Import the file to your store via Store Manager for WooCommerce

Store Manager is a downloadable application that enhances the default functionality with tools for bulk edits, advanced import/export, database backup, data generation, and others.

If you don’t have Store Manager yet, download a free trial and install it on your computer. Connect the application to your store database and enjoy the simplicity of your store administration.

With Store Manager open, navigate to Catalog > Products > Import:

WooCommerce Products File Import Launch

In the import wizard, select the file and proceed:

WooCommerce Products File Import Select File

Select the delimiter character used in your import file. In our case, it’s a comma:

WooCommerce Products Import File Delimiters

Link fields from the file to the database fields:

WooCommerce Products Import File Fields Linking

Select the Add and Modify import option and proceed with import:

WooCommerce Products Import Option

Check the imported products in Store Manager:

WooCommerce Products File Imported Draft Status

Delete product drafts from your store

In Store Manager, find the column Post Status, expand the filter and select Draft:

WooCommerce Products File Imported Draft Filtered

Select the filtered product drafts and press Delete on the toolbar:

WooCommerce Products File Imported Draft Delete

Now when the drafts have been deleted, you have only the necessary products left in your store.

Try Store Manager for free to delete WooCommerce products via import and perform other kinds of tasks. Write it in the comments below if you have tried this approach to deleting products and if you still have any questions.

Delete WooCommerce Products via Import

Try now FREE
Related Articles:
Card image
Delete WooCommerce Products Without Import

Delete WooCommerce Products by Stock, Name, Date Modified, etc. Without Import Read More...

Card image
Import WooCommerce Products Preserving IDs

Import products to a new instance of WooCommerce preserving product IDs. Read More...

Card image
Merge Product Brand Name and Title Upon Import

How to add a brand name to a product title in WooCommerce via import. Read More...

Card image
Update WooCommerce Product Tags In Bulk

How to update WooCommerce product tags in mass using WooCommerce Product Tags Mass Changer.Read More...

Be the first to comment.